Profiling cubed: Profiling SQL and disk activity with .NET code

added by bsenoff

9/13/2011 12:57:46 AM

248 Views

The first step in improving application performance is understanding current performance bottlenecks as completely as possible. Profiling3 looks at SQL Server interaction and file system activity side by side with code performance, letting you examine your application from every angle.

Read the full story

2 comments

vijayst

9/13/2011 8:06:44 AM

Profiling code (line by line) as well as SQL Queries is especially very useful when we are using LINQ to SQL or Entity Framework.

dpeterson

9/13/2011 9:12:05 AM

I haven't had a chance to evaluate this myself, but I've had to diagnose performance problems in SQL Server many times and it's usually the "shotgun approach" to debugging. I generally have to try out everything, capture lots of sql and statistics from the profiler, munge through the results looking for the biggest offenders, then run those queries through the analyzer to figure out how they can be improved (if it's not obviously a poorly written query). Once that's done: wash, rinse, repeat.
If this can save me 75% of that work, I'd be a happy man.