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, Activity Monitor, 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. However, it will be limited in its use in future SQL Server releases. As you can see in Figure ...
Get Microsoft® SQL Server 2012 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.
