Post reply

Memory and performance

  • November 7, 2003 at 2:20 am

    #151970

    I have a few questions regards memory and SQL servers.

    1. Is there any template of how much memory you should have compared with the size of the tables?

    2. Have someone some experience regards queries in tables over 2 mill entries using MSDE?

    3. How important is the CPU for the performance?

  • November 7, 2003 at 5:05 am

    #481205

    1) I don't know.

    2) Yes, can be sluggish to great depending on indexing. Same engine as the other editions just a little stripped down.

    3) CPU is always important it handles doing all the work of retrieving, calculating, joining, nothing happens to the data that doesn't occurr on the CPU. Memory is just faster storage of data.

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

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