Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Practical Guidance to Make Your Tier-1 SQL Server Roar

PASS Data Community Summit via YouTube

Overview

Discover essential strategies for optimizing tier-1 SQL Server performance in this comprehensive conference talk from PASS Data Community Summit. Learn current recommendations for configuring and maintaining high-performance database systems, whether in your datacenter or on SQL Server on Azure Virtual Machines. Explore performance considerations at various levels, including platform, physical and virtual server configurations, and Infrastructure as a Service. Gain insights into server configuration, licensing options, parallelism, memory management, I/O considerations, and trace flags. Understand the importance of tempdb optimization and partitioning for maximizing SQL Server performance. Benefit from the expertise of the SQL Server team as they provide practical guidance to enhance your database system's capabilities and efficiency.

Syllabus

Intro
Session Evaluation
Pedro Lopes He/Him
Pam Lahoud She/Her
What's a tier-1 SQL Server?
Performance considerations at every level
Platform
Physical Server
Virtual Server Considerations
Infrastructure as a Service Considerations
Server (OS) Configuration
Core Licensing vs. CAL Licensing
Core vs. CAL Licensing in Setup (SQL Server 2019)
Parallelism in Setup :: SQL Server 2019
Memory in Setup : SQL Server 2019
Memory-Large Pages
I/O Considerations
Trace Flags
tempdb
Partitioning?

Taught by

PASS Data Community Summit

Reviews

Start your review of Practical Guidance to Make Your Tier-1 SQL Server Roar

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.