How to find out CPU utilization for individual sql processes?

Sometimes is my CPU utilization is about 90-100%. SQL server cause this high
utilization.
Is it possible to find out which process (task or query) in SQL server is
responsible for thist CPU utilization?
Alesmy SQL server is 2000
"Ales Baranek" <baranek@.extranet.cz> wrote in message
news:ev4dEsnWEHA.384@.TK2MSFTNGP10.phx.gbl...
> Sometimes is my CPU utilization is about 90-100%. SQL server cause this
high
> utilization.
> Is it possible to find out which process (task or query) in SQL server is
> responsible for thist CPU utilization?
> Ales
>|||Hi,
You can get the CPU time not CPU usage. But using below query you can get
the SQL process using high cpu time.
select spid,cpu from sysprocesses order by cpu desc
--
Thanks
Hari
MCDBA
"Ales Baranek" <baranek@.extranet.cz> wrote in message
news:#tHRj#nWEHA.3528@.TK2MSFTNGP10.phx.gbl...
> my SQL server is 2000
> "Ales Baranek" <baranek@.extranet.cz> wrote in message
> news:ev4dEsnWEHA.384@.TK2MSFTNGP10.phx.gbl...
> > Sometimes is my CPU utilization is about 90-100%. SQL server cause this
> high
> > utilization.
> > Is it possible to find out which process (task or query) in SQL server
is
> > responsible for thist CPU utilization?
> >
> > Ales
> >
> >
>|||You could run sp_who2 quickly twice, and look at the CPUTime column to see
which connection has the biggest increase. From there, you can then
retrieve the query either using DBCC INPUTBUFFER (pre-sp3) or the
::fn_get_sql function (sp3).
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
"Ales Baranek" <baranek@.extranet.cz> wrote in message
news:ev4dEsnWEHA.384@.TK2MSFTNGP10.phx.gbl...
> Sometimes is my CPU utilization is about 90-100%. SQL server cause this
high
> utilization.
> Is it possible to find out which process (task or query) in SQL server is
> responsible for thist CPU utilization?
> Ales
>

How to find out CPU utilization for individual sql processes?

Sometimes is my CPU utilization is about 90-100%. SQL server cause this high
utilization.
Is it possible to find out which process (task or query) in SQL server is
responsible for thist CPU utilization?
Ales
my SQL server is 2000
"Ales Baranek" <baranek@.extranet.cz> wrote in message
news:ev4dEsnWEHA.384@.TK2MSFTNGP10.phx.gbl...
> Sometimes is my CPU utilization is about 90-100%. SQL server cause this
high
> utilization.
> Is it possible to find out which process (task or query) in SQL server is
> responsible for thist CPU utilization?
> Ales
>
|||Hi,
You can get the CPU time not CPU usage. But using below query you can get
the SQL process using high cpu time.
select spid,cpu from sysprocesses order by cpu desc
Thanks
Hari
MCDBA
"Ales Baranek" <baranek@.extranet.cz> wrote in message
news:#tHRj#nWEHA.3528@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> my SQL server is 2000
> "Ales Baranek" <baranek@.extranet.cz> wrote in message
> news:ev4dEsnWEHA.384@.TK2MSFTNGP10.phx.gbl...
> high
is
>
|||You could run sp_who2 quickly twice, and look at the CPUTime column to see
which connection has the biggest increase. From there, you can then
retrieve the query either using DBCC INPUTBUFFER (pre-sp3) or the
::fn_get_sql function (sp3).
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
"Ales Baranek" <baranek@.extranet.cz> wrote in message
news:ev4dEsnWEHA.384@.TK2MSFTNGP10.phx.gbl...
> Sometimes is my CPU utilization is about 90-100%. SQL server cause this
high
> utilization.
> Is it possible to find out which process (task or query) in SQL server is
> responsible for thist CPU utilization?
> Ales
>

How to find out CPU utilization for individual sql processes?

Sometimes is my CPU utilization is about 90-100%. SQL server cause this high
utilization.
Is it possible to find out which process (task or query) in SQL server is
responsible for thist CPU utilization?
Alesmy SQL server is 2000
"Ales Baranek" <baranek@.extranet.cz> wrote in message
news:ev4dEsnWEHA.384@.TK2MSFTNGP10.phx.gbl...
> Sometimes is my CPU utilization is about 90-100%. SQL server cause this
high
> utilization.
> Is it possible to find out which process (task or query) in SQL server is
> responsible for thist CPU utilization?
> Ales
>|||Hi,
You can get the CPU time not CPU usage. But using below query you can get
the SQL process using high cpu time.
select spid,cpu from sysprocesses order by cpu desc
Thanks
Hari
MCDBA
"Ales Baranek" <baranek@.extranet.cz> wrote in message
news:#tHRj#nWEHA.3528@.TK2MSFTNGP10.phx.gbl...
> my SQL server is 2000
> "Ales Baranek" <baranek@.extranet.cz> wrote in message
> news:ev4dEsnWEHA.384@.TK2MSFTNGP10.phx.gbl...
> high
is[vbcol=seagreen]
>|||You could run sp_who2 quickly twice, and look at the CPUTime column to see
which connection has the biggest increase. From there, you can then
retrieve the query either using DBCC INPUTBUFFER (pre-sp3) or the
::fn_get_sql function (sp3).
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
"Ales Baranek" <baranek@.extranet.cz> wrote in message
news:ev4dEsnWEHA.384@.TK2MSFTNGP10.phx.gbl...
> Sometimes is my CPU utilization is about 90-100%. SQL server cause this
high
> utilization.
> Is it possible to find out which process (task or query) in SQL server is
> responsible for thist CPU utilization?
> Ales
>