Manage SQL Server Farm via SSMS - Cross-Platform SQL Server Management
Offered By: PASS Data Community Summit via YouTube
Course Description
Overview
Learn how to efficiently manage and monitor multiple SQL Server instances from a single workstation in this conference talk. Explore challenges, features, and solutions for SQL Server farm management using SSMS. Discover techniques for creating SQL Server policies, deploying agent jobs, and configuring data collection. Gain insights into activity monitoring, CPU time analysis, and sample data handling. Master the art of cross-platform SQL Server management with minimal administration effort.
Syllabus
Introduction
Challenges
Features
Register Servers
Create SQL Server Policy
Agent Job Deployment
MDW
Questions Answers
One Question
Limit Users
Other Solutions
Configure Data Collection
Snapshot Report
Cache vs Non Cache
Log File
Activity Monitor
CPU Time
Sample Data
Summary
Taught by
PASS Data Community Summit
Related Courses
Observing and Analysing Performance in SportOpenLearning Statistics: Making Sense of Data
University of Toronto via Coursera Financial Planning
TAFE NSW via Open2Study Mobiles for Development
Indian Institute of Technology Kanpur via Independent Valoración de futbolistas
Universitat Politècnica de València via UPV [X]