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

home
community
view story

6 Kicks

Profiling cubed: Profiling SQL and disk activity with .NET code(www.red-gate.com)

submitted by Red Gate 8 months, 13 days ago

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.

2 comments |category: Community |Views: 106
Tweet

tags: Community another

Everyones tags:

Your Tags:

Please login or signup.

Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

"Kick It" text
"Kick It" background
kick count text
kick count background
border

Simply copy and paste this HTML into your blog post.

Users who kicked this story:

BILE_GRAN_CORREA(0) -

Bile0Gran0Vieira0Correa(0) -

mhardy(183) -

dpeterson(4397)

More who kicked this story...

Comments:

posted by vijayst(1311) 8 months, 12 days ago +2

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

posted by dpeterson(4397) 8 months, 12 days ago 0

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.

Most Active Users

What's this?