This course provides the knowledge and skills needed to gain basic proficiency with the extensive performance monitoring and optimization capabilities of SQL Sentry on the SentryOne platform. Using our practical, real-world approach to SQL Server performance analysis and tuning, students learn how to use this powerful toolset to find and correct the SQL Server performance problems prevalent in organizations today.
All craftsmen know that a key element to obtaining proficiency in their trade is knowing the purpose of each tool in their toolbox and what tool to use in every situation. We start this course by introducing you to the tools in the SentryOne toolbox.
Before we start delving into details, it’s important we understand the fundamentals. In this module we cover the role played by each SentryOne component, the Windows and SQL Server features used to enable data collection, and your deployment options that ensure an efficient and reliable monitoring solution. We also discuss factors impacting the size and responsiveness of the SentryOne database, and how to ensure maximum performance. Topics covered include:
Our Performance Analysis and Event Calendar functionality are built on some foundational concepts of what we should expect from monitoring and performance software and how it should work. It is important we understand what they are and how they have been implemented. Topics covered include:
Security is an essential element of any software product. In this module we discuss permissions required by SentryOne to monitor your systems, user access privileges necessary to use the SentryOne client effectively, and options available to limit user access. Topics covered include:
The SentryOne Client provides a seamless experience for SQL Server and Windows monitoring and optimization, query tuning, alerting and job scheduling. This module discusses the elements of the SentryOne Client and their basic usage. Topics covered include:
Organizations’ SQL Server landscapes come in all shapes and sizes in response to their own business needs. The Performance Analysis and Event Calendar features have been designed to monitor most every configuration from a single, local SQL Server instance to hundreds of instances (virtual and physical) deployed in multiple data centers around the world.
The SentryOne platform enables you to create a comprehensive Monitoring and Response System using Conditions, Actions, and Settings. This module explores each of these concepts in depth, and discusses how to implement them effectively. Topics covered include:
Beyond monitoring and alerting on scheduled and unscheduled events such as job failures and deadlocks is performance monitoring. At this level we want our monitoring solution to be on the lookout for high resource utilization, combinations of performance metrics exceeding defined thresholds, and deviations from established baselines. In this module we examine how to realize this level of monitoring, and more. Topics covered include:
SQL Server offers a range of native high availability solutions to meet most every budget and business requirement. SQL Sentry provides a centralized monitoring and alerting mechanism for all of them.
We can’t always be actively doing Performance Analysis, waiting for indications of a performance issue. Instead, use Advisory Conditions to define performance metric based conditions and alerts.
Troubleshooting SQL Server performance issues does not lend itself to formulaic approaches. Individual metrics provide clues, but combinations of the right metrics, along with an understanding of “normal” behavior usually leads down the correct path to resolution. SQL Sentry excels at showing you combinations and correlations of metrics that, when combined with an understanding of how SQL Server works, makes finding the right path much easier. In this module we will explore methods for uncovering the root cause of common SQL Server performance issues. Topics covered include:
Plan Explorer helps you quickly get to the root of query tuning issues by making it obvious where issues exist in your execution plans. SentryOne continuously captures deep plan information for slow, poorly performing T-SQL. In this module we discuss the basics of query plan analysis and query tuning using Plan Explorer. Topics covered include:
Performance related SentryOne data can be accessed using any web browser on any device from cloud.sentryone.com. In this module we present our current cloud based feature set, and walk through deploying your data. Topics covered include:
This module will provide a wrap-up of topics in this course, a preview of Mastery level topics, and an opportunity for students to evaluate the course.
For your convenience here are links to supported browsers:
Your browser could be incompatible with this website.
If you close this window and continue you may experience less than optimal behavior.