|
|
-
In this chapter, we learn about the anatomy of a SQL Trace and how the SQL Server Profiler integrates into the SSMS, Query editor and the Activity Monitor....
|
-
In this chapter, we will study how to correlate the profiler trace with Windows Profiler Log Data. This is important when you suspect that SQL Server is either being held up by or is the cause of an I/O, memory or processor contention....
|
-
In the final part of the series, we learn how to use SQLDiag, some of it’s most useful input parameters and consume the multi-functional trace template we defined using the SQLDiag Configuration utility to generate SQL profiler trace and correlated Windows Performance logs....
|
-
In this chapter, we learn how the SQL Server Profiler and the SQL trace can help us in identifying deprecated features from our database code....
|
-
In this chapter, we learn how to use the SQL Profiler to create the T-SQL definition of any given trace template, customize it and execute it as a server-side trace using T-SQL. ...
|
-
Raising the stakes a bit, we learn about the SQLDiag and the SQLDiag Configuration utility – an advanced utility that allows you greater control over your SQL trace by allowing you to define and customize a SQL trace, a Perfmon trace and the capture of data from Windows Event logs!...
|
-
In this chapter, we learn about the anatomy of a trace template, which gives body to the trace by defining the events and data columns captured in the trace. We also learn about customizing, importing and exporting traces....
|
-
In this chapter, we learn how to execute a trace and how to define trace execution options to our benefit by defining the maximum amount of data to capture and using time-bound tracing. ...
|
-
Now that a trace has been captured from your production server, we learn how to “replay” this trace on your development environment to repeatedly recreate and study the exact conditions that you are attempting to debug. You can also use the SQL Server blocked process monitor to study a trace that contains indications of heaving locking/blocking....
|
-
The graphical UI of the profiler and the fact that it’s a client-side trace adds to additional load on an already ailing server. In this chapter, we look at the basics of building our first SQL trace template using nothing but pure T-SQL....
|