Identifying performance issues using SQL Server Profiler

By Rob Volk on 26 November 2002 | Tags: Performance Tuning , Profiler & Trace


Narayana Vyas Kondreddi submitted "It is always better to be proactive than reactive, when it comes to identifying and eliminating SQL Server performance issues. In this article, I am going to explain the method I follow, to identify performance issues in my database applications, before those applications go into production environment."

Link: Identifying performance issues using SQL Server Profiler


Related Articles

Testing with Profiler Custom Events and Database Snapshots (22 June 2009)

Introduction to SQL Server 2008 Extended Events (19 May 2009)

Integrating Profiler and PerfMon Log Files (6 February 2008)

Which is Faster: SAN or Directly-Attached Storage? (21 January 2008)

Benchmarking Disk I/O Performance: Size Matters! (30 October 2007)

What I Wish Developers Knew About SQL Server (Presentation) (11 October 2007)

Introduction to Parameterization in SQL Server (7 August 2007)

Using Indexed Computed Columns to Improve Performance (16 January 2007)

Other Recent Forum Posts

Extracting data between two consistents in a string (6h)

Which Scheduled Task is Backing Up My Database? (11h)

Finding the latest unreversed receipt (14h)

Sql sorting by date doesn't work (18h)

Unable to Import the trace file (3d)

Error on ALTER VIEW but same ALTER runs OK from SSMS (4d)

Creating groups based on criteria and time based? (7d)

Tsql - logic to to get the Expected result (7d)

- Advertisement -