Vous avez déjà un compte client ORSYS
Se connecter
Vous êtes nouveau chez ORSYS
Créer un compte
Vous ne souhaitez pas créer de compte
Poursuivre sans me connecter

Course : SQL Server Tuning

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

SQL Server Tuning


Average of customer reviews Average of customer reviews Average of customer reviews Average of customer reviews
4,6 / 5

Required course



INTER
IN-HOUSE
CUSTOM

Practical course in person or remote class
Disponible en anglais, à la demande

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

Download in PDF format

Share this course by email







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,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.
MATTHIEU P.
08/09/26
5 / 5

Very interesting
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.

> Show more comments


Publication date : 05/15/2024


PARTICIPANTS


PREREQUISITES


TRAINER QUALIFICATIONS
The experts leading the training are specialists in the covered subjects. They have been approved by our instructional teams for both their professional knowledge and their teaching ability, for each course they teach. They have at least five to ten years of experience in their field and hold (or have held) decision-making positions in companies.

ASSESSMENT TERMS
The trainer evaluates each participant’s academic progress throughout the training using multiple choice, scenarios, hands-on work and more.
Participants also complete a placement test before and after the course to measure the skills they’ve developed.

TEACHING AIDS AND TECHNICAL RESOURCES
• The main teaching aids and instructional methods used in the training are audiovisual aids, documentation and course material, hands-on application exercises and corrected exercises for practical training courses, case studies and coverage of real cases for training seminars.
• At the end of each course or seminar, ORSYS provides participants with a course evaluation questionnaire that is analysed by our instructional teams.
• A check-in sheet for each half-day of attendance is provided at the end of the training, along with a course completion certificate if the trainee attended the entire session.

TERMS AND DEADLINES
Registration must be completed 24 hours before the start of the training.

ACCESSIBILITY FOR PEOPLE WITH DISABILITIES
Do you need special accessibility accommodations? Contact Mrs. Fosse, Disability Manager, at psh-accueil@orsys.fr to review your request and its feasibility.

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.


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.