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 ...