SQL Server Performance

SQL Server Memory Calculation

Discussion in 'SQL Server 2008 General DBA Questions' started by leonardustono, Apr 1, 2010.

  1. leonardustono New Member

    Hi All,
    first, let me introduce my self. my name is Leon, i'm a DBA production. i want ask about SQL Server memory sizing best practice.how to calculate the size of memory for a few user in a system? how to obtain the rasio between size of memory and count of user in a system ? is this ratio can be used as a baseline for memory sizing ??
    thank you for help.
    best regards,
    Leon
    leonardustono, Apr 1, 2010
    #2

  2. Luis Martin Moderator

    Welcome to the forums!.
    SQL use the memory dynamically. I don't think there is a number between users and memory. It depends on others factor like DB size, how many DB, is SQL dedicated?, etc.
    In general more memory more performance.
    Luis Martin, Apr 1, 2010
    #3

  3. leonardustono New Member

    Hi Luis,
    nice to meet you and thank you for your help..
    yes, SQL use the memory dynamically.. that's what caused me a little confused to calculate memory to get baseline to memory sizing of database server..
    or do you have a best practice to memory sizing of database server ? but this sizing is based on our database production server that already i have now..
    thank you for your help..
    best regards,,
    Leon
    leonardustono, Apr 1, 2010
    #4

  4. MohammedU New Member

    MohammedU, Apr 2, 2010
    #5

Share This Page