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