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

How to set a variable from a table with comma? (17h)

SSRS Expression IIF Zero then ... Got #Error (1d)

Understanding 2 Left Joins in same query (2d)

Use a C# SQLReader to input an SQL hierarchyid (2d)

Translate into easier query/more understandable (2d)

Aggregation view with Min and Max (3d)

Data file is Compressed - Cannot Re-Attach, Cannot Restore (3d)

Sql trigger assign value to parameter (6d)

- Advertisement -