O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required