Chapter 30. Using Profiler, Management Studio, and Database Engine Tuning Advisor

In this chapter, we will examine the main tools you use on a daily basis as a SQL Server 2005 database administrator. SQL Server Management Studio and SQL Server Profiler are the most common tools that a DBA uses, so we will concentrate on these tools in this chapter. We will look at how you perform common DBA tasks using SQL Server Management Studio and how to interpret the rich information embedded inside this powerful tool. We will also examine how you can capture a trace of activity against your SQL Server 2005 instance and use that information ...

Get Microsoft® SQL Server™ 2005 Administrator's Companion 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.