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

Vehicle availability query (13m)

SSDT - Unable to reference 'master' or 'msdb' with new sdk style project (25m)

Ola Hallengren backup jobs (2h)

Compare alpha results to INT after get values from a string (3d)

Query performance Call Center data (5d)

Looking for on Premises tool to read data from SQL logs and populate data warehouse (5d)

Possible SQL 2014 to 2016 Issue - Some Application Functions Slow/Failing (5d)

Working with multiple WHERE statements (6d)

- Advertisement -