Microsoft Out-of-the-Box
Microsoft continues to offer some built-in capabilities around performance and tuning with tools such as SQL Server Profiler, Data Collection Services, Performance Monitor counters that monitor many of the execution aspects of SQL Server, and plenty of SQL options at the server level to ensure optimal execution. We mention a few here, but other chapters in this book describe these offerings in greater detail:
• SQL Server Profiler—This rock-solid Microsoft-bundled offering is slowly getting better and better. As you can see in Figure 41.6, the SQL statements across a SQL Server instance are captured along with the execution statistics and other performance handles. You can save your traces and even import them into SQL ...
Get Microsoft® SQL Server 2008 R2 Unleashed 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.
