Is SQL Server activity slowing down your .NET code?

Understanding how your .NET program is interacting with SQL Server is a tricky business. Redundant or inefficient database calls can easily slip into your code, and tracking them down might take hours or days, if you're lucky enough to even know they exist. Not anymore.

• ANTS Performance Profiler records all SQL Server activity on the local server, allowing you to pinpoint which queries are causing performance problems.
• The interactive timeline at the heart of ANTS Performance Profiler displays both the level of SQL activity and detailed performance metrics. View the stack trace and understand the entire environment at the precise time of an erratic database call.
• There's no need to stop profiling to examine the results: by updating SQL data on demand, ANTS lets you analyze database activity without ending your profiling session.

Is your .NET code working with SQL Server the way it should? Download your free 14 day trial to find out.

Over the weekend, we rolled out a few speed improvements to the Stack Overflow engine. First, we did a quick pass with ANTS Profiler and identified a few places where redundant or unnecessary database queries slipped into our code. We like to do this every few months on common pages as a sanity check.

Jeff Atwood, Stack Overflow