1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

70-443

Discussion in 'General Microsoft Certifications' started by windowcleaner, Nov 28, 2008.

  1. windowcleaner

    windowcleaner New Member

    1
    0
    1
    Hello

    Hope I'm in the right area.

    I've started studying for the above exam using the Microsoft book called "Designing a database server Infrastructure using SQL SERVER 2005" by J.C Mackin and Mike Hotek.

    On chapter one page 47 there is a section called BUFFER CACHE REQUIREMENTS.

    There is an example explaining how to work out how much memory is taken by the cache by queries. I don't understand it. It says "30 users will execute Query A with a unique output of 400kb". It works the answer that the Query A would require approx. 120MB in the buffer cache. How is this calculated?

    I was working it as...

    (400/1024)*30
    =11.71MB

    Steve
     

Share This Page

Loading...