search

microsoft / SqlNexus

SQL Nexus is a tool that helps you identify the root cause of SQL Server performance issues. It loads and analyzes performance data collected by SQL LogScout, SQLDiag or PSSDiag. It can dramatically reduce the amount of time you spend manually analyzing data.
MIT License
348 stars 99 forks source link

Generate Best Practice/Analysis Summary warning for Common Criteria Compliance. #243

Closed troymoen1 closed 12 months ago

troymoen1 commented 1 year ago

In a recent SharePoint support case, a user that had recently upgraded SQL and SharePoint was seeing performance issues. It was eventually found that Common Criteria Compliance was the root cause. A warning in Nexus that this is enabled and can and will cause performance issues would be great. Note that we do call out performance issues in the public article:

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/common-criteria-compliance-enabled-server-configuration-option?view=sql-server-ver16

PiJoCoder commented 12 months ago

@troymoen1 this is now added. Thanks for filing