Filter
Top Products
v Perform query analysis
v Troubleshoot problems
v Audit and review activity
v Correlate performance counters
v Configure trace problems
For more information about Using the SQL Server Profiler, refer to the Microsoft
Developer Network Web site, which can be accessed from: https://
technet.microsoft.com/en-us/library/ms181091%28v=sql.105%29.aspx.
Enable the following events in SQL Server Profiler to capture deadlock-related
information:
v Deadlock graph
v Lock: Deadlock
v Lock: Deadlock Chain
v RPC:Completed
v SP:StmtCompleted
v SQL:BatchCompleted
v SQL:BatchStarting
For more information about Analyzing Deadlocks with SQL Server Profiler, refer to
the Microsoft Developer Network Web site, which can be accessed from:
http://msdn.microsoft.com/en-us/library/ms188246(SQL.90).aspx.
For more information about Troubleshooting Deadlocks in Microsoft SQL Server,
refer to the Microsoft Developer Network Web site, which can be accessed from:
http://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/05/617960.aspx.
Microsoft SQL Dynamic Management Views
The Dynamic Management Views (DMVs) introduced in Microsoft SQL Server 2005
provide DBA information about the current state of the SQL Server machine.
These values help an administrator diagnose problems and tune the server for
optimal performance. For more information about dynamic management views
and functions, refer to the Microsoft Developer Network Web site, which can be
accessed from:
http://msdn.microsoft.com/en-us/library/ms188754(SQL.90).aspx
Microsoft SQL System Monitor
The performance monitor (Perfmon) or system monitor is a utility used to track a
range of processes and provide a real-time graphical display of the results.
It can also be used to measure SQL Server performance. You can view SQL Server
objects, performance counters, and the behavior of other objects, such as
processors, memory, cache, threads, and processes. For more information about
Monitoring Resource Usage (System Monitor), refer to the Microsoft TechNet Web
site, which can be accessed from: http://technet.microsoft.com/en-us/library/
ms191246(SQL.90).aspx.
Microsoft SQL Server Maintenance Plan
A maintenance plan is a set of measures (workflows) taken to ensure that a
database is properly maintained and routine backups are scheduled and handled.
58 Sterling B2B Integrator: Performance Management