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.
Microsoft SQL Server 2008 R2 Administration Cookbook
By :
Microsoft SQL Server 2008 R2 Administration Cookbook
By:
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
Free Chapter
Getting Started with SQL Server 2008 R2
Administrating the Core Database Engine
Managing the Core Database Engine
Administering Core Business Intelligence Services
Managing Core SQL Server 2008 R2 Technologies
Improving Availability and enhancing Programmability
Implementing New Manageability Features and Practices
Maintenance and Monitoring
Troubleshooting
Learning the Tricks of the Trade
More DBA Manageability Best Practices
Customer Reviews