YoVDO

Cross-Platform SQL Server Management - Taming Infrastructure and Application Usage

Offered By: PASS Data Community Summit via YouTube

Tags

PASS Data Community Summit Courses PowerShell Courses Relational Databases Courses Extended Events Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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

Introduction to Databases
Meta via Coursera
Intro to Relational Databases
Udacity
Fundamentals of database systems
Indian Institute of Technology Kanpur via Swayam
Capstone: Photo Tourist Web Application
Johns Hopkins University via Coursera
Web Application Development: Basic Concepts
University of New Mexico via Coursera