CODEWITHSUNDEEP
sqlsql-server
LCJ
LCJ

Reputation: 22662

SQL Server: Performance Analysis based on Wait Events

I am looking for a performance analysis tool (for SQL Server 2005) 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?

Upvotes: 0

Views: 583

Answers (1)

Remus Rusanu
Remus Rusanu

Reputation: 294387

Waits and Queues is a methodology (hence a free tool) that handles exactly this situation.

Upvotes: 2

Related Questions