SQL Academy: SQL Server Advanced Configuration
SQL Academy is a series of FREE Level 300 technical training seminars being hosted by Microsoft.
-
Where:
Microsoft Auditorium (EPDC2), South County Business Park, Leopardstown, Dublin 18
-
When:
October 21st 2009 from 13:30 – 17:00
-
Suitable for:
IT Pros, DBA and Database Architects who are responsible for configuring SQL Server infrastructure
Module 1: SQL Server Advanced Configuration will focus on everything you need to know to configure SQL Server in a production environment. We will cover SQL 2008, but also indicate where 2005 differs.
The Session will cover the following topics:
- Configuration I (memory and CPU)
- SQL Server’s Memory Architecture
- How much memory do I need
- 32bit memory configuration
- Memory settings
- Monitoring memory usage
- CPU Architecture
- CPU settings
- Configuration II (Database Settings)
- Common database settings
- Recommended practices
- Controlling database configuration
- Configuration III (Storage)
- SQL I/O Architecture and Requirements
- SAN/Disk Configuration
- Windows Configuration
- Data and Log File Configuration
- TempDB configuration
- key metrics for monitoring storage
- testing storage with sqlio.exe