Post reply

Buffer size

  • March 6, 2012 at 9:18 am

    #265544

    Another naive question from developer (not administrator):

    One procedure (that contains 6 other procedures) sometimes does not execute because of buffer size (error message).

    1) how can I check the buffer size?

    2) can I change it?

    Thanks

  • March 6, 2012 at 9:56 am

    #1455446

    to get a detailed report of SQL Servers memory you below dbcc command

    DBCC MEMORYSTATUS

    java programming

  • March 6, 2012 at 3:49 pm

    #1455648

    What's the exact error message?

    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

  • March 7, 2012 at 10:08 am

    #1456124

    I shrinked database and now I do not have this buffer message. And I cannot reproduce it from the top of my head. As soon as it shows up again I'll let you know.

    Thanks

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

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