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

Chapter 17. Configuring SQL Server for Optimization

In this chapter we will cover:

  • Configuring SQL Server to use more processing power
  • Configuring memory in 32 bit versus 64 bit
  • Configuring "Optimize for Ad hoc Workloads"
  • Optimizing SQL Server instance configuration

Introduction

SQL Server provides one system stored procedure, named SP_Configure, which helps you to manage the SQL Server instance-level configuration. A configuration comes with a default value, but based on the server, load on the server, and your own usage, you can change its default value to something else that can give you benefits from the performance point of view. Apart from the settings given in the SP_Configure stored procedure, the type of instance (32 bit/64 bit) also affects ...

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