Author: Eric Cobb

sql server optimize for ad hoc workloads

SQL Server Settings: Optimize For Ad-hoc Workloads

April 17, 2024

I’m my last post on SQL Server Setting, I discussed MAXDOP and how it can affect SQL Server performance. In this post, I’ll review another SQL Server configuration setting that can impact performance – Optimize for Ad-hoc Workloads. What is the plan cache? Every time you run a query in SQL Server, an execution plan…
Read more

sql maxdop

SQL Server Settings: MAXDOP

February 23, 2024

Did you know that not configuring the MAXDOP setting in SQL Server properly could cause performance problems for your queries?

sql server deadlocks

Deadlocks Could Mean Data Loss!

September 13, 2023

Deadlocks in SQL Server are more than just a nuisance, they can be problematic, and even lead to data loss and inconsistencies.

Subscribe to Blog

TAGS
Recent
Database Administration
Script Library

2000 Mallory Lane
Suite 130-707
Franklin, TN 37067

© 2025 The SERO Group.