locked
Buffer cache is full RRS feed

  • Question

  • Hi,

    The sql server jobs are failing with error Buffer cache is full.


    Thanks
    Wednesday, January 11, 2012 8:55 AM

Answers

  • Well, how much memory does the server have? Have you set up MAX memory parameter?

    What does the below return?

    --sql server uses the memory

    select 

    CONVERT(VARCHAR,CAST(bpool_committed *8  AS MONEY),1)AS [SIZE],

    bpool_committed,bpool_commit_target 

      from 

    sys.dm_os_sys_info


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Wednesday, January 11, 2012 8:57 AM

All replies

  • Well, how much memory does the server have? Have you set up MAX memory parameter?

    What does the below return?

    --sql server uses the memory

    select 

    CONVERT(VARCHAR,CAST(bpool_committed *8  AS MONEY),1)AS [SIZE],

    bpool_committed,bpool_commit_target 

      from 

    sys.dm_os_sys_info


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Wednesday, January 11, 2012 8:57 AM
  • Thanks

    16 GB is the total Ram.

    I have use the query :select bpool_committed,bpool_commit_target   from sys.dm_os_sys_info

    Answer: 1283925,1852693

     


    Thanks
    Wednesday, January 11, 2012 9:14 AM
  • can you provide complete error message?
    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog | Team Blog | @Twitter
    Wednesday, January 11, 2012 9:30 AM
  • Sorry Uri,

     right now I have not the error message.


    Thanks
    Wednesday, January 11, 2012 9:37 AM