Post reply

Buffer Manager

  • July 18, 2011 at 9:26 pm

    #244471

    Comments posted to this topic are about the item Buffer Manager

    Thanks

  • July 18, 2011 at 9:28 pm

    #1354598

    Nice easy question .. and thank goodness one that will NOT provoke arguments and the begging for "I want my points"

    So thank you

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • July 19, 2011 at 1:06 am

    This was removed by the editor as SPAM

  • July 19, 2011 at 1:26 am

    #1354632

    Thank you for the question

    It says on msdn link:

    "You can query the bpool_commit_target and bpool_committed columns in the sys.dm_os_sys_info catalog view to return the number of pages reserved as the memory target and the number of pages currently committed in the buffer cache, respectively."

    Why would you someone need to query for such information?

    Thank you,

    Iulian

  • July 19, 2011 at 2:04 am

    #1354640

    Iulian -207023 (7/19/2011)

    Thank you for the question

    It says on msdn link:

    "You can query the bpool_commit_target and bpool_committed columns in the sys.dm_os_sys_info catalog view to return the number of pages reserved as the memory target and the number of pages currently committed in the buffer cache, respectively."

    Why would you someone need to query for such information?

    Thank you,

    Iulian

    To maintain performance stats, maintain baseline information etc.

    M&M

  • July 19, 2011 at 2:15 am

    #1354647

    Why is it called ramp-up though?

  • July 19, 2011 at 2:42 am

    #1354655

    😀 ... very true! This has been the case for 1 or 2 questions within the last 2 wks.

  • July 19, 2011 at 2:43 am

    #1354657

    bitbucket-25253 (7/18/2011)

    Nice easy question .. and thank goodness one that will NOT provoke arguments and the begging for "I want my points"

    So thank you

    😀 ... very true! This has been the case for 1 or 2 questions within the last 2 wks.

  • July 19, 2011 at 2:53 am

    #1354662

    paul s-306273 (7/19/2011)

    Why is it called ramp-up though?

    Good point, looking at wiki:

    Ramp up is a term used in economics and business to describe an increase in firm production ahead of anticipated increases in product demand. Alternatively, ramp up describes the period between product development, and maximum capacity utilization, characterized by product and process experimentation and improvements

    This looks to me pretty much the way buffer management works.

    Regards,

    Iulian

  • July 19, 2011 at 5:28 am

    #1354719

    Good question thanks.

    http://brittcluff.blogspot.com/

  • July 19, 2011 at 7:28 am

    #1354775

    Nice question, thanks.

  • July 19, 2011 at 10:20 am

    #1354955

    Good call, managed to research it and find the answer but still worth knowing!

  • July 19, 2011 at 10:29 am

    #1354977

    thanks for the question

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • July 19, 2011 at 11:55 am

    #1355071

    Iulian -207023 (7/19/2011)

    Thank you for the question

    It says on msdn link:

    "You can query the bpool_commit_target and bpool_committed columns in the sys.dm_os_sys_info catalog view to return the number of pages reserved as the memory target and the number of pages currently committed in the buffer cache, respectively."

    Why would you someone need to query for such information?

    Thank you,

    Iulian

    To tell if your system had finished starting up or as todays QOTD calls it finished "ramp-up".

    Never heard of the terminology "Ramp-Up" in reference to SQL server before today. Apparently it is so obscure that even MSDN does not show a single SQL server result when searching the text "Ramp-Up".

    I have documented the time to reach the bpool_commit_target before. Used this once to calculate and document the Full time needed for a cluster fail-over and recover to the a point of operation prior to the fail-over event. The idea was that once the Query Buffer or bpool_commit_target was reached the new node was working and responding to data requests.

  • July 20, 2011 at 11:10 am

    #1355883

    Good clear question and answer, but I thought at first that a knowledge of English mades it almost impossible to get it wrong (if one assumes writers of BoL also know English) - so perhaps it was a bit too easy. Then I looked and saw 431% wrong so far - does this indicate that 41% of answerers didn't have good English, or that there is something I don't now about English that I ought to?

    Tom

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

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