Retrieving CPU usage,

Hi,
For some reason, my SQL server is sometimes processing 99% cpu.
But on the SQL server is no activity from users or jobs running.
Can someone help me with an TSQL script to retrieve CPU usage at that
moment.
Regards,
ReneHi
I am not sure what/why you want this if you already know it is 99%!!!! You
may want to check out @.@.CPU_BUSY or the topic "Monitoring CPU Usage" in
books online.
You may also want to look at the DTSDiag program that is available with Ken
Hendersons boook "The Guru's Guide to SQL Server Architecture and Internals"
ISBN 0-201-70047-6
High CPU usuage is not necessarily a problem if it is not sustained. Reasons
for more sustained usage could be a bottleneck elsewhere or possibly
something like the Slammer worm.
John
"news.microsoft.com" <RJDev2002@.hotmail.com> wrote in message
news:%23tD9XFMREHA.3420@.TK2MSFTNGP11.phx.gbl...
> Hi,
> For some reason, my SQL server is sometimes processing 99% cpu.
> But on the SQL server is no activity from users or jobs running.
> Can someone help me with an TSQL script to retrieve CPU usage at that
> moment.
> Regards,
> Rene
>|||As John says, if you are not running SP3, you are probably seeing the
slammer worm..
Otherwise I would use Perfmon to monitor CPU usage.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"news.microsoft.com" <RJDev2002@.hotmail.com> wrote in message
news:%23tD9XFMREHA.3420@.TK2MSFTNGP11.phx.gbl...
> Hi,
> For some reason, my SQL server is sometimes processing 99% cpu.
> But on the SQL server is no activity from users or jobs running.
> Can someone help me with an TSQL script to retrieve CPU usage at that
> moment.
> Regards,
> Rene
>