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.
Overview
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
Related Courses
-
Turbocharge Your SQL Server with In-Memory Database
-
Best Practices for Deployment of SQL Server on Azure Virtual Machines
-
A Beginner's Guide to Becoming a Performance Tuner
-
Improving Availability in SQL Server and Azure SQL Database with Accelerated Database Recovery and Resumable Operations
-
Choosing Database Hardware for SQL Server 2019
-
SQL Server Migration - The Last Mile
