Course : SQL Server Tuning

Practical course - 4d - 28h00 - Ref. SQS
Price : 2830 CHF E.T.

SQL Server Tuning



Required course



INTER
IN-HOUSE
CUSTOM

Practical course in person or remote class
Available in English on request

Ref. SQS
  4d - 28h00
2830 CHF E.T.







Course schedule

1
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

2
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

3
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

4
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,5 / 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.
PAUL D.
30/06/26
4 / 5

De nombreux sujets intéressants sont abordés, il pourrait être intéressant de prendre plus de temps pour approfondir certains sujets
ROMAIN M.
30/06/26
5 / 5

Formation intéressante, permet de découvrir de nombreux outils.
GUILLAUME D.
26/05/26
5 / 5

Sujet%20passionnant%20trait%C3%A9%20de%20fa%C3%A7on%20approfondie%20par%20une%20personne%20tr%C3%A8s%20exp%C3%A9riment%C3%A9e%20et%20sympathique.%20J%27ai%20pass%C3%A9%20un%20bon%20moment%20qui%20m%27ouvre%20des%20perspectives%20dans%20mon%20travail.



Publication date : 05/15/2024


Dates and locations

Last places available
Guaranteed date, in person or remotely
Guaranteed session
From 8 to 11 September 2026
FR
Remote class
Registration
From 8 to 11 September 2026
EN
Remote class
Registration
From 3 to 6 November 2026
FR
Remote class
Registration
From 3 to 6 November 2026
EN
Remote class
Registration

REMOTE CLASS
2026 : 8 Sep., 8 Sep., 3 Nov., 3 Nov.