.NET and SQL Profiling: Together at Last
When profiling .NET code it's important to examine all possible causes of slowdowns, but tracking down SQL bottlenecks can be a formidable task - if you're lucky enough to know they exist. Even if unexpected queries are observed using a separate SQL profiler, understanding why your application generated those requests is sometimes impossible.
ANTS Performance Profiler gives you the complete picture. By analyzing SQL Server activity and .NET code performance data from within the same tool, you can get right to the bottom of your performance issues.
- 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 makes it easy to switch between analyzing SQL activity and .NET performance metrics.
- View the stack trace and understand the entire .NET environment at the precise time of an unwanted database call.
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 intoJeff Atwood, Stack Overflow
our code. We like to do this every few months on common pages as a sanity check.