Wednesday, March 7, 2012

process slowness

Hi,
can you describe some typical activities or elements of investigation I
would employ when trouble-shooting complaints of localized process slowness?
Thank you very much,
There are a ton of places to look for bottlenecks in your system. You might
start with SQL Profiler and Performance Monitor. That's about all I could
tell you without knowing any specifics about your situation...
"ManuTop" <ManuTop@.discussions.microsoft.com> wrote in message
news:C2434E0A-E709-44BE-92D2-ED498F8AF721@.microsoft.com...
> Hi,
> can you describe some typical activities or elements of investigation I
> would employ when trouble-shooting complaints of localized process
> slowness?
> Thank you very much,
|||not really...
but here is where you'd go to start
www.sql-server-performance.com
Usually, most problems lead to 4 usual suspects: CPU, RAM, IO, Poor DB
Design
look at perfmon counters for CPU, RAM and DISK IO to see what is tanking
then go from there.
Greg Jackson
Portland, OR

No comments:

Post a Comment