Microsoft SQL Server 2016: Monitoring Database Activity and Queries
Descripción: Curso Microsoft SQL Server 2016: Monitoring Database Activity and Queries
Formación en Microsoft SQL Server 2016: Administering a SQL Database Infrastructure
An enterprise database infrastructure has a lot of moving pieces, and it's crucial that they be monitored. This course focuses on managing and monitoring SQL Server database activity and queries. Covered topics include monitoring current sessions, identifying sessions that cause blocking activity or consume tempdb resources, configuring a data collector, and creating a utility control point. In addition, it covers query monitoring activities such as managing the Query Store, configuring Extended Events and trace events, identifying problematic execution plans, and troubleshooting server health using Extended Events. This course is one of a series in the Skillsoft learning path that covers the objectives for the 70-764: Administering a SQL Database Infrastructure exam.