SQL 2000 gets overloaded

Results 1 to 2 of 2

Thread: SQL 2000 gets overloaded

  1. #1
    Join Date
    Dec 1969

    Default SQL 2000 gets overloaded

    Hi,<BR><BR>For some reason my SQL server gets overloaded (uses 250Mb+ of RAM)after about 2-3 days when it&#039;s started. After I restart it - it all goes back to normal. What gives? Should not it be killing all its queries automatically after like 20 min? How can I kill those queries after 1 min? Or maybe it is something else? <BR><BR>Please help!<BR><BR>Regards,<BR>Alex<BR>DomainsBot.Com

  2. #2
    Join Date
    Dec 1969

    Default check your pages...

    ...you probably aren&#039;t explicitly destroying recordset and connection object connections as well as the objects themselves.<BR><BR>If you don&#039;t clean up the garbage, noone else will (including SQL Server).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts