Microsoft® SQL Server® 2012 Bible

927 Chapter 38: Using Profi ler and SQL Trace 38 Using SQL Trace SQL Server Profiler is usually used interactively, and for ad h ...

928 Part VII: Monitoring and Auditing To programmatically view the events and data columns collected by a trace, use the follow- ...

929 Chapter 38: Using Profi ler and SQL Trace 38 Another preconfigured trace is the blackbox trace, which is used to diagnose se ...

c38.indd 930c38.indd 930 7/31/2012 10:04:20 AM7/31/2012 10:04:20 AM http://www.it-ebooks.info ...

931 CHAPTER 39 Wait States IN THIS CHAPTER Exploring the SQL Server OS Examining Wait Statistics Identifying Common Red-Flag Wai ...

932 Part VII: Monitoring and Auditing As tasks run inside the database engine, they typically follow a circular pattern that jum ...

933 Chapter 39: Wait States 39 ignored, even if they are high on the waiting list. Later in this chapter you review some common ...

934 Part VII: Monitoring and Auditing If can be useful to clear the values returned from this DMV for testing purposes. To do th ...

935 Chapter 39: Wait States 39 Common Red-Flag Wait Types The following table lists common wait types that warrant investigation ...

936 Part VII: Monitoring and Auditing Other Ways to Gather Wait data You can gather Wait data in other ways, including Extended ...

937 CHAPTER 40 Extended Events IN THIS CHAPTER Understanding the Extended Event Object Model Using the system_health Session Dis ...

938 Part VII: Monitoring and Auditing FIGURE 40-1 This fi gure lists all objects in the Extended Events object model. Extended E ...

939 Chapter 40: Extended Events 40 Events An Event is an interesting point in the SQL Server executable code. Events in Extended ...

940 Part VII: Monitoring and Auditing FROM sys.dm_xe_objects o JOIN sys.dm_xe_packages p ON o.package_guid = p.guid WHERE object ...

941 Chapter 40: Extended Events 40 Events and the associated Targets that consume the Event data. One signifi cant feature of an ...

942 Part VII: Monitoring and Auditing The Extended Events Profi ler The biggest change to Extended Events in SQL Server 2012 is ...

943 Chapter 40: Extended Events 40 Viewing the properties for a given session details the events for the session along with any ...

944 Part VII: Monitoring and Auditing Summary Extended Events is an extremely useful tool in troubleshooting SQL Server problems ...

945 CHAPTER 41 Data Change Tracking and Capture IN THIS CHAPTER Leveraging the T-Log Synchronizing Data Using Standard Edition B ...

946 Part VII: Monitoring and Auditing There is a small performance hit for using Change Tracking, but it’s a lightweight feature ...