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

SQL Server offline after applying service pack

In this post I´ll review two cases that you may bump into when applying service packs in SQL Server. Case 1 You need to install a SQL Server service pack, so you plan, test and got everything ready to apply it in production. You run the installation executable and it finishes successfully. Almost there… when…


LUTI @ Microsoft – Blogging again…

==================================== EN-US ==================================== Since March 2009 this blog was inactive due to the fact that I decided to leave the company back then. Situation that changed last year, when I accepted the challenge of a new position at Microsoft, starting on August 2016 as a Senior Support Engineer for the Data Platform/BI team in Latin…

0