O'Reilly logo

Microsoft SQL Server 2012 Performance Tuning Cookbook by Bihag Thaker, Ritesh Shah

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required