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

Content with tag XEvents Rss

   Items 1 to 3 of 3   
 

Querying deadlock graph from SQL Extended Events

Sample script to read deadlock graph XML from default system health XEvent.  Read more...
By Marcelo Fonseca 2014/10/21 | Source: SQLServerCentral.com | Category: xevents
Rating: |  Discuss |   Briefcase | 1,450 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/08/20 | Source: SQLServerCentral.com | Category: sql server 2008
Rating:  Rate this |   Briefcase | 1,703 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 | 1,848 reads
   Items 1 to 3 of 3   
 
Tags
sql server 2008 (2)    
deadlock (1)    
deadlock graph (1)    
performance monitoring (1)    
performance tuning (1)    
sql server (1)    
systemhealth (1)