Post reply

Auditing changes in Max Server Memory

  • October 25, 2012 at 4:39 pm

    #284046

    Hi there!

    I need to track down changes in the "Max Server Memory" option in SQL 2k8 R2. I need to get date/time of the change, such as the login who dit it.

    I've tried auditing execution of sp_configure, and UPDATES in sys.configurations, but none of these worked.

    I've also thought in CDC, but you can't enable it on system databases.

    Does anyone have a clue?

  • October 26, 2012 at 1:26 am

    #1553051

    set the profiler trace see if it helps

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • October 26, 2012 at 10:01 am

    #1553278

    Tks, Bhuvnesh, but... I'm sorry, I forgot to mention: I need something to keep running on the server for some time. A trace running for long would consume too many resources.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply