how to query the history of memory configuration change

Question

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.

Answer 1

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...

Answer 2

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.

Answer 3

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.