SQL Server Profiler Analysis

What is it ?

An application to help makes sense of SQL Profiler traces containing the RPC:Completed (10) event (i.e. calls to stored procedures from an application).

For each stored procedure call in the trace, the application provides,

  • Number of times called
  • Average for duration, reads, writes, or cpu
  • S.d. for duration, reads, writes, or cpu
  • Best single call in terms of  duration, reads, writes, or cpu
  • Worst single call in terms of  duration, reads, writes, or cpu
  • Total duration, reads, writes, or cpu
  • Percent out of total for duration, reads, writes, or cpu

See screenshot below.

The application reads SQL Profiler trace information from a db table.  Trace must contain,

1 or more RPC:Completed events

The following fields,

  • CPU
  • Reads
  • Writes
  • Duration
  • Object Name

Download application

Troubleshooting

The application has a dependency on SQL Server Management Objects.

2008 SMO can be downloaded here – http://www.microsoft.com/en-us/download/details.aspx?id=3522.  See section Microsoft SQL Server 2008 Management Objects.

As you read this far, you should follow me on twitter here.