Any Good Tool

  • 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.

  • 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: http://dineshasanka.spaces.live.com/

  • 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.

     

  • 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