Tuesday, February 14, 2012

drill down spid for high CPU

http://www.support.microsoft.com/?id=117559
I have read something equivalent to the article above but for SQL 2K that
drills down to a particular spid while troubleshooting for high CPU usage.
I cant seem to recollect where I read it. Does anybody know ?
ThanksCheck out DBCC SQLPERF (THREADS)
Bart Simpson
On Tue, 29 Jul 2003 13:04:22 -0700, "Hassan" <fatima_ja@.hotmail.com>
wrote:
>http://www.support.microsoft.com/?id=117559
>I have read something equivalent to the article above but for SQL 2K that
>drills down to a particular spid while troubleshooting for high CPU usage.
>I cant seem to recollect where I read it. Does anybody know ?
>Thanks
>|||Well not too sure if that was it.. but more of an article in the same line
as the link I sent
"Bart Simpson" <bartsimpson000@.yahoo.com> wrote in message
news:oipdivs7otcna04mc5ct9lifk8d8huaris@.4ax.com...
> Check out DBCC SQLPERF (THREADS)
> Bart Simpson
> On Tue, 29 Jul 2003 13:04:22 -0700, "Hassan" <fatima_ja@.hotmail.com>
> wrote:
> >http://www.support.microsoft.com/?id=117559
> >
> >I have read something equivalent to the article above but for SQL 2K that
> >drills down to a particular spid while troubleshooting for high CPU
usage.
> >
> >I cant seem to recollect where I read it. Does anybody know ?
> >
> >Thanks
> >
>

No comments:

Post a Comment