6 Performance tuning
In this chapter:
- Controlling the load behavior
- Updating statistics in a production environment
- Configuring an ODBC connection
- Resizing virtual memory
- Removing preferential treatment from foreground applications
- Optimizing Windows for network applications
- Monitoring the Windows Event Logs
- Moving and enlarging the MS DTC logs
- Deploying SQL profiles