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