• Robin35 (5/16/2013)


    One application job has run from 3:30 AM to 5 AM today morning...we got the alert around...4:07 AM.

    Not sure if its the reason...

    Do i need to change the memory config of sql server to make this alert go ?

    please let me know

    thanks

    The way you have your SQL Server configured:

    Memory : 12 GB

    SQL Memory config : Min 7168, Max 8192 MB

    Says that 4 GB will be left for non-buffer pool memory. This includes some memory (for things mentioned earlier) used by SQL Server, but also for the OS. You need to find out what else is using memory on your server. You could back down the max memory setting from 8192 to something lower, but chances are whatever this thing is, it will gobble up whatever else you leave open for it to grab anyway so best to figure out what it is. What you can do is, setup a PowerShell script to run every minute that stores the list of all OS processes and how much memory they are using. Then, when you encounter an issue like this you can refer to that list and see the culprit. Maybe your monitoring software, the one sending you the alerts, is already doing this or can be setup to do it without writing any code yourself.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato