How to query channged memory setting?

중석 김 1 Reputation point
2021-10-25T01:35:43.79+00:00

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,605 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 40,576 Reputation points
    2021-10-25T06:53:42.757+00:00
    0 comments
  2. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
    2021-10-25T07:25:14.823+00:00

    Hi 86232577,
    It seems you have opened a similar thread: https://learn.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.

    0 comments