performance monitoring

sql2k
Howdy kids. I need to start monitoring performance on our
Production SQL box. My boss is interested in query wait
times and transactions per second mainly. The problem is
I cant figure out how to come up with that info. What do
some of you look @. for performance monitoring? We arent
having any problems but wanting to take a more proactive
approach. Where do I start? What do I monitor in either
Profiler or Perfromance Monitor? Ive always been more
from the "if it aint broke" school of thought so Im at a
real loss here? Articles/ white papers would be
especially useful.Hi Chris,
I wrote a white paper exactly on this topic. There's also a Powerpoint
presentation with audio available on the website. It's free, but you might
have to register to get it.
Check out this URL:
http://www.quest.com/content/list.asp?ContentTypeID=1&Format=table&nav=%2Fsolutions%2Fnavigation%2Exml&cat=34
There's also some really good freeware there for SQL Server users.
Spotlight for SQL Server is waaay better than any other diagnostic tool out
there.
Best regards,
-Kevin (SQL Server MVP)
"ChrisR" <anonymous@.discussions.microsoft.com> wrote in message
news:3b5501c4aa6a$b50e8720$a401280a@.phx.gbl...
> sql2k
> Howdy kids. I need to start monitoring performance on our
> Production SQL box. My boss is interested in query wait
> times and transactions per second mainly. The problem is
> I cant figure out how to come up with that info. What do
> some of you look @. for performance monitoring? We arent
> having any problems but wanting to take a more proactive
> approach. Where do I start? What do I monitor in either
> Profiler or Perfromance Monitor? Ive always been more
> from the "if it aint broke" school of thought so Im at a
> real loss here? Articles/ white papers would be
> especially useful.