Memory utilization each database

• tyang

  SSCrazy

  Points: 2231

  More actions

  January 27, 2004 at 8:55 am

  #81882

  I used 'select memeusage, program_name from sysprocesses' to retrieve the memory page utilization per database, the memory page for one of the databases is 450,000 pages, which is 3600,000KB. There is only 2GB memory allocated to SQL server, how could one database use 3.6GB memory?

• January 30, 2004 at 8:00 am

  This was removed by the editor as SPAM

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737004

  More actions

  January 30, 2004 at 9:56 am

  #492365

  Virtual memory