ON DEMAND

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:

• How to properly configure CPU settings, memory, and file arrangements for databases and transaction log files
• How to properly configure SQL Server settings for parallelism and other internal configuration options
• Automated jobs to take care of preventative maintenance, backup and recovery, and more

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.