Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags SQL Server 7, T-SQL, Performance Tuning, SQL Server 6.5 Rss

   Items 1 to 3 of 3   
 

Measuring SQL Performance

One thing that often amazes me is that many SQL Server developers do not actually measure the performance of their queries. Many of them thought that you needed external tools, more or less complicated, to run against your server, and they did not have the time or inclination to learn and try these. This article will describe a couple of much easier methods of measuring performance of queries.   Read more...
By Christoffer Hedgate 2005/12/23 (first published: 2004/04/02) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 33,370 reads

Measuring SQL Performance

One thing that often amazes me is that many SQL Server developers do not actually measure the performance of their queries. Many of them thought that you needed external tools, more or less complicated, to run against your server, and they did not have the time or inclination to learn and try these. This article will describe a couple of much easier methods of measuring performance of queries.   Read more...
By Christoffer Hedgate 2005/12/23 (first published: 2004/04/02) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 33,370 reads

Lock View: sp_lock2

An alternative procedure for viewing locks based on sp_lock.   Read more...
By Alexander Chigrik 2001/07/24 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 7,386 reads
   Items 1 to 3 of 3