Menu Icon

Available Training Rooms

  • PRIVATE BATCH
  • PUBLIC PROGRAM
  • ON DEMAND
  • BLENDED

Course Details

  • Course Overview
  • Skills Gained
  • Prerequisites
  • Who Can Benefit
  • Syllabus

In this course, you will learn practical tuning and optimization techniques for SQL Server 2014 that include indexing and statistics strategies, transaction log operations, tempdb and data file configuration, transaction and isolation levels, locking and blocking, and the new In-Memory OLTP engine. You will learn how to create baselines and benchmark SQL Server performance as well as analyze and fix workload for performance issues. This course incorporates materials from the Official Microsoft Learning Product 55144: SQL Server Performance Tuning and Optimization. Skills Gained

In this course, you gain extensive experience using SQL Server 2012 "Always On" technologies to build a variety of high availability solutions.

You learn to install SQL Server on a cluster, set up log shipping, implement database mirroring and use replication as a high availability method.

You Will Learn How To:

  • Leverage SQL Server technologies to achieve high-availability solutions
  • Design a Service Level Agreement that matches business requirements
  • Plan, prepare and install a SQL Server failover cluster
  • Mirror a database to ensure instant failover
  • Automate deployment with Always On technologies
  • Ensure business continuity through failover clusters
  • Course participants creating a SQL Server failover cluster.

Hands-On Experience Includes:

  • Identifying availability requirements
  • Installing a SQL Server failover cluster
  • Backing up and restoring databases with advanced features
  • Maintaining a warm standby server
  • Mirroring the BizRoll database
  • Integrating high-availability techniques
  • Should have experience with database administration, along with a working knowledge of Windows Server.
  • Should know how to backup and recover databases, and manage SQL Server security.
  • Database administrators
  • IT managers
  • Network administrators
  • Anyone involved in planning, supporting or implementing a high-availability solution with SQL Server

High-Availability Fundamentals

Characterizing high availability

  • The "five nines"
  • Site
  • Instance
  • Database
  • Defining a Service Level Agreement

Planned vs. unplanned downtime

  • Performing routine maintenance
  • Recovering from disasters
  • Handling hardware failures

Installing Windows 2008 Fail over Clustering

Defining components of a cluster

  • Single instance architecture
  • Multi-instance architecture
  • Shared storage
  • Resource group
  • Heartbeat
  • Quorum

Preparing for Windows fail over clustering

  • Configuring an iSCSI target
  • Managing shared storage
  • Installing the fail over clustering feature

Establishing SQL Server Fail over Clustering

Planning for SQL Server fail over clustering

  • Upgrading from Windows Server 2003 to 2008
  • Migrating to SQL Server 2008
  • Leveraging virtual machines for clustering

Creating a SQL Server fail over cluster

  • Installing a new fail over cluster
  • Adding a new node
  • Failing over to a passive node

Employing Log Shipping

Preparing for a warm standby server

  • Synchronizing logins
  • Creating network shares

Implementing transaction log shipping

  • Specifying log backup frequency
  • Configuring the log shipping monitor

Switching to the standby server

  • Redirecting applications
  • Bringing the standby online

Configuring Database Mirroring

Comparing mirroring architectures

  • High availability
  • High protection
  • High performance
  • Full safety vs. safety off

Getting ready for mirroring

  • Setting the recovery model
  • Selecting the principal, mirror and witness servers

Mirroring a database

  • Configuring the principal, mirror and witness
  • Initiating the mirroring session

Administering mirroring

  • Enabling and disabling mirroring with scripts
  • Launching the Database Mirroring Monitor (DMM)

Employing a mirror for reporting

  • Taking a database snapshot
  • Querying a snapshot of the mirror

Always On Availability Groups

Enhancing the capabilities of database mirroring

  • Database mirroring with multiple databases and multiple mirrors
  • Manually failing over a group of databases

Clustering and deployment

  • Multi-site clustering across subnets
  • Automating deployment using Always On Power Shell cmdlets
  • Monitoring the high-availability configuration using the Always On dashboard

Combining High-Availability Technologies

Selecting the appropriate strategies

  • Determining the pros and cons of each HA technology
  • Failover clustering with a mirror

Pulling it all together

  • Creating a complete high-availability solution
  • Evaluating the results

Audience

  • Database Administrator
  • Network 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?
  • 10+ 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...