Post reply

SQL2005 error

  • December 13, 2006 at 3:14 am

    #171569

    Hi,

     

    I have a SQL 2005 server that has SP1 installed and it has developed an error:

    "Failed to initialize the Common Language Runtime (CLR) v2.0.50727 due to memory pressure. Please restart SQL server in Address Windowing Extensions (AWE) mode to use CLR integration features."

    There does seem to any pressure on the memory, it has 1.5gb installed and even at peak usage it has 250mb available. Any ideas as to what this error could be.

     

    Thanks

    Andy

  • December 14, 2006 at 1:19 pm

    #678195

    The OS and/or other applications on the server are using too much memory. SQL Server can not get enough memory to run CLR.

    Firt of all, you need more memory. I wouldn't run SQL Server with less than 3 GB of RAM even on a dare.

    Secondly, set a minimum amount of RAM for your server to reserve. With 1.5 GB, reserve 1 GB for SQL Server.

    My blog: SQL Soldier[/url]
    SQL Server Best Practices:     SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

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

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