SQL Server config - high I/O - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

SQL Server config - high I/O

Author

Topic

alexmarshuk
Starting Member

12 Posts

Posted - 2011-05-17 : 04:27:56

Hi guys,

i am writing a technical test and have come up with mixed answers for the following question:

How would you setup a Microsoft SQL Server cluster for business critical databases with especially high I/O.

can you guys give me your opinion on the 'best' answer?

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2011-05-17 : 13:38:20

There isn't really a 'best' answer. The way to approach the problem is by absorbing information about suitable architectures for high IO - and developing a solution. An answer could consider IO configurations for :
CPU Cores
Windows
SQL Server
Cache
FC HBA
FC HBA
Fibre Channel Switch
Storage Controller
Storage Controller Cache
Disk
LUN

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources