5 Commonly Overlooked SQL Server Settings

5 Commonly Overlooked SQL Server Settings

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.

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

    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

    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"

    "A good plan"

    Renowned U.S.

  • Five Goals for Your SQL Servers in the New Year

    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

    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

    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?

    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

    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?

    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

    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 条评论

社区洞察

其他会员也浏览了