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

Content with tag Performance Monitoring Rss

   Items 1 to 20 of 29    Older >>
 

Collect SQL Server/Process Information - Quickly

Execute this script to get information on SQL server, databases, processes, memory, buffer, locks, etc.  Read more...
By Rudy Panigas 2011/04/21 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 5,223 reads

Average Page Life Expectancy

A useful script that I wrote that will sample the DMV sys.dm_os_performance_counters table to provide an average PLE captured in (1) minute intervals.  Read more...
By Tim Parker 2010/12/01 | Source: SQLServerCentral.com | Category: performance monitoring
Rating: |  Discuss |   Briefcase | 1,378 reads

Gathering Perfmon Data with Powershell

Inspired to streamline the process of gathering and storing data from Performance Monitor Counters, SQL Server MVP Laerte Junior guides us through the functions of his remarkably useful module.  Read more...
By Additional Articles 2010/07/21 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 2,584 reads

Performance Counter DMV sys.dm_os_performance_counters

By querying a single DMV, sys.dm_os_performance_counters to be precise, you can collect counter information that you would receive from PerfMon for the various SQL Server counters.  Read more...
By Additional Articles 2010/06/29 | Source: MSSQLTips.com | Category: performance monitoring
Rating:  Rate this |   Briefcase | 3,163 reads

Performance Analysis Using SQL Server 2008 Activity Monitor Tool

While looking through the new features and improvements in SQL Server 2008 Management Studio (SSMS) we found a potentially interesting one called Activity Monitor. Database developers and Database Administrators can use Activity Monitor to get a quick overview of an SQL Server 2008 system performance. Can you give us a detailed explanation of how we go about using Activity Monitor?  Read more...
By Additional Articles 2010/01/26 | Source: MSSQLTips.com | Category: sql server 2008
Rating:  Rate this |   Briefcase | 3,548 reads

What SQL Statements Are Currently Executing?

This article describes a utility that allows you to identify what SQL statements are currently executing.  Read more...
By Ian Stirk 2009/12/11 (first published: 2008/10/28) | Source: SQLServerCentral.com | Category: dmv
Rating: |  Discuss |   Briefcase | 47,777 reads

SQL Server Tempdb Usage and Bottlenecks tracked with Extended Events

How do I effectively find out if the Tempdb database is suffering from an allocation bottleneck? Should I create multiple TempDB files per core on this server to improve performance? How do I check this information programmatically?  Read more...
By Additional Articles 2009/10/13 | Source: MSSQLTips.com | Category: tempdb
Rating:  Rate this |   Briefcase | 3,732 reads

Collecting Query Statistics for SQL Server 2005

With SQL Server 2005 DMVs, we can easily find query performance statistics. Every DBA has a favorite script to find query performance stats. I also have one. But, are all the queries captured by the DMVs? In this tip I will walk through capturing some of this data and show what is capture and what is not captured by the DMVs.  Read more...
By Additional Articles 2009/10/05 | Source: MSSQLTips.com | Category: statistics
Rating:  Rate this |   Briefcase | 4,321 reads

Collect SQL Server/Process Information - Quickly

Execute this script to get information on SQL server, databases, processes, memory, buffer, locks, etc.  Read more...
By Rudy Panigas 2011/04/21 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 5,223 reads

Don't Build a Monitoring System

Should you buy or build a monitoring system for your SQL Server? Todays' guest editorial from Grant Fritchey talks about the resistance to recommendations that many people seem to have.  Read more...
By Grant Fritchey 2009/09/14 | Source: SQLServerCentral.com | Category: editorial - ipod
Rating: (not yet rated)  Rate this |   Briefcase | 253 reads

Don't Build a Monitoring System

Should you buy or build a monitoring system for your SQL Server? Todays' guest editorial from Grant Fritchey talks about the resistance to recommendations that many people seem to have.  Read more...
By Grant Fritchey 2009/09/14 | Source: SQLServerCentral.com | Category: editorial - mp3
Rating: (not yet rated)  Rate this |   Briefcase | 502 reads

Don't Build a Monitoring System

Should you buy or build a monitoring system for your SQL Server? Todays' guest editorial from Grant Fritchey talks about the resistance to recommendations that many people seem to have.  Read more...
By Grant Fritchey 2009/09/14 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 778 reads

Don't Build a Monitoring System

Should you buy or build a monitoring system for your SQL Server? Todays' guest editorial from Grant Fritchey talks about the resistance to recommendations that many people seem to have.  Read more...
By Grant Fritchey 2009/09/14 | Source: SQLServerCentral.com | Category: editorial - wmv
Rating: (not yet rated)  Rate this |   Briefcase | 254 reads

The DBA as Detective: Troubleshooting Locking and Blocking

Rodney Landrum describes in his own unique style how he, as a working DBA, goes about troubleshooting problem queries, and investigating various types of locking and blocking problems. In the process, he passes on valuable tips learned from practical, and sometimes stressful, experience.  Read more...
By Additional Articles 2009/09/02 | Source: SimpleTalk | Category: dba
Rating:  Rate this |   Briefcase | 5,844 reads

Retaining historical index usage statistics for SQL Server - Part 3

In this, the third of the four part series on persisting the rowset results from the indexing Dynamic Management Views cached in temporary internal SQL Server structures we will explore what is required to store the missing index-related metadata.  Read more...
By Additional Articles 2009/07/20 | Source: MSSQLTips.com | Category: indexing
Rating:  Rate this |   Briefcase | 1,671 reads

Automating Performance Monitor Statistics Collection for SQL Server and Windows

You have about 100 SQL Servers installed in your production environment. You have performance problems on few of the servers, but they happen during the time when you are not watching the servers. So, how can you automate performance statistics collection on all the servers around the clock so we have the statistics for 24/7/365.  Read more...
By Additional Articles 2009/07/08 | Source: MSSQLTips.com | Category: performance monitoring
Rating:  Rate this |   Briefcase | 3,575 reads

Collecting performance counters and using SQL Server to analyze the data

Quite frequently I find myself in situation where I need to get detailed information on performance monitor counters. For example I need to determine which processes are consuming all CPU at certain times.  Read more...
By Additional Articles 2009/04/09 | Source: MSSQLTips.com | Category: performance monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 3,075 reads

Monitoring Your Servers : Data Collection vs. Performance Advisor

An article sponsored by SQL Sentry that compares how the Data Collector in SQL Server 2008 and SQL Sentry's Performance Advisor can be used with your SQL Server. Written by MVP Aaron Bertrand.  Read more...
By Aaron Bertrand 2009/03/19 | Source: SQLServerCentral.com | Category: product reviews
Rating: |  Discuss |   Briefcase | 5,837 reads

Finding Execution Time of a SQL Statement

Capturing the execution time for rebuilding an index for set of tables.  Read more...
By Prashanth Jayaram 2008/12/26 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,562 reads

What SQL Statements Are Currently Executing?

This article describes a utility that allows you to identify what SQL statements are currently executing.  Read more...
By Ian Stirk 2009/12/11 (first published: 2008/10/28) | Source: SQLServerCentral.com | Category: dmv
Rating: |  Discuss |   Briefcase | 47,777 reads
   Items 1 to 20 of 29    Older >>
 
Tags
sql server 2008 (4)    
administration (2)    
indexing (2)    
locking (2)    
monitoring (2)    
reporting services (ssrs) (2)    
auditing (1)    
dba (1)    
dmv (1)    
editorial (1)    
editorial - ipod (1)    
editorial - mp3 (1)    
editorial - wmv (1)    
performance advisor (1)    
powershell (1)    
processes (1)    
product reviews (1)    
resource governor (1)    
screencast (1)    
sponsored article (1)    
sql sentry (1)    
sql server 2005 (1)    
statistics (1)    
stored procedures (1)    
tempdb (1)    
xevents (1)