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

Configuring the tempdb database on separate physical disk

The tempdb database is one of the system databases of SQL Server that is essential for its normal functioning. SQL Server relies on the tempdb database to perform many of its operations and stores internal objects in this database. The following are some of the operations for which the tempdb database is used by SQL Server:

Performing grouping or sorting operations in queries
Cursor operations
Version store operation
Online index creation
Storing intermediate results in worktables
Storing user objects, such as local or global temporary tables and table variable data

The tempdb database is the central database for all the databases and applications per the SQL Server instance. Therefore, if many database applications are using tempdb extensively, the performance of the tempdb database is very crucial for the overall performance of the SQL Server instance. If tempdb resides on the same disk, which is also used by the other application databases...

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

Configuring the tempdb database on separate physical disk

Unlock this book and the full library FREE for 7 days

Personalised recommendations for you