Packt+ | Advance your knowledge in tech

You're reading from Microsoft SQL Server 2012 Performance Tuning Cookbook With this book you'll learn all you need to know about performance monitoring, tuning, and management for SQL Server 2012. Includes a host of recipes and screenshots to help you say goodbye to slow running applications.

Product type Paperback

Published in Jul 2012

Publisher Packt

ISBN-13 9781849685740

Length 478 pages

Edition 1st Edition

Languages

Tools

SQL Server

Concepts

Servers

Table of Contents (28) Chapters

Microsoft SQL Server 2012 Performance Tuning Cookbook

Credits

About the Authors

Acknowledgement

About the Reviewers

www.PacktPub.com

1. Preface

1. Mastering SQL Trace Using Profiler FREE CHAPTER

2. Tuning with Database Engine Tuning Advisor

3. System Statistical Functions, Stored Procedures, and the DBCC SQLPERF Command

4. Resource Monitor and Performance Monitor

5. Monitoring with Execution Plans

6. Tuning with Execution Plans

7. Dynamic Management Views and Dynamic Management Functions

8. SQL Server Cache and Stored Procedure Recompilations

9. Implementing Indexes

10. Maintaining Indexes

11. Points to Consider While Writing Queries

12. Statistics in SQL Server

13. Table and Index Partitioning

14. Implementing Physical Database Structure

15. Advanced Query Tuning Hints and Plan Guides

16. Dealing with Locking, Blocking, and Deadlocking

17. Configuring SQL Server for Optimization

18. Policy-based Management

19. Resource Management with Resource Governor

Index

Monitoring CPU usage

The CPU is the most important resource on a server. On a database server, CPU usage should be monitored from time to time to make sure that the performance of the database server is optimized.

In this recipe, we will use Reliability and Performance Monitor to capture CPU-related usage statistics.

You may have used Performance Monitor (where you could add different performance counters that need to be traced) in the past. Reliability and Performance Monitor is an enhanced version of the old Performance Monitor tool. In Reliability and Performance Monitor also, we can use performance objects and counters to analyse system performance by different parameters.

Performance Counters provide statistical data for various system activities. You will find hundreds of performance counters that belong to the Windows OS or third-party applications. SQL Server has hundreds of performance counters of its own that provide useful performance-statistics information to the DBA.

In this...

The rest of the chapter is locked

You're reading from Microsoft SQL Server 2012 Performance Tuning Cookbook With this book you'll learn all you need to know about performance monitoring, tuning, and management for SQL Server 2012. Includes a host of recipes and screenshots to help you say goodbye to slow running applications.

Table of Contents (28) Chapters

Monitoring CPU usage

Unlock this book and the full library FREE for 7 days

Personalised recommendations for you