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
 General SQL Server Forums
 New to SQL Server Programming
 No of IOs

Author  Topic 

avmreddy17
Posting Yak Master

180 Posts

Posted - 2006-03-14 : 13:48:36
What is the best way to test for how may IO's sql server can handle for a give configuration.....

Does any one have any script to test the IO's?

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-03-14 : 14:20:11
SQLIO is what I would try first

http://www.microsoft.com/downloads/details.aspx?FamilyId=9A8B



-ec
Go to Top of Page

MichaelP
Jedi Yak

2489 Posts

Posted - 2006-03-14 : 16:03:26
I've also used IOMeter to find how much IO my disk subsystem can push.

http://www.iometer.org

Michael

<Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda>
Go to Top of Page
   

- Advertisement -