As title, how to query the history of memory configuration change in SSMS?
I already know how to check the history log of memory configuration change in SQL Log Viewer but I'd like to know how to query this.
In SQL Log Viewer, there are so many logs that I don't want to see so that's why I'm asking how to query it.
Do you have any idea or tips to share? Thanks in advance.
Hi 86232577,
How are things going? Do the answers help you?
Please feel free to let us know if you have any other question.
If you find any post in the thread is helpful, you could kindly accept it as answer.
Best Regards,
Amelia
Re you looking for something like:
EXEC sys.sp_readerrorlog @p1 = 0, @p2 = 1, @p3 = N'max server memory (MB)';
?
Where @p1 = 0 is the current log, I just read this myself from here (https://dba.stackexchange.com/questions/89815/when-was-a-database-taken-offline), from what i understand you can not search all available logs. you have to step through them...
Do you have any idea or tips to share?
In SSMS Logfile View use the "Filter ..." function on top to filter on entries you are looking for.
Hi 86232577,
In addition, you can view the memory configuration history in the SSMS-> right-click the server name->Reports -> Standard Reports->Configuration Changes History.
Best Regards,
Amelia
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
17 people are following this question.
