Menu Icon

Available Training Rooms

  • PRIVATE BATCH
  • PUBLIC PROGRAM
  • ON DEMAND
  • BLENDED

Course Details

  • Course Overview
  • Benefits Of Learning
  • Who Can Benefit
  • Prerequisite
  • Syllabus

SQL Server is Microsoft's flagship database product and is a strong challenger to Oracle's long held dominant position as market leader. The constant demand for more flexible, deeper, and generally larger databases means that performance becomes a serious issue when your business depends upon instant access to that data. This course has been written to cover all the main aspects of tuning the performance of SQL Server. It builds upon several sections of the programming course and the administration course, focusing in on those aspects of SQL Server that potentially cause performance bottlenecks.

  • 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 analyze the status of tables and optimiser behavior.
  • Solid advice on tips and techniques to overcome these problems, keep them at bay and stop them happening in the first place.

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

Delegates should have a good background knowledge of SQL Server.

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

Audience

  • Database Developer
  • Database Administrator

Public Program Schedule

Course Name Duration Brochure Location Schedule Enroll
There is no upcoming Public Batch Schedule, you can ask for Private Batch or for On-Demand Learning

Download the syllabus

Download

The highest standard, The happiest learners

Our Enterprise Clients

FAQ

  • Why should I choose RPS?
  • I am working, is it possible to arrange the classes on weekends?
  • Please confirm if your office is open on weekends?
  • Can I get the courseware in advance before start of training?
  • What are the timings (class hours)?
  • How can I make the payment?
  • What is the mode of payment?
  • Candidate authorized RPS to charge $200. But the bank has charged $208. Why is this?
  • If we need training on one of the modules only how does that work?
  • How long before do we need to book the exams?
  • Where are your training centers available?
  • Can I pay the fee in installments?
  • What are the refund policies? Can i get my money back in case i am unable to attend the training?
  • Do you provide a bank loan facility?
  • 14+ years of Training Expertise
  • Gold Learning Partner for Microsoft
  • Certified instructors with industry standard experience
  • Tailor made training available
  • 6+ training Locations
  • 100000 + professional trained
  • Customer Satisfaction
  • Reliable and Most cost effective Training

Yes, we do offer weekend classes for professionals in group or 1-to-1 Training depending upon the technology.

The administrative and sales staff works on weekdays (Monday - Friday). System Admins and Operation team are available on all days.

Yes, after you have paid the booking amount (which will be non–refundable in this case). Booking amount depends on the technology selected.

Training timings are from 9 am to 5 pm.

You can send the deposit by any of the following methods:-

  • PayPal
  • Credit Card
  • Bank Transfer
  • Demand Draft
  • Cash
  • Purchase Order (in case of Corporates / Government).
  • If you are an International student, the registration amount of USD 200 can be paid by Bank Transfer or PayPal/PayUMoney . The balance amount has to be paid by traveler's cheque or cash after arrival in India. You can also pay the balance by PayPal. There is a surcharge of 4% in this case.
  • For Indian Resident students, the course fees including registration can be paid by Cash, Cheque, Demand Draft or Bank transfer.To Know more Please call +919883305050 or Email us at info@rpsconsulting.in for any of your queries.

Overseas credit card payments through PayPal involve a mark-up of up to 4% as surcharge.

We can provide customized 1-to-1 training for a technology as per your requirement.

Most exams can be booked once you are on the course (e.g. Microsoft, ITIL, VEEAM, EC-Council). Red Hat and some other exams have to be booked in advance.

Our training centers are available in Bangalore, Chennai, Hyderabad, Pune and Delhi.

We do not have facility to pay in installments

If the course fee has been paid for and RPS cancels the Course, a refund will be provided, else the courses are non-refundable.

We do not provide loan facility.

Other Related Courses

Related courses will be updated soon...