Length: 1 hour
Installing an on-premises SQL Server is easy. But configuring SQL Server to make performance the top priority of all configurable aspects of service usually takes years of study and experience to do well. In this webinar, we’ll take you through the important server settings and configuration options, show you which to change and which to ensure are not changed, and share a toolkit of T-SQL scripts to automate the process. We’ll also spend a few minutes detailing the differences between installations on Windows OS, Linux OS, and in the Azure cloud. We’ll cover important details like:
Prerequisites: Familiarity with Microsoft SQL Server, including installation and configuration.
GOAL 1: How to properly configure CPU settings, memory, and file arrangements for databases and transaction log files
GOAL 2: How to properly configure SQL Server settings for parallelism and other internal configuration options
GOAL 3: Automated jobs to take care of preventative maintenance, backup and recovery, and more
Summary: Learn how to maximize Microsoft SQL Server performance by properly configuring the OS and internal database configuration options.
Interested in additional SentryOne webinars? Check our webinar library.