Post reply

paging file is too small for this operation to complete

  • August 23, 2013 at 5:42 am

    #281561

    Hi There,

    I have been getting memory pressure errors on the server and below error is from the event log.

    SQLVDI: Loc=ServerBufferAreaManager::RequestBuffers. Desc=Create buffers. ErrorCode=(1455)The paging file is too small for this operation to complete.

    . Process=4356. Thread=7544. Server. Instance=INSTANCE01. VD=Global\VDI_59876801B68-8D0E-4CD2-935D-9A6108DDB324_0_SQLVDIMemoryName_0.

    SQL error log is already recycled so can’t retrieve the exact error. I have been monitoring the server memory and its peaking constantly 124GB whereas total memory is 127GB

    SQL is running on cluster server with Active/Passive so not sure what is causing this.

    When I failover memory is released and it gets maximum to 70GB.

    Could you please advise how to go about it?

  • August 23, 2013 at 5:52 am

    #1644351

    Reduce max server memory or add more memory to the server.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 23, 2013 at 7:04 am

    #1644388

    Thanks Gail.

    But decreasing max memory will have any impact on application users?

    Increasing memory will resolve the issue? Am I right in saying that 10-12 % of total memory is enough for OS and rest can be assigned to SQL server?

  • August 23, 2013 at 7:10 am

    #1644393

    Chapter 4: https://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy