Databases Reference
In-Depth Information
1
Mastering SQL Trace
Using Profiler
In this chapter we will cover:
F
Creating a trace or workload
F
Filtering events
F
Detecting slow running and expensive queries
F
Creating trace with SQL Trace system stored procedures
Introduction
Welcome to the world of Performance Monitoring and Tuning with SQL Server 2012!
Let's assume that you are a database administrator in your organization. What, if one day
one of your colleagues from your IT department calls you right away and complains that the
production database server has abruptly started to run very slowly and applications that are
accessing the production database are not responding the way they should? The issue needs
immediate attention and for that you are required to investigate the issue and fix it in timely
manner. What will be your approach to look at the problem and solve it? How would you be
able to analyze the situation and identify where the problem is? What actions would you take
once a particular problem is recognized in order to resolve it?
