EXCEPTIONAL TRAINING COURSES FOR IT PROFESSIONALS
LONDON UK | ONSITE | ONLINE


SQL Server Performance Tuning Training Course


Capita Marks and Spencer Telefonica Cisco BBC Lloyds Sony

SQL Server Performance Tuning training course (code: SQLPERF)

Maximize performance & minimize downtime of your SQL Server database


SEE MORE COURSES IN THIS CATEGORY

TRAINING COURSE OVERVIEW

Client feedback shows that delegates on our courses will best engage when they can relate course topics to their own day-to-day practices and requirements. Where possible, we  run this course as a consultative, workshop-style event, in which discussion of relevant topics takes place in relation to the delegates' own applications and scenarios.

To facilitate this type of event, a subject matter expert leads the training, hands-on labs and discussions to ensure course topics are covered in a meaningful, relevant and timely manner. Delegates may be able to bring their own practical requirements and work to the course if the subjects and course topics are suitable.  


AUDIENCE

Developers and administrators familiar with SQL Server needing to know about troubleshooting techniques and tips to improve database performance.



DETAILHIGHLIGHTS

Database Performance – What’s ‘Good’ and why?

Relational Database Overview
The Query optimiser, compilation and caching. 
Locking and Logging and how updates happen.
How backups work, how DTS packages work.

Optimal Data Storage

Using File groups to Position Objects 
The affect of normalisation and de-normalisation.
Analysis Services – a reporting solution in waiting?

Diagnostic Tools

Task Manager & Performance Monitor – General counters to look out for, tips and techniques. 
Current Activity Window & SQL Profiler – Zooming in on problem queries
Query Analyser – Decrypting the showplan and trace output. Other set commands.
Transact SQL diagnostic commands. Various DBCC commands, some undocumented.

Index Optimisation

Index selection – How the optimiser decides.
Statistics – Auto and Manual.
Clustered versus Non-Clustered – Pros and Cons
The Fillfactor factor
Index optimiser hints
Index Covering
Index tuning wizard, when to use it.
Index Maintenance. Dangers and pitfalls.
Table defrag with clustered indexes. When and when not to do it.
Indexed Views – Advanced index builds.

Locking Optimisation

The City Analogy & Keeping the traffic flowing
Transaction isolation levels and locking hints
Deadlock resolution
Table restructuring & de-normalisation, replication and data warehousing solutions

Efficient Programming in TSQL

SARGS and the WHERE clause.
Covered indexes from the other side.
Stored procedures: Problems solved and created
Trigger problems and solutions
Cursors and Temporary tables
Tips and tricks.

Efficient Client Programming

Most of this course focuses on the server side application. However there is also a number of potential problems that may occur from the client side too. This section makes no assumption on which client you will be using, except that it will use ActiveX Data objects.

Default recordset options.
Send SQL versus Stored Procedures
Efficient use of recordsets and connections.
Timeout management and giving the user the perception of better performance

  • A theoretical overview to potential performance problems.
  • A hands-on guide to the diagnostic tools available within the core product to identify specific performance-related problems.
  • A thorough grounding in the transact-SQL commands that help you analyse the status of tables and optimiser behaviour.
  • Solid advice on tips and techniques to overcome these problems, keep them at bay and stop them happening in the first place

 

Receive the latest version of this course into your inbox


See why people choose JBI

"At jbi even the sales team are technical so you are able to ask questions before the course"

Garima Aon

Call our Tech Team :  0800 028 6400  request info



PUBLIC COURSES (LONDON, UK)
 

9th Nov 2017 - 2 days £1195
Book

see all dates


X

Show Discount for this course



PRIVATE COURSES


  Bring a JBI course to your office
  and train a whole team onsite
  0800 028 6400
or request quote


  You can customise this course to
  suit your exact needs here
  0800 028 6400 or request quote


 

 

 

 

Get in touch
0800 028 6400




 

 

view all case studies

 

 

Our inspiring and up-to-date courses gain exceptional feedback

►"great tips to help reduce build times"
► "we got access to exclusive content"
► "intensive course meant less time off"

►"what an inspiring trainer !"
► "colleagues at 2 sites joined via web"
► "I passed my exam the next day"

Newsletter ! Get exclusive news about upcoming programs, technical insights & special offers