O'Reilly logo

MCITP SQL Server 2005 Database Administration All-in-One exam Guide by Darril Gibson

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 13 Database Administrator Tools

In this chapter, you will learn about:

• SQL Server Agent

• Maintenance Plan wizard

• SQL Server Profiler

• Dynamic management views and functions

If the only tool you have is a hammer, you tend to see every problem as a nail.

—Abraham Maslow

One of the keys to becoming a successful database administrator is knowing what tools you have available to get different jobs done. SQL Server Agent has been around for many versions of SQL Server, and it allows us to automate many tasks. Likewise, SQL Server Profiler has been around for a long time. SQL Server Profiler allows us to capture Trace events so that we can identify what is happening on the system. Profiler is often used to identify poorly running queries. ...

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