Max I/O - SQL 2005

[qsac]

Anyone know the max I/O's for SQL 2005?

i know this is a very broad question and is very hardware specific. I just have been searching for some sort of a hard number from microsoft.

Thanks
Q

 

[ptheriault]

Have a look at Slava Oks Weblog. There is some very good stuff there about CPU IO.

http://blogs.msdn.com/slavao/

This is a good link about Storage IO

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/storage-top-10.mspx

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[mrdenny]

SQL can support what ever IO speed the hard drives can support. I've seen IO numbers up towards the 10k range per disk.

SQL doesn't have a limit on the amount of IO that it can generate. Your bottlenecks will either be the physical disks, or the CPU before SQL stops sending requests to the disk.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com