Permissions required to view SQL counters in System Monitor

From: Shane (shane_klosowski@allianzlife.com)
Date: 09/25/02 

From: "Shane" <shane_klosowski@allianzlife.com>
Date: Wed, 25 Sep 2002 08:18:21 -0700

While attempting view Performance data in Win2K System
Monitor of the SQL servers in our enterprise, I am unable
to see the SQL performance counters, even though all other
counters are visible. I have tried applying permissions
on the various SQL server registry keys, but have had no
success. The only thing that resolves the issue is to put
my account in the local Administrators group of the
server. I did this on a small test box and was
successfully able to view the SQL counters. However, I am
not a domain or local admin on any of our production
servers, so I need to be able to view the SQL counters in
System Monitor without local or domain admin permissions.

My question, therefore, is: What are the necessary
permissions (SQL, Registry, NTFS) and Rights for a non-
Admin to view and record SQL Performance counters?

Any assistance would be appreciated.

Relevant Pages

  • Re: Permissions required to view SQL counters in System Monitor
    ... It's a permissions issue at the operating system level. ... >Monitor of the SQL servers in our enterprise, ... >to see the SQL performance counters, ... >Admin to view and record SQL Performance counters? ...
    (microsoft.public.sqlserver.security)
  • SQL Performance Counters Show 0
    ... I've recently installed SQL Server Workgroup Edition. ... SQL performance counters in Performance Monitor, ...
    (microsoft.public.sqlserver.setup)
  • Re: Performance
    ... Scale out is generally a matter of adding more ... SQL servers and distributing (usually via code but distributed partitions is ... also an option) your database and/or functions across them. ...
    (microsoft.public.dotnet.framework.performance)
  • Re: Licensing Questions
    ... Standard Edition is ... organization has an Open or Select licensing agreement with Microsoft. ... SQL servers or might have other SQL servers in the near future. ...
    (microsoft.public.sqlserver.server)
  • Wierd connection problem
    ... Having an issue connecting to one of my SQL Servers that I just cannot ... uses a remote SQL Database with no problems. ... Using the identical connection string, my ASP.Net page can connect to ...
    (microsoft.public.sqlserver)