Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By : Satya Shyam K Jayanty
Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By: Satya Shyam K Jayanty

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2008 R2 Administration Cookbook
Credits
Foreword
About the Author
Acknowledgment
About the Reviewers
www.PacktPub.com
Preface
More DBA Manageability Best Practices

Implementing parallel query processing methods


In recent times, the processing power of a hardware system has been increased. This helps speed up the processing of large data and data warehouse queries, which can be termed as parallelism. By default, SQL Server utilizes the power of a multi-core hardware platform for a large amount of data management chores. Specifically, in query processing, the CPU is used extensively to perform multiple threads simultaneously. CPU can be a logical process or hyper-threaded cores. In this recipe, we will work on required tasks in implementing parallel query processing methods that can enable database or application tuning to help improve the performance.

Getting ready

In order to set up and get the advantage of parallel query processing methods, the hardware plays an essential part. The minimum system requirements for parallel query processing is as follows:

  • Processor type with a recommended 2.0Ghz or faster:

    • Intel Xeon with Intel EMT64T support

    • Intel Pentium...