Cross-Platform SQL Server Management - Taming Infrastructure and Application Usage
Offered By: PASS Data Community Summit via YouTube
Course Description
Overview
Learn to effectively monitor SQL Server instances using extended events in this 59-minute conference talk from PASS Data Community Summit. Discover techniques for capturing essential data, analyzing CPU and resource utilization, and tracking causality. Explore best practices, SSMS setup, and PowerShell scripting for improved infrastructure and application management. Gain insights into performance optimization through data analysis, stacked bar charts, and maximum dispatch latency evaluation. Enhance your SQL Server monitoring skills with practical demonstrations and a comprehensive Q&A session.
Syllabus
Introduction
Agenda
CPU Utilization
Data Analysis
Stacked Bar Chart
Topics Covered
Best Practices
SSMS Setup
PowerShell Script
Resource Utilization
Causality Tracking
Demo
Performance and Resource Utilization
Questions Answers
Maximum Dispatch Latency
Taught by
PASS Data Community Summit
Related Courses
Windows PowerShell FundamentalsMicrosoft via edX Windows 10 Features for a Mobile Workforce: Managing and Maintaining Devices in the Enterprise
edX Deploying Your First Resources in Azure
Udemy Advanced Server 2016 Administration: Hands-on Training
Udemy Windows Server 2016 Administration
Udemy