Performance testing SQL Server 2000

[wbodger]

Ok, I currently have 2 db servers. Neither of them great, but one has SCSI and the other has SATA. My sysadmin wants me to switch to the newer SATA setup, not believing a good SCSI RAID setup would really be any better then a SATA RAID setup for our OLTP DB. So, I want to show him some performance numbers from those two servers and I realized I really have no idea how to go about doing that. So, could somebody point me to perhaps some free software and/or what I need to do to get those numbers?

Thanks,
Willie

 

[mrdenny]

Use SQLIO to get the maximum throughput potential for the servers. And use Perfmon to gather the throughput numbers.

You can read more about SQLIO over on SQLServerPedia.com.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

 

[wbodger]

Great, thanks!