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 by a SQL Server while processing a query? Users used to buy increasingly powerful computers, with many processors and cores, but it is interesting to know how many of them are used while executing a query in SQL server.

Getting ready

Before we move forward...