-
Book Overview & Buying
-
Table Of Contents
Microsoft SQL Server 2008 R2 Administration Cookbook
By :
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.
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...
Change the font size
Change margin width
Change background colour