发信人: zenny (智勇张肥头), 信区: Database
标 题: sql server 面试题 （3）
发信站: BBS 未名空间站 (Mon Oct 27 09:56:06 2008)
这是一道SQL Server failover clustering 安装问题：again, open question:
1. Now we are planning to install 64 bit sql server on a two node A/P
clustering environment with SANS. The OS is windows server 2003 on IA-64 .
The db is OLTP db and has the initial size of 650GB. The storage engineer
will create the LUN, what are the requirements you might give to him (RAID
2.The server has totally 16 CPU cores, in order to optimize the performance,
how many tempdb data files you would suggest to create? Would it be okay I
give the initial tempdb size as 2GB and filegrowth of 10%?,unlimited?
3.Tell me what would you do as part of post-installation of sql server 2005
in this senario, give me at least five items.
这是我们组去年招DBA team lead 的问题。 答案不重要，思路重要！
多说几句哈， 对dba 来说，经验比知识重要， 如果单纯讲知识， 我们google就行。
※ 来源:·WWW 未名空间站 海外: mitbbs.com 中国: mitbbs.cn·[FROM: 12.174.]