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 ...
Get Microsoft SQL Server 2012 Performance Tuning Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
