Microsoft SQL Server 2008 R2 Unleashed- P22:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 164 CHAPTER 6 SQL Server Profiler any other data columns that make sense for your specific trace. After this task is complete you can launch the sample stored procedure from Listing and get progress information via SQL Profiler as the procedure executes. You can accumulate execution statistics over time with this kind of trace and summarize the results. The execution command for the procedure follows EXEC SampleApplicationProc @debug 1 The resulting SQL Profiler results are shown in Figure . FIGURE User configurable trace results. There are many other applications for User configurable events. How you use them depends on your specific need. As is the case with many Profiler scenarios there are seemingly endless possibilities. Summary Whether you are a developer or database administrator you should not ignore the power of the SQL Profiler. It is often one of the most underused applications in the SQL Server toolkit yet it is one of the most versatile. Its auditing capabilities and ability to unravel complex server processes define its value. This chapter wraps up the introduction to the tools and utilities available with SQL Server. Now you should be equipped to start administering and working with SQL Server. The chapters in the next section focus on the overall administration of SQL using some of the tools that you have been exposed to thus far. Chapter 7 SQL Server System and Database Administration gives you some insight into the inner workings of SQL Server and what it takes to effectively administer a SQL Server instance. Download from CHAPTER 7 SQL Server System and Database Administration T his chapter outlines the role of a SQL Server system administrator and explores some of the methods that an administrator can use to query important system data. As with any other job understanding the roles and responsibilities of the job is critical to doing the job well. The responsibilities of an administrator vary depending on the job .
