HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Who changed SQL server max memory configuration?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
sqlwhomaxmemoryserverconfigurationchanged

Problem

Is there a way to tell who changed SQL server's max memory after a several SQL reboots?. I looked at the default trace log for event category 81 (memory configuration changes) but could not find anything.
SQL server -->reports--> configuration report changes is also empty.
Please suggest.

Solution

YES, there is a way to find out Who did it.

On SQL Log file viewer, on left panel select Windows NT to expand and select Application to display.

You can see details of date, User, computer, etc:

message:
Date        8/02/2014 
Log     Windows NT (Application)

Source      MSSQLSERVER
Category        (2)
Event       2342
User        ???????   THIS IS WHO  "OFFENDER"
Computer    THIS IS THE HOST where he did it

Message
Configuration option 'min server memory (MB)' changed from 2048 to 512. Run the RECONFIGURE statement to install.


Good luck.

Code Snippets

message:
Date        8/02/2014 
Log     Windows NT (Application)

Source      MSSQLSERVER
Category        (2)
Event       2342
User        ???????   THIS IS WHO  "OFFENDER"
Computer    THIS IS THE HOST where he did it

Message
Configuration option 'min server memory (MB)' changed from 2048 to 512. Run the RECONFIGURE statement to install.

Context

StackExchange Database Administrators Q#67912, answer score: 5

Revisions (0)

No revisions yet.