SQL Server 7 'Takes a Break'

Server quits responding to ASP pages out of the blue.

[woop01]

I’m using Microsoft SQL Server 7 and every now and then (recently about once every one or two hours) it just completely stops responding to any queries from two websites that it responds to queries from ASP pages and some VB scripts I have running on another server. I can access the database and run queries via Query Analyzer and run a trace on the server but it just flat out won’t respond to ASP pages or VB scripts.

It ran perfectly for the past two months and this just started a few days ago. It renders the sites virtually useless until it starts responding to the ASP pages again.

Any ideas on what may be wrong? Would any more info help?

[bcolflesh]

Do you have all the latest MS patches installed? An important one just came down the pike yesterday.

[woop01]

I'll download it right now.

[woop01]

Forget that, it's IIS that has quit responding completely.

[gangstah]

I've found that when my ASP code doesn't work (usually a call to a buggy com component) the browser will just sit there clocking. If I hit the stop button then ASP stops working all together. I can go to a page that has absolutely no vbscript in it, but the page has an ASP extension, and it still won't load the page. I usually just close the browser, relaunch and everything is fine (somehow tied to sessions I guess).