Configuring SQL Server Instances. This presentation covers the following topics :
- SQL Server Instances
- Instance-Level Settings
- Memory Allocation
- Using sys.sp_configure
- Memory management
- Processor and I/O Affinity
- priority boost option
- lightweight pooling
- Configuring Fill Factor
- The model database
- Installing Additional Instances
- Instance Names
- Deploying Software Updates
- Resource Governor
- Cycle SQL Server Error Logs
For more presentations regarding this subject, use this link.
