5 Commonly Overlooked SQL Server Settings

5 Commonly Overlooked SQL Server Settings

Joe Webb Joe Webb

Joe Webb

SQL Servers Healthy, Secure, And Reliable | Banking & Healthcare | Managing Partner of The SERO Group | DBA Team as a Service | Former 8-time Microsoft SQL Server MVP

发布日期: 2022年5月4日
+ 关注

When we examine SQL Servers as part of our SQL Server Health Checks, we frequently find five commonly overlooked SQL Server settings that can put performance, reliability, and even data at risk. Here they are in an infographic.

No alt text provided for this image

Fortunately, these are not difficult to resolve.

Joe Chang

2 å¹´

I’d like to know if anyone has a use case for the -x setting. Nothing is free. This would be like nascar, no a/c, not door, etc

赞
回复

要查看或添加评论，请登录

Joe Webb的更多文章

  • What is the Difference in SQL Server FCIs and AGs? A Short Summary
    2021年5月28日

    What is the Difference in SQL Server FCIs and AGs? A Short Summary

    “What’s the difference in SQL Server FCIs and AGs?” That question comes up frequently when talking High Availability…

    1 条评论
  • Where to Start with Disaster Recovery in SQL Server
    2021年4月19日

    Where to Start with Disaster Recovery in SQL Server

    Backup and restore? Log shipping? Maybe Failover Clustered Instances or Availability Groups can be used? Oh, what about…

    3 条评论
  • "A good plan"
    2021年3月5日

    "A good plan"

    Renowned U.S.

  • Five Goals for Your SQL Servers in the New Year
    2021年1月5日

    Five Goals for Your SQL Servers in the New Year

    We’ve made it! The start of a new year. Now is a great time to reflect on what you’d like to accomplish over the next…

  • Vollgar: Scripts to Help Review Your SQL Servers
    2020年4月7日

    Vollgar: Scripts to Help Review Your SQL Servers

    Last week, Guardicore released information about a newly discovered attack that uses SQL Servers to compromise servers…

  • Camp, Hike, and SQL
    2019年11月11日

    Camp, Hike, and SQL

    Recently, I had the pleasure of sitting down to talk with Thom Coats of The Unstuck Business Academy for their “Stories…

    1 条评论
  • Is My SQL Server Configured Properly?
    2019年8月6日

    Is My SQL Server Configured Properly?

    Installing SQL Server is surprisingly easy. Download the media, double-click the setup file, answer a few questions…

  • 4 Options Now That Your SQL Server 2008 Is Out of Support
    2019年7月9日

    4 Options Now That Your SQL Server 2008 Is Out of Support

    As of July 9, 2019, SQL Server 2008 and SQL Server 2008 R2 have officially passed from Extended Support to No Longer…

  • How many tempdb files should my SQL Server have?
    2019年7月2日

    How many tempdb files should my SQL Server have?

    We're frequently asked how many tempdb files a SQL Server should have, especially from those who have downloaded our…

  • The 9 Best Books of 2018
    2019年2月6日

    The 9 Best Books of 2018

    It’s what you learn after you know it all that really counts. – John Wooden As an avid reader and life-long learner…

    1 条评论

社区洞察

其他会员也浏览了