O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required