microsoft.public.sqlserver.server

Author

sp_monitor

Wilson

2002-08-14, 3:23 am

Hi all

if my server has 4 cpu, what will sp_monitor display if all 4 CPU are 100%
used?
100% OR 400%?

thanks in advance

Wilson

Dan Holt [MS]

2002-08-14, 7:23 pm

Hi Wilson,

sp_monitor will show up to 400% if you have 4 cpus and they are each 100%
busy in SQL Server.

HTH.

--
Dan Holt
Please do not send email directly to this alias. This alias is for
newsgroup purposes only.
This posting is provided "AS IS" with no warranties, and confers no rights.

"Wilson" <wilsontc@singnet.com.sg> wrote in message
news:O3M7cx2QCHA.1452@tkmsftngp10...
> Hi all
>
> if my server has 4 cpu, what will sp_monitor display if all 4 CPU are
100%
> used?
> 100% OR 400%?
>
> thanks in advance
>
> Wilson
>
>

Sponsored Links