question

86232577 avatar image
0 Votes"
86232577 asked AmeliaGu-msft commented

how to query the history of memory configuration change

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.

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

0 Votes 0 ·
NilssonFredrikK-3135 avatar image
1 Vote"
NilssonFredrikK-3135 answered NilssonFredrikK-3135 edited

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





5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

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.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AmeliaGu-msft avatar image
1 Vote"
AmeliaGu-msft answered

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.

142394-image.png

142348-image.png

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.



image.png (32.2 KiB)
image.png (21.0 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.