Hi,



I'm runing certain queries on my Query Analzer. Whenever I run it, the CPU

usage shot up to 100%. What does it means? What does it indicates? What

should be done on hardware or software to optimize this usage or to avoid

this 100% usage?



In case the 100% CPU usage last for 15secs, I guess that other users will

not be able to fetch data or save data to database during that period of

time. The user request would be queued in the SQL server and wait for

transaction. If the waiting time is longer than the IIS server time out

setting, a server time out error will be displayed on the web page. Am I

right?



Thanks

William

Hi William,



This is in all likelihood normal...it would appear that your server doesn't

have a whole heck of a lot of concurrent processing going on simultaneously,

so when a task is run, the CPU dedicates all available resources to work on

it to get it done in the fastest time possible.  If your server was doing

1,000 different things at the same time, the aggregate processor cycle usage

might be a bit different.



HTH,

Jason



----- Original Message -----

From: <william.sze@s...>

To: "ASP Web HowTo" <asp_web_howto@p...>

Sent: Friday, February 01, 2002 6:37 AM

Subject: [asp_web_howto] SQL 2K Server CPU Usage





>

> Hi,

>

> I'm runing certain queries on my Query Analzer. Whenever I run it, the CPU

> usage shot up to 100%. What does it means? What does it indicates? What

> should be done on hardware or software to optimize this usage or to avoid

> this 100% usage?

>

> In case the 100% CPU usage last for 15secs, I guess that other users will

> not be able to fetch data or save data to database during that period of

> time. The user request would be queued in the SQL server and wait for

> transaction. If the waiting time is longer than the IIS server time out

> setting, a server time out error will be displayed on the web page. Am I

> right?

>

> Thanks

> William

>

>




$subst('Email.Unsub').

>