SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags SQL Server 2008, Performance Monitoring Rss

   Items 1 to 4 of 4   

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 | 4,290 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 | 6,190 reads

Resource Governer

By Site Owners 2008/07/31 | Category: performance monitoring
Rating: (not yet rated) |  Discuss |   Briefcase | 3,041 reads

Investigating SQL Server 2008 Wait Events with XEVENTS

Some reasons for the slow-running of database applications aren't obvious. Occasionally, even the profiler won't tell you enough to remedy a problem, especially when a SQL Statement is being forced to wait. Now, in SQL Server 2008, come XEvents, which allow you to look at those waits that are slowing your SQL Statements. Mario Broodbakker continues his series about SQL Server Wait Events  Read more...
By Additional Articles 2008/07/30 | Source: SimpleTalk | Category: performance monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 2,228 reads
   Items 1 to 4 of 4   
performance advisor (1)    
product reviews (1)    
resource governor (1)    
sponsored article (1)    
sql sentry (1)    
xevents (1)