SQL Server Performance Tuning

COURSE DESCRIPTION

This book provides you with the tools you need to answer those questions. we’ll show you how to set up mechanisms for collecting performance metrics on your server for the SQL Server instances and databases living there. We’ll go over the more tactical methods of collecting data on individual T-SQL calls. Along the way, we’ll be discussing index structure, choice, and maintenance; how best to write your T-SQL code; how to test that code; and a whole slew of other topics. One of our goals when preparing this lesson was to deliver all these things using examples that resemble the types of queries you’ll see in the real world. The tools and methods presented are mostly available with SQL Server Standard edition, although some are available only with SQL Server Enterprise edition. These are called out whenever you might encounter them. Almost all the tuning advice in the lesson is directly applicable to Microsoft Azure SQL Database (MASD), as well as to the more earthbound SQL Server 2014. Most of the tuning advice in the lecture is also immediately applicable to servers running within virtual machines (VMs). The primary differences for both MASD and VMs relate to what performance metrics you can collect and how much trust to put in them. The performance solutions that are code and structure related are immediately applicable to both these environments. IF YOU MASTER THIS TUTORIAL SECTION, YOU WILL DEFINITELY BE READY FOR YOUR FIRST JOB DBA. FIND CERTIFICATION CLASSES HERE

This course is for just about anyone responsible for the performance of the system. Database administrators, certainly, are targeted because they’re responsible for setting up the systems, creating the infrastructure, and monitoring it over time. Developers are too, because who else is going to generate all the well-formed and highly performant T-SQL code Database developers, more than anyone, are the target audience, if only because that’s what we do for work. Anyone who has the capability to write T-SQL, design tables, implement indexes, or manipulate server settings on the SQL Server system is going to need this course/tutorial to one degree or another. Therefore

Who should take up this MS SQL certification training course?

• Software Developers and IT Professionals
• SQL and Database Administrators
• Project Managers
• Business Analysts and Managers
• Business Intelligence Professionals
• Big Data and Hadoop Professionals
• Those aspiring for a career in SQL Development

Prerequisites

There are no specific prerequisites for taking up this SQL course. A basic knowledge of relational DBMS can be helpful for knowing all about MS SQL Server.

Topics include:

• • What Is SQL Server
  • Learn SQL, Structured Query Language
  • What is a Database