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 的大作中提到】
: 大部分是替其他公司面试的, 大部分是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 的大作中提到】
: 大部分是替其他公司面试的, 大部分是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 的大作中提到】
: 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 的大作中提到】
: 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 的大作中提到】
: 大部分是替其他公司面试的, 大部分是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 的大作中提到】
: 大部分是替其他公司面试的, 大部分是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 楼
赞!继续努力乐在其中!
相关阅读
如何把某些行的某个列(unique)的值加1?转Oracle DBA,求建议这个cassandra paging的解决方案怎么样? (转载)How to Start the Career as Data ScientistUse a query to list the table names in the HR database schema??【技术讲座】Power BI Report Server【工作机会】SQL DBAcopy database from one server to another in IBM netezza Agi (转载)Mysql无法远程连接,求助Re: 安心家庭厨房本周六开始为您送饭 (转载)why my local desktop audit found domainSQLServerMachine$ logon record?Tech Session: How to start learning Hadoop请教一个SQL 面试题新手Oracle数据库一问免费讲座 Power BI on Cloud求救,升级mysql后table not existTableau 自学问题it转行做finance 今天被it气晕了急需一名DBA 熟悉数据库, 软件和硬件请看老土受害学生 (转载)