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

Content with tags Performance Tuning, Monitoring Rss

   Items 1 to 12 of 12   
 

CPU and Scheduler Performance Monitoring using SQL Server and Excel

This article will demonstrate a method of creating an Excel-based CPU/scheduler performance dashboard for SQL Server 2005+.  Read more...
By Derek Colley 2012/10/04 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,128 reads

Email Long Running SPID Info

This script will email info about the longest running SPID in an HTML formatted table  Read more...
By Deon Benjamin 2011/07/07 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 1,894 reads

Capturing I/O patterns using Process Monitor

In this article, Edward Elliot shows us how to capture the types, size and location of SQL Server I/O requests.  Read more...
By Edward Elliott 2009/06/23 | Source: SQLServerCentral.com | Category: i/o
Rating: |  Discuss |   Briefcase | 7,185 reads

Complete Blocking Report

A complete blocking report which gives the complete information about what queries are runninng and it will be worth capturing the details before we decide to kill the processes.  Read more...
By Vee 2009/01/08 | Source: SQLServerCentral.com | Category: blocking
Rating: |  Discuss |   Briefcase | 2,052 reads

Stored Procedures and Caching

One of the biggest performance gains built into SQL Server is the stored procedure. In this article by Brian Kelley, he shows you how to fully utilize, debug and monitor the caching of such objects.   Read more...
By Brian Kelley 2004/11/19 (first published: 2002/01/28) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 40,708 reads

Analyzing Data Storage - Ten SHOWCONTIG Queries

Analyzing the data storage in SQL Server databases is a bit of an art. It's a skill that takes some time to develop given that the tools are rather limited. DBCC SHOWCONTIG is one of the few ways in which you can get some insight into how SQL Server has structured your table on the disk. Joe Sack brings us another of his top xxx techniques with his ten queries that you can use to analyze the results of this command.   Read more...
By Joseph Sack 2004/08/16 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 22,446 reads

Auto Close and Auto Shrink - Just Don't

New author! Mike Pearson discusses how auto close was at the root of a performance problem he was troubleshooting, how you can check your servers easily, and discusses why both auto close and auto shrink are bad ideas in a production environment.   Read more...
By Mike Pearson 2003/05/05 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 19,921 reads

Review of SQL 2000 Fast Answers

A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks!   Read more...
By Andy Warren 2003/04/18 | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 18,205 reads

Review of SQL Server 2000 Performance Tuning

This book from Microsoft Press has a lot of good information that will help you do capacity planning and performance tuning. Is it worth buying though? Andy just finishing reading it and writing the review, see what he thinks!   Read more...
By Andy Warren 2002/05/03 | Source: SQLServerCentral.com | Category: performance tuning
Rating: (not yet rated) |  Discuss |   Briefcase | 8,235 reads

Stored Procedures and Caching

One of the biggest performance gains built into SQL Server is the stored procedure. In this article by Brian Kelley, he shows you how to fully utilize, debug and monitor the caching of such objects.   Read more...
By Brian Kelley 2004/11/19 (first published: 2002/01/28) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 40,708 reads

Support WebCast: Microsoft SQL Server: Rapid Blocker Script Analysis

This webcast is scheduled for Tuesday, January 15, 2002 at 10:00 AM Pacific time.During this session, we will show a practical approach to analyze performance tuning problems that involve Microsoft SQL Server lock monitoring data. We will briefly discuss sp_who2, sysprocesses, and syslocks.   Read more...
By Additional Articles 2001/12/28 | Source: Microsoft MSDN | Category: performance tuning
Rating:  Rate this |   Briefcase | 942 reads

Job to Monitor SQL Server 7.0 Performance and Activity

This article describes the ActivityTrace7 job that puts blocking and performance data into a trace file for further analysis.   Read more...
By Additional Articles 2001/06/19 | Source: Microsoft MSDN | Category: performance tuning
Rating:  Rate this |   Briefcase | 2,290 reads
   Items 1 to 12 of 12   
 
Tags
sql server 7 (7)    
t-sql (5)    
administration (3)    
miscellaneous (3)    
backup / restore (2)    
configuring (2)    
indexing (2)    
stored procedures (2)    
affinity (1)    
blocking (1)    
cpu (1)    
distributed queries (1)    
dts (1)    
english query (1)    
excel (1)    
graphs (1)    
i/o (1)    
installation (1)    
internals (1)    
openxml (1)    
replication (1)    
reporting services (ssrs) (1)    
schedulers (1)    
security (1)    
sys.dm_os_ring_buffers (1)    
sys.dm_os_schedulers (1)    
sys.dm_os_sysinfo (1)    
triggers (1)    
troubleshooting (1)    
updategrams (1)    
user defined function (udf) (1)    
what queries are running (1)    
xml (1)    
xsl (1)