Chapter 1. Mastering SQL Trace Using Profiler
In this chapter we will cover:
- Creating a trace or workload
- Filtering events
- Detecting slow running and expensive queries
- 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 ...
Get Microsoft SQL Server 2012 Performance Tuning Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
