Response Time Analysis using Extended Events

This tool demonstrates Response time analysis at the session or statement level including waitstats using the new Extended Events infrastructure in SQL Server 2008. This tool is based on the simple principle:

Response time = service time + wait time

This tool allows you to drill down on the time spent in serving the user requests and the time spent in waiting for resources.

Download the application and documentation from Follow the User Guide to install and use the tool. The download also contains the source code for the project.

Last edited Apr 24, 2009 at 9:20 PM by sanjaymi, version 4


Raoul_Illyes May 13, 2009 at 10:01 AM 
Sorry, what i tried to say was that it could be valid for the user to decide the session trace name, something to be taken into consideration for futher releases

Raoul_Illyes May 13, 2009 at 9:58 AM 

The reason why not allowing the user to decide the Session trace name is because of the risk of name conflicts with other trace sessions.
This is not to say that it could be valid or a good idea.
Thank you for your input.

fiacre May 6, 2009 at 1:23 PM 
Nice tool but should usp_wta_start and usp_wta_stop both take the same parameter @session_id rather than the user having to generate the task name?