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. ...
Get MCITP SQL Server 2005 Database Administration All-in-One Exam Guide (Exams 70-431, 70-443, & 70-444) 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.
