z*y
2 楼
大部分是替其他公司面试的, 大部分是senior level.大部分题目是工作中遇到的。大
部分都是open
question.
第一题来了:
In a two-node clustering environment configured as Active/Active. Each node
has only one sql server instance running on it. One day system administrator
manually fail over one instance to another node in order to apply system
patch.
After several minutes DBA get alert that the available virtual memory on the
fail over node is very low, question:
1. How to solve this issue?
2. What is your best practice to A/A clustering en
部分都是open
question.
第一题来了:
In a two-node clustering environment configured as Active/Active. Each node
has only one sql server instance running on it. One day system administrator
manually fail over one instance to another node in order to apply system
patch.
After several minutes DBA get alert that the available virtual memory on the
fail over node is very low, question:
1. How to solve this issue?
2. What is your best practice to A/A clustering en
j*n
4 楼
1. adjust AWE
2. more RAM
btw, A/P model is much safer.
2. more RAM
btw, A/P model is much safer.
c*d
6 楼
1.
因为是A/A,所以在failover的时候
failover node要hold failed node的memory
这样的话failover node有可能内存不足
导致virtual memory is low
解决办法是设置Max server memory
2.
设置每个节点的max server memory
保证总和不超过任意一个节点的physical memory
or
增加ram
lz公布一下答案吧,再来几道题给大家做做
node
administrator
the
【在 z***y 的大作中提到】![](/moin_static193/solenoid/img/up.png)
: 大部分是替其他公司面试的, 大部分是senior level.大部分题目是工作中遇到的。大
: 部分都是open
: question.
: 第一题来了:
: In a two-node clustering environment configured as Active/Active. Each node
: has only one sql server instance running on it. One day system administrator
: manually fail over one instance to another node in order to apply system
: patch.
: After several minutes DBA get alert that the available virtual memory on the
: fail over node is very low, question:
因为是A/A,所以在failover的时候
failover node要hold failed node的memory
这样的话failover node有可能内存不足
导致virtual memory is low
解决办法是设置Max server memory
2.
设置每个节点的max server memory
保证总和不超过任意一个节点的physical memory
or
增加ram
lz公布一下答案吧,再来几道题给大家做做
node
administrator
the
【在 z***y 的大作中提到】
![](/moin_static193/solenoid/img/up.png)
: 大部分是替其他公司面试的, 大部分是senior level.大部分题目是工作中遇到的。大
: 部分都是open
: question.
: 第一题来了:
: In a two-node clustering environment configured as Active/Active. Each node
: has only one sql server instance running on it. One day system administrator
: manually fail over one instance to another node in order to apply system
: patch.
: After several minutes DBA get alert that the available virtual memory on the
: fail over node is very low, question:
f*g
7 楼
有趣!
更喜欢第一个,如果能稍微简洁一点,就更好啦(紫色的线条阴影,略感觉有些花了)~
更喜欢第一个,如果能稍微简洁一点,就更好啦(紫色的线条阴影,略感觉有些花了)~
z*y
8 楼
我说过,大部分都是open question。 但是coolbid回答我较钟意。
我一般设置每个instance 最大内存为每个节点内存的40%.
其他的Coolbid 已经回答的完美了!
【在 c*****d 的大作中提到】![](/moin_static193/solenoid/img/up.png)
: 1.
: 因为是A/A,所以在failover的时候
: failover node要hold failed node的memory
: 这样的话failover node有可能内存不足
: 导致virtual memory is low
: 解决办法是设置Max server memory
: 2.
: 设置每个节点的max server memory
: 保证总和不超过任意一个节点的physical memory
: or
我一般设置每个instance 最大内存为每个节点内存的40%.
其他的Coolbid 已经回答的完美了!
【在 c*****d 的大作中提到】
![](/moin_static193/solenoid/img/up.png)
: 1.
: 因为是A/A,所以在failover的时候
: failover node要hold failed node的memory
: 这样的话failover node有可能内存不足
: 导致virtual memory is low
: 解决办法是设置Max server memory
: 2.
: 设置每个节点的max server memory
: 保证总和不超过任意一个节点的physical memory
: or
s*d
10 楼
谢谢分享,如果能有参考答案就更完美了.
node
administrator
the
【在 z***y 的大作中提到】![](/moin_static193/solenoid/img/up.png)
: 大部分是替其他公司面试的, 大部分是senior level.大部分题目是工作中遇到的。大
: 部分都是open
: question.
: 第一题来了:
: In a two-node clustering environment configured as Active/Active. Each node
: has only one sql server instance running on it. One day system administrator
: manually fail over one instance to another node in order to apply system
: patch.
: After several minutes DBA get alert that the available virtual memory on the
: fail over node is very low, question:
node
administrator
the
【在 z***y 的大作中提到】
![](/moin_static193/solenoid/img/up.png)
: 大部分是替其他公司面试的, 大部分是senior level.大部分题目是工作中遇到的。大
: 部分都是open
: question.
: 第一题来了:
: In a two-node clustering environment configured as Active/Active. Each node
: has only one sql server instance running on it. One day system administrator
: manually fail over one instance to another node in order to apply system
: patch.
: After several minutes DBA get alert that the available virtual memory on the
: fail over node is very low, question:
z*y
12 楼
木有标准答案。
a*p
13 楼
mm真有才,这是拿什么软件设计的?
f*n
14 楼
真可爱,LZ是专业平面设计的阿!
p*a
15 楼
专业
t*a
24 楼
赞!继续努力乐在其中!
相关阅读
求助access大牛有谁给讲讲Database和xml import/exporthelp!!! who's familiar with mysql commandOracle OCM 有多牛?急问:怎么去掉MS SQL数据库中的重复记录?aks a simple SQL questionA SQL question请问SQL,VBA等有什么证书可以考?ACCESS的测试题借人气一问MySQL和C的接口?How to set mysql server to autostart as booting如何用MFC连接search engine?请问关于tpc-H生成的data读取问题,数据库的大侠们帮帮忙啊!Question on create a database in DB2 MySQL Quietly Drops Support For Debian Linux(ZZ) (转载)sql2005exp的db在vs2005ide连不上?再请教一个问题:stored procedure能不能直接显示信息什么的? (转载)请教SQL Server 2005 reporting service的大拿Oracle 10gR2 10.2.0.2 for linux X86