For the best web experience, please use IE11+, Chrome, Firefox, or Safari

Configuring SQL Server for Best Performance

Configuring SQL Server for Best Performance
On Demand
  • Recorded Date:Mar. 30, 2021
  • Event:On Demand
Configuring SQL Server for Best Performance

Configuring SQL Server is a three-part process. You have to pick the hardware (physical or virtual), install the software and change settings, based on what you know (or think you know) about the workload you plan to support. 

In this session, Microsoft MVP Andy Warren and Quest® Database Technical Specialist and Market Strategist Tim Fritz will cover these areas. But you’ll receive extra guidance on post-install changes because these are the easiest to change and perhaps the easiest to miss. You’ll see how fixing these settings can make a big impact on SQL Server performance.


Andy Warren is a SQL Server consultant based in Orlando. Andy was a founding principal of, is the former president of the Orlando SQL Server Users Group and one of the founders of SQLSaturday. He has been a Microsoft MVP since 2009 and has extensively written about and presented on SQL Server. Andy blogs at, is on LinkedIn at and is occasionally on Twitter as @SQLAndy.

Tim Fritz is a database technical specialist and market strategist in Quest’s Information Systems Management business unit. Since joining Quest more than 20 years ago, Tim has used his extensive database-focused IT experience to help Quest customers solve business problems by using Quest software solutions. Tim has supported database products his entire tenure at Quest, including Quest® Toad® and Quest® Foglight®.