![]() ![]() SQL Server 2005+ includes a new SQL Server Profiler event, the Blocked Process report. Key details provided for blocking and blocked sessions include: Blocking process details: To access this information, check Enable the Activity Monitor and Capture Blocking (SQL 2005+) in the Activity Monitor window. Blocking monitoring is supported on monitored instances running SQL Server 2005 or greater and is dependent on Activity Monitor. Capturing blocking eventsĬapturing blocking information allows the associated blocked alert to provide details on blocking and blocked sessions on the Alerts view. To access this information, check Enable the Activity Monitor and Capture Autogrow in the Activity Monitor window. Details provided include:Ĭapturing autogrow information allows the associated autogrow alert to provide information about log and data growth on the Alerts view. ![]() To access this information, check Enable the Activity Monitor and Capture deadlocks (SQL 2005+) in the Activity Monitor window. Deadlock monitoring is supported on monitored instances running SQL Server 2005 or greater and is dependent on the Activity Monitor. ![]() Capturing deadlocksĬapturing deadlock information allows the associated deadlock alert to provide details on deadlocked processes on the Alerts view. Note that enabling this option can degrade performance on your SQL Server. To capture non-query activites for monitored pre-SQL Server 2008 instances, enable the SQL Trace collection option. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |