|
|
-
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....
|
-
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 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. ...
|
-
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....
|
-
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....
|
-
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....
|
-
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....
|
|
|
|
|