O'Reilly logo

Microsoft SQL Server 2008 R2 Administration Cookbook by Satya Shyam K Jayanty

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Managing events capture to troubleshoot problems

Performance slowdown is a common occurrence in any RDBMS platform and SQL Server is not an exception. The root cause can range from inadequate database design that is, improper configuration, to handling the application workload. The DBA must be able to identify the root cause in a pro-active manner to minimize the problem. Also, the essential task is to monitor when a simple query execution causes intermittent issues and take corrective measures to fix the problem. The Windows operating system and SQL Server have a flurry of tools and utilities to monitor the system activity and collect the required data, such as PERFMON (SYSMON), SQL Server Profiler, DBCC statements, Dynamic Management Views (DMVs), ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required