Post reply

SQL Server 2005 Possible Memory Issue

  • November 21, 2008 at 10:44 am

    #132227

    Hi,

    I'm running SQL Server 2005 Enterprise Edition on a Windows 2003 Server Enterprise Edition. The box has 16GB RAM and SQL Server memory allocation is set to dynamic.

    I have a scheduled job that runs every 5 minutes that accesses 20 DMVs and transfers the data into a historical databases as we are required to hold this information for a month and should the SQL Server service be restarted the data would no longer be accessible via the DMVs.

    The problem I am having is that within 10 minutes of the scheduled job being enabled I receive the following OS message:

    "Your system is low on virtual memory. Windows is increasing the size of your virtual memory paging file. During this process, memory requests for some applications may be denied."

    Within a few seconds SQL Server Management Studio then closes, and when I try to re-open it again I received the following OS message:

    "SqlWb.exe - Application Error

    The application failed to initialize properly (0xc000012d). Click on OK to terminate the application."

    I then have to login to the second node of the cluster, start up SQL Server Management Studio, disable the scheduled job and reboot the first node of the cluster. Once I've done this everything is fine until I enable the scheduled job once again, and the same thing happens.

    Does anyone have any ideas as I've been trying to fix this for the last 16 hours and I'm loosing the will to live!

    Thanks in advance.

    www.sqlAssociates.co.uk

  • November 21, 2008 at 10:51 am

    #901774

    I'm hoping that life wouldn't be related to SQL Server performance but... 😛

    To fix this leave the job disabled. 🙂 Sorry, had to do it. Ultimately you are going to have to go through the different views to see which one is causing it to puke. Some of the views can be costly so, it may also be a good thing to post those so that all can look at them to see if there is one or two that are glaring performance killers.

    Thanks!

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • November 21, 2008 at 5:05 pm

    #901927

    Have you tried increasing the page file size?

    http://support.microsoft.com/kb/826513

    MJ

  • November 21, 2008 at 7:15 pm

    #901946

    are you on SP2?

    Alex S

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

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