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

SQL Server Tuning


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


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


INTER
IN-HOUSE
CUSTOM

Practical course in person or remote class

Ref. SQS
  4d - 28h00
Price : Contact us

Download in PDF format

Share this course by email




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

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.


Dates and locations
Select your location or opt for the remote class then choose your date.
Remote class