AUDIT does not respect the MAX_ROLLOVER_FILES configuration

In one of the cases that I worked in the past months, customer reported that the SQL Server audit mechanism wasn´t respecting the option MAX_ROLLOVER_FILES. The context is: Many SQL Server instances with had AUDIT configured, writing events to files locally. A view was created in each instance to access the audit files and maintain…

0

SQL Server is using only one processor/CPU

Recently I have collaborated in some cases with the same symptom: customer reported that is using SQL Server and noticed that in the machine only one CPU hit 100% utilization, while the utilization of the other CPUs didn´t have a sustained usage of more than 10%. The scenarios have the same characteristic: using a SQL…

0