May 26, 2005 at 9:52 pm
Does any body know good tool for SQL Server monitoring. I am looking for tool which can detect deadlocks, locks, DiskIO, memory and other performance parameters for spids through out the day.
May 27, 2005 at 4:10 am
Coefficient of imceda is an award winning woftare on this subject. so you can use it.
http://www.imceda.com/Coefficient_Download.htm
My Blog:
May 27, 2005 at 1:10 pm
Coefficient certaintly is an execellent tool for analyzing performance on a SQL Code and Stored procedure level. It will detect things like deadlocks and poorly designed SQL queries.
For a real time hardward level monitoring solution, take a look at Spotlight for SQL Server from Quest Software. Spotlight will monitor hardware statistics like disk I/O levels, memory and buffer utilization, etc...)
Let me know if you have any more specific questions.
May 29, 2005 at 1:04 pm
Also consider http://www.idera.com/Products/SQLdm/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply