Model and data
- Importance of data type, schema design, keys content.
- Modeling methods depending on data volume
- Using constraints and triggers
- Data quality and redundancy management.
Exercise
Comparison between two models with identical data
Hardware optimization
- Processors and parallelism management
- RAM configuration
- Windows 32 Bits vs Windows 64 Bits comparison
- Choosing Hard Disk: RAID, SAN, etc…
- Network infrastructure : best practices
Exercise
Measuring physical I/O using « Perfmon » tool
SQL Server settings
- Installation considerations : OS, SQL Server, sessions, etc... Auditing server with « Perfmon » tool
- Managing quotas on Resources
Exercise
Retrieving server information using SQL queries and « Perfmon » tool
Writing and reading data
- Storage engine and buffer cache
- Checkpoint and LazyWriter
- Organization of tables and indexes taking into account data volume
- Transactions, logs and isolation level
- Files organization
Exercise
Creating a multi files database and migrating data
4d
- 28h00 
