Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

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

Closed
troymoen1 opened this issue Jul 10, 2023 · 1 comment
Closed

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

troymoen1 opened this issue Jul 10, 2023 · 1 comment
Assignees
@hacitandogan
Labels
wave 3 - complete consider this issue for next wave of fixes

Comments

@troymoen1
Copy link

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 PiJoCoder added the wave 3 - complete consider this issue for next wave of fixes label Aug 8, 2023
@hacitandogan hacitandogan self-assigned this Sep 1, 2023
hacitandogan added a commit to hacitandogan/SqlNexus that referenced this issue Sep 5, 2023
@hacitandogan
add rule for CCC for microsoft#243
d7cc128 
added rule "Common Criteria Compliance Enabled" and stored procedure usp_CCC_Enabled for the Rule
hacitandogan added a commit to hacitandogan/SqlNexus that referenced this issue Sep 13, 2023
@hacitandogan
microsoft#243 update PerfStatsAnalysis.sql
f483851 
added missing EXEC statement for activating the rule.
PiJoCoder added a commit that referenced this issue Sep 13, 2023
@PiJoCoder
Merge pull request #252 from hacitandogan/master
28c6265 
Fix #232 (report appears if all tables are there) #247 (fix working set trimming report) and #243 (add CCC rule)
@PiJoCoder
Copy link
Collaborator

@troymoen1 this is now added. Thanks for filing

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@hacitandogan hacitandogan

Labels
wave 3 - complete consider this issue for next wave of fixes
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@PiJoCoder @hacitandogan @troymoen1