Grant Fritchey (8/17/2012)
That's interesting. I didn't know SQLIO was gone. Hmmm... Maybe they just renamed it. It never should have been called SQLIO in the first place, just IO. It never tested databases or SQL Server, but primarily the disk sub-system. Measuring the machine is useful to validate what the vendor told you, but not really necessary for establishing a baseline or doing load testing.As far as load testing, my latest & greatest favorite toy is the Distributed Replay tools in SQL Server 2012. They do a great job either taking an existing trace and replaying it or creating an artificial load and then smacking the server around with it. That's what I use to test things out today.
Thanks for replying Grant. I have to say that I'm shocked that no one else has replied. Considering the question I was certain a number of regulars would have posted a reply about SQLIO having disappeared from Microsofts web site if noting else. There are numeorus postings on the wbe and here at SSC that all reference SQL I/O so its usprising to see no one (other then you) is suprised by SQL I/O's disapearence.
Do you know if the tools in SQL 2012 you mention will work on a SQL Server 2005 instance?
BTW - We are using SQL 2005 because the vendor whose software we use does not yet support a higher version of SQL Server then 2005. They are moving to support of 2008R2 and we will be upgrading to that in a few months but till that happens we have to continue onwards using SQL 2005.
Thanks again for replying.
Kindest Regards,
Just say No to Facebook!