patternsqlMinor
When were there changes in the memory settings of SQL Server
Viewed 0 times
thesettingssqlwerechangesmemorywhenserverthere
Problem
Is there a log, query or any other way to see when there was a change made to the memory settings of SQL Server?
Solution
You could try reading the sql server error log searching for memory configuration changes.
Example on my test machine:
More info on xp_readerrorlog
EXEC xp_readerrorlog 0, 1, "memory"Example on my test machine:
More info on xp_readerrorlog
Code Snippets
EXEC xp_readerrorlog 0, 1, "memory"Context
StackExchange Database Administrators Q#259182, answer score: 3
Revisions (0)
No revisions yet.