SQL Server 2k SP3 Memory

• maltiparmak

  Newbie

  Points: 1

  More actions

  January 28, 2008 at 7:09 am

  #127646

  Hi.I have a problem like that.

  My company site in ASP.We are using sql2K.I want to know which sql sentence in asp take long time in asp.

  Because SQL server every time using the most of the memory of server (win 2000 server).

  Can you help me please.

• Sergiy

  SSC Guru

  Points: 110209

  More actions

  January 28, 2008 at 4:31 pm

  #772689

  SQL Server will always take as much memory as you allow it to take.

  It uses it to cache execution plans, returned resultsets, derived tables, etc.

  It does not erase it until it runs out of memory.

  If you want to limit amount of memory available to SQL Server set the limit explicitly.

  _____________
  Code for TallyGenerator