Guys,

After much of testing and reconfiguring the server and database, it is now showing signs of stability. I think the problem was caused by screwed up indexing.

Had to restarted the server the morning after it decided to have one of its funny turns, but the time, it stopped in the middle of a trace which I...

Just the standard line W2K put in during installation.

[boot loader]

timeout=30

default=multi(0)disk(0)rdisk(0)partition(2)\WINNT

[operating systems]

multi(0)disk(0)rdisk(0)partition(2)\WINNT="Microsoft Windows 2000 Server" /fastdetect

The thing stopped again, we have narrowed it down to the database rather than the server...

Links where you can find the memory limitation of 2Gb on SQL2K standard edition.

http://www.mssqlcity.com/FAQ/General/sql_server_2000_editions.htm

http://www.2000trainers.com/article.aspx?articleID=44&page=2

http://www.dbforums.com/archive/index.php/t-941740.html (This one was quoted by SQL Server MVP, so it must be true).

The problem...

I looked at the ASP code, to my horror, most connections were not being destroyed and some of them were not closed after the page has been processed. So I...

Thank you for your reply.

The server has currently got 4Gb RAM, I have tried setting the memory to fixed starting with 0 min to 1536 max. Reason for 1536 is...