May 4, 2006 at 9:03 am
I am running SQLIOSTRESS on my XP machine before I run it on the Server. It looks like it will run another 4 hours.. How can I safely KILL IT ??????
ALso, I downloaded the installer for SQLIO from Microsoft and I'm going to give that a try.. What I'm trying to do is do some benchmarking before troubleshooting a slow SQL Server - Are these the best tools to use?
I tried running Perfmon to capture some Server AND Sql Server data but I can't figure out how to save the data in PerfMon so I can compare later..
Any suggestions!!!?????!!!!
May 5, 2006 at 12:14 pm
For your XP machine, just kill it (or reboot). There should be no ill effects. As for diagnosing a slow SQL Server here's my 'short list' for tuning:
Round I
DBCC UPDATEUSAGE
UPDATE STATISTICS (with FULL scan) for all tables
exec sp_recompile for all tables
exec sp_refreshview for all views
Round II
DBCC DBREINDEX
UPDATE STATISTICS (with FULL scan) for all tables
exec sp_recompile for all tables
exec sp_refreshview for all views
Round III
Profiler
Query Hints
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply