Configuring SQL Server to use more processing power

In today's age, databases keep getting bigger and bigger, so in order to get information quickly from a database, it is not enough to manage your database wisely; you will also need a CPU with faster processing power.

No matter how efficiently you maintain indexes and statistics, you will not receive a prompt response from your SQL Server if you are running with low processing power. Choosing a proper CPU for your database need, is a part of "capacity planning", which is out of the scope of this chapter, as it itself requires few chapters to describe it in-depth. However, here we will learn how to utilize your current processing power efficiently.

Have you ever wondered how many CPUs are used ...

Get Microsoft SQL Server 2012 Performance Tuning Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.