SQL Server Performance

sql server memory query - when maximum memory setting is met how do you know old sql processes are r

Discussion in 'ALL SQL SERVER QUESTIONS' started by Trev256b, Aug 11, 2013.

  1. Trev256b Member

    When the SQL server memory setting is met e.g. 6GB, and the buffer cache hit ratio is fine (therefore there is no disk paging) - and SQL is continuously busy and total server (SQL) memory stays at 6GB - 1) how can you tell SQL server is replacing old SQL server processe4s with new SQL Server processes?

    I understand SQL Server will just continue to add new processes to SQL Server memory if there is no limit - I just want to be sure SQL Server replaces old memory processes if there is a maximum SQL Server memory limit.

Share This Page