View Single Post
  #5  
Old 25th October 2005, 01:27
Darren Phillips's Avatar
Darren Phillips Darren Phillips is offline
Guru
 
Join Date: Aug 2001
Location: west wales, UK
Posts: 334
Darren Phillips is on a distinguished road
Baan: IV4c4 SCH1 SP14 /AGS2 - DB: SQL7/sql2000/Oracle 9 - OS: NT4 Enterprise / win2000/3
in enterprise manager there is an option to either allow sql to use the memory in dynamic mode or allocate a specific amount of memory to sql. I found on SQL7 that if it was in dynamic mode the server would lock up after about 3 weeks. once allocated the memory the problem went away.
Reply With Quote