Monday, March 19, 2012

Monitoring Server Memory.

Hi, we need to monitor the memory used for sql server. The person who
want to use de counters has administrative privileges on the server but
not in sql server, so he couldnt use the sql server counters in
Performance Monitor Tool.
I am member of the sysadmin server role in sql server and I can use the
counters, So, Do somebody know if the user can have some privileges
differente to sysadmin on sql server to use the counters'
Thanks a lot for your help!
*** Sent via Developersdex http://www.codecomments.com ***Hi,
User with Admin rights on the Server (operating system) should be able to
see all the counters.
FYI, OS Administrators by default will the member of BUILD\ADMIN user in sql
server. BUILD\ADMIN is the part of sysadmin role
Thanks
Hari
SQL Server MVP
"MariaGuzman" <marisa@.devdex.com> wrote in message
news:Oj6VaHHQFHA.4020@.tk2msftngp13.phx.gbl...
> Hi, we need to monitor the memory used for sql server. The person who
> want to use de counters has administrative privileges on the server but
> not in sql server, so he couldnt use the sql server counters in
> Performance Monitor Tool.
> I am member of the sysadmin server role in sql server and I can use the
> counters, So, Do somebody know if the user can have some privileges
> differente to sysadmin on sql server to use the counters'
> Thanks a lot for your help!
>
>
> *** Sent via Developersdex http://www.codecomments.com ***|||Thanks for your answere. I forgot to tell you that the
builtin\administrator is not a member of the sysadmin role on this
server.
*** Sent via Developersdex http://www.codecomments.com ***

No comments:

Post a Comment