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 楼
赞!继续努力乐在其中!
相关阅读
dba interview 都问些啥感谢GOOGLE (转载)Is Microsoft's SQL Server really cheaper than Oracle? (ZZ)ibm rdp和oracle,大家都用哪个?求助:关于SQL Server的问题诚心求助!(VBA for Excel)SQL Server Replication怎么老RECOMPILE啊job Sr. Informatica Development Position 转自猎头求助,backup/disaster recovery plan.CBT Nuggets 70-432的VIDEO讲座请教各位专家请问如何实现这样一个db2的query, 谢谢湾区公司招 MySQL Database Administratorjobhunting版出的乱子这个版要借鉴一下准备考70-433Business Intelligence Developer面试怎么准备?Access 数据库查询求教: 想考ORACLE证书,拿哪个证书合适Any firm looking for DBMS on cloudSSRS report failing to display dataset string