This course provides an introduction to rational and efficient optimization of SQL Server databases for complex or high volume applications. It covers SQL Server 2000 to 2008 versions
Training at your location, our location or remotely
Ref. SQS
4d - 28h
Would you like to transpose this course—without changes—for your company?
A la carte training
Do you want a training course tailored to the needs of your company and its teams? Your training will be built to measure by our experts!
This course provides an introduction to rational and efficient optimization of SQL Server databases for complex or high volume applications. It covers SQL Server 2000 to 2008 versions
Intended audience
SQL Server DBAs, project managers having to drive developments with high volumes (data, access ...) and developers facing response time problems
Prerequisites
Good knowledge of RDBMS data modeling concepts, SQL Server, Transact SQL and SQL languages. Basic knowledge of Windows operating systems
Course schedule
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
Customer reviews
4,6 / 5
Customer reviews are based on end-of-course evaluations. The score is calculated from all evaluations within the past year. Only reviews with a textual comment are displayed.
Dates and locations
Select your location or opt for the remote class then choose your date.
Remote class
No session at the moment, we invite you to consult the schedule of distance classes.