question

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

How to query channged memory setting?

Hi there,

I already know how to view changed memory settings in log viewer.
However, I'd like to know if there is any way to query the system log only because when I searched some logs in log viewer, there are so many other logs that I don't want to see.

Is there any possible query to view who or when the memory settings changed?

Thank you 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,

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 ·
OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered
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
0 Votes"
AmeliaGu-msft answered

Hi 86232577,
It seems you have opened a similar thread: https://docs.microsoft.com/en-us/answers/questions/598533/how-to-query-the-history-of-memory-configuration-c.html
Please check if replies in the thread could help you.
You can also go to event viewer->Windows Logs-> right click Application-> choose Find.
And input Configuration option 'max server memory (MB)' to the window and click “find next”.


143345-image.png

143346-image.png


Then you can see who or when the memory settings were changed.


143347-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 (33.7 KiB)
image.png (3.8 KiB)
image.png (34.9 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.