SQL Server Performance

marked for unload due to memory pressure

Discussion in 'Getting Started' started by nitinshetye, Apr 5, 2011.

  1. nitinshetye New Member

    Hi,
    Could you please help me in getting rid over following error that I am getting :-
    2011-04-05 08:16:32.31 spid1s AppDomain 70 (SMS_K01.dbo[runtime].69) is marked for unload due to memory pressure. 2011-04-05 08:16:32.49 spid15s AppDomain 70 (SMS_K01.dbo[runtime].69) unloaded. 2011-04-05 08:17:02.70 spid243 AppDomain 71 (SMS_K01.dbo[runtime].70) created.
    Details of the server are as below :-
    It’s a SCCM server.
    SQL 2008 SP2 64 Bit.
    Microsoft SQL Server 2008 (SP2) - 10.0.4272.0 (X64) Jan 5 2011 22:23:43 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <x64> (Build 7600: ) (VM)
    Total Physical Memory – 6GB Memory allocated for SQL Server – 2.5GB
    regards,
    Nitin
  2. satya Moderator

  3. nitinshetye New Member

    HI Satya,
    I have already gone through thus article. It talks about 32 bit and we are having 64 bit SQL 2008. Have also tried -g parameter but no luck. Yes we do have CSS account. but before that I am looking for workrounds.
    regards,
    Nitin
  4. satya Moderator

    As you clarify further that its a 64bit environment, its best to invoke CSS call for any hotfix that may be pertaining to your environment.
    Also have a look at recent Cumulative update package releases since the last service pack release.
    956909 (http://support.microsoft.com/kb/956909/ ) The SQL Server 2008 builds that were released after SQL Server 2008 was released
  5. Anonymous New Member

    Chemistry and Physics from Wright State University and a M.S. in tiffanys Physics from Casetiffany Institute. She spent 10 years at HP working in product development project management andtiffany bracelets engineering leadership.tiffany rings She worked with tiffany keysseveral startups

Share This Page