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
Disponible en anglais, à la demande

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,4 / 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

A number of interesting topics are covered; it might be worth taking more time to explore some of them in greater depth
ROMAIN M.
30/06/26
5 / 5

An interesting course that introduces you to a wide range of tools.
GUILLAUME D.
26/05/26
5 / 5

A fascinating topic covered in depth20in-depth%20by%20a%20highly%20experienced%20and%20friendly%20person.%20I%20had%20a%20great%20time%20and%20it%20has%20opened%20up%20new%20perspectives%20for%20my%20work.



Publication date : 05/15/2024



This programme is an original creation, developed by the teaching teams at ORSYS Formation. Any reproduction, representation, adaptation or use, in whole or in part, without the prior written authorisation of ORSYS, is strictly prohibited. ORSYS reserves the right to take any action necessary to protect its intellectual property rights.

Dates and locations

Dernières places
Date garantie en présentiel ou à distance
Session garantie
From 8 to 11 September 2026
FR
Remote class
Registration
From 3 to 6 November 2026
FR
Remote class
Registration
From 3 to 6 November 2026
EN
Remote class
Registration
From 9 to 12 February 2027
FR
Remote class
Registration
From 9 to 12 February 2027
EN
Remote class
Registration
From 25 to 28 May 2027
FR
Remote class
Registration
From 25 to 28 May 2027
EN
Remote class
Registration
From 29 June to 2 July 2027
FR
Remote class
Registration
From 7 to 10 September 2027
FR
Remote class
Registration
From 7 to 10 September 2027
EN
Remote class
Registration
From 26 to 29 October 2027
FR
Remote class
Registration
From 30 November to 3 December 2027
FR
Remote class
Registration
From 30 November to 3 December 2027
EN
Remote class
Registration

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

2027 : 9 Feb., 9 Feb., 25 May, 25 May, 29 June, 7 Sep., 7 Sep., 26 Oct., 30 Nov., 30 Nov.



This programme is an original creation, developed by the teaching teams at ORSYS Formation. Any reproduction, representation, adaptation or use, in whole or in part, without the prior written authorisation of ORSYS, is strictly prohibited. ORSYS reserves the right to take any action necessary to protect its intellectual property rights.