How can I get my sql dba's to access sql counters in performance monitor
without making them computer administrators? Q158438 has aided them in
busting them into all the standard counters, but still, only my computer
administrator account seems to be able to find the sql counters?hmm... didn't know about that KB. Interesting...
In the past I've told DBA's they can look at SQL specific counters by
reading master..sysperfinfo directly. That's where PerfMon grabs all it's
SQL data from...
you could always query the table directly...
--
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Robert Hindla" <rhindla@.panix.com> wrote in message
news:BB31AFED.5B2B%rhindla@.panix.com...
> How can I get my sql dba's to access sql counters in performance monitor
> without making them computer administrators? Q158438 has aided them in
> busting them into all the standard counters, but still, only my computer
> administrator account seems to be able to find the sql counters?
>
Friday, March 9, 2012
Remote non-administrator monitoring of sql stats
Labels:
access,
administrators,
aided,
computer,
counters,
database,
dba,
microsoft,
monitor,
monitoring,
mysql,
non-administrator,
oracle,
performance,
q158438,
remote,
server,
sql,
stats
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment