New Training: Monitoring and Managing Instances in Microsoft SQL Server 2016

June 24, 2022 Gilbert

This 33-video intermediate training by SPOTO trainer Garth Schulte teaches you the knowledge systems administrators need in order to navigate, manage and configure different instances of Microsoft SQL Server 2016. You can run multiple databases on one server with different policies.
This is a new SQL training.
A server in Microsoft SQL Server 2016 is nothing but the machine that hosts the software. An instance is a collection of databases that are being used to provide a specific service. You can view and manage multiple instances on a server, as well as apply policies to each instance. This Microsoft SQL Server 2016 Training Managing and Monitoring Instances is the key to this — once it’s completed, a database administrator will be able to use the commands and functionality to view and manage the various instances on a server.
This five-part series covers topics like managing and overseeing your SQL Server instances, running and separating multiple SQL Server instances on the server, and starting, stopping, and viewing instances through console.
You can watch a video from the series here:

This series includes the following skills:
Monitor Database Activity in Microsoft SQL Server 2016.
Monitor Queries in Microsoft SQL Server 2016.
Microsoft SQL Server 2016: Manage Indexes
Microsoft SQL Server 2016: Manage Statistics
Monitor SQL Server 2016 Instances

This training covers the following topics:
Manage Indexes: Manage Existing Columnstore Indexes
Monitor Queries: Identify Problematic Execution Plan
Monitor SQL Server Instances to Identify the Cause of Performance Decree
Monitor Queries: Troubleshoot Server health using Extended Events
Manage Indexes: Lab

This training includes:
2 hours of training
33 videos

Learn SQL today!
Download
Are you not a SPOTO subscriber yet? Start your week-long free trial now.
SPOTO offers everything you need to improve your IT skills and advance in your career: unlimited video training and Practice exams, Virtual Labs and validated learning with in–video Quizzes, Accountability coaching, and access to our exclusive IT professionals community.