Chapter 23. SQL Server Profiler
After completing this chapter, you will be able to
Understand how and when to use SQL Server Profiler.
Create a trace.
Understand the advantages of running a server-side trace.
At the core of most enterprise applications is a relational database. Unfortunately, when the database is experiencing performance issues, so will any system that depends on it. Identifying the cause of a slowdown and correcting the associated issues can be problematic. When it comes to relational databases, there can be any number of problems, including but not limited to high CPU usage, memory limitations, high disk activity, or slow queries.
For a new database administrator (DBA), identifying these problems can be like looking for a needle ...
Get Microsoft® SQL Server® 2012 Step by Step 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.
