2012年3月20日星期二

disconnection of web pages from SQL Server

We have SQL 2000 SP4 (Standard Edition) on Windows 2000 SP4. We have a cold
fusion application that is running against this database. We have 5 front end
(cold fusion) servers load balanced. We have a monitoring service that pings
our web application main pages (we have 2 main pages) and reports the
downtime. Once in a while the alert site reports that the site is down (tries
thru all the 5 cold fusion servers). On the DB side, I do not see any
messages for that time frame SQL server logs and or error logs. I was looking
at the stats... CPU usuage is around 55%, 8 minutes before the problem
oocured. It gradually went up and reached 65% 3 minutes before. Came
gradually came down to 25% at 1 minute after the problem. 1.6 GB memory was
available through out and number of cpu processes were constant at 45.
Are there any other ways to find out what happened (if any thing was really
wrong with SQL server) ?
Are there any other logs I could check (of course it is after the effect now)
Do you have scheduled virus scans that might be running at this time?
"RK73" wrote:

> We have SQL 2000 SP4 (Standard Edition) on Windows 2000 SP4. We have a cold
> fusion application that is running against this database. We have 5 front end
> (cold fusion) servers load balanced. We have a monitoring service that pings
> our web application main pages (we have 2 main pages) and reports the
> downtime. Once in a while the alert site reports that the site is down (tries
> thru all the 5 cold fusion servers). On the DB side, I do not see any
> messages for that time frame SQL server logs and or error logs. I was looking
> at the stats... CPU usuage is around 55%, 8 minutes before the problem
> oocured. It gradually went up and reached 65% 3 minutes before. Came
> gradually came down to 25% at 1 minute after the problem. 1.6 GB memory was
> available through out and number of cpu processes were constant at 45.
> Are there any other ways to find out what happened (if any thing was really
> wrong with SQL server) ?
> Are there any other logs I could check (of course it is after the effect now)
sql

没有评论:

发表评论