SQL Server Settings
As database administrators, we want to get as much performance as we can out of our SQL Servers. Microsoft has provided a few knobs for us to tweak in the Operating System, the local security policy, and in the engine itself and in episode 50 of the SQL Data Partners Podcast, we review some of these SQL Server settings and how you might take advantage of some and avoid others.
My guest today is Justin Randall, the professional services manager at SQL Sentry. As someone who is going into many environments he has seen some of these knobs be used wisely and some not so wisely. Justin lives in Charlotte, North Carolina and is a frequent speaker in the SQL Server community.
This episode touches base on the power settings of the server, instant file initialization, max degree of memory, boost SQL Server priority, shrink database and a few others.
I am also happy to announce Steve Stedman is joining me as co-host of the podcast. Steve was a guest in episode 13 and since that time we have kept up with each other and as I thought about where I wanted to go with the next 50 episodes, I think Steve can help me get there. We are introducing a new segment on the show called the Tuning Review which is a short conversation between Steve and I centered around performance, disaster recovery, or questions/interactions we have with listeners of the show.
Justin Randall is the Professional Services lead with SQL Sentry.
Meet the Hosts
With more than 10 years of working with SQL Server, Carlos helps businesses ensure their SQL Server environments meet their users’ expectations. He can provide insights on performance, migrations, and disaster recovery. He is also active in the SQL Server community and regularly speaks at user group meetings and conferences. He helps support the free database monitoring tool found at databasehealth.com and provides training through SQL Trail events.
Eugene works as an independent BI consultant and Pluralsight author, specializing in Power BI and the Azure Data Platform. He has been working with data for over 8 years and speaks regularly at user groups and conferences. He also helps run the GroupBy online conference.
Kevin is a Microsoft Data Platform MVP and proprietor of Catallaxy Services, LLC, where he specializes in T-SQL development, machine learning, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL, president of the Triangle Area SQL Server Users Group, and author of the books PolyBase Revealed (Apress, 2020) and Finding Ghosts in Your Data: Anomaly Detection Techniques with Examples in Python (Apress, 2022). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather's nice enough.