Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Performance Analysis based on Wait Events

Author  Topic 

Lijo Cheeran Joseph
Posting Yak Master

123 Posts

Posted - 2011-04-07 : 02:41:45
Hi Team,

I am looking for a performance analysis tool that is based on Wait Events. My target is to bring “Average Wait Time” under 500ms.

Can you please suggest some good free tools for SQL Server 2005 performance analysis based on Wait Events?


Thanks
Lijo Cheeran Joseph

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2011-04-07 : 03:47:02
Per suggestion in your other post...use "SQL Profiler". It comes with the product. You will however have to learn how to use it yourself (or pay somebody to train you). Rarely does anything ready-to-use come for free.
Go to Top of Page
   

- Advertisement -