SiteScope SQL Service Counters Retrieval
Iam unable to retrieve the SQL Service Counters using sitescope. I have configured the SQL Server, able to retrieve other counters from the server like CPU, Memory but unable to retrieve the SQL Service Counters.
The version of the Sitescope used is 126.96.36.199.
I verified by starting the perfmon in the SQl Server and able to see the counters related to SQL Service Counters The counters are enabled and available on the SQL Server. I have admin access and able to run the perfmon on the SQL Server. The details are entered in the Sitescope preferences while configuring the SQL Server and i have enabled trace to test and the counters are visible, but when i try to set-up and try to retrieve the counters apart from CPU, Memory, System, Disk iam able to do, but SQL Service counters iam not able to retrieve and bot able to view them in the dorp down.
Kindly let me know if anyone faced such issues and the steps to resolve in retrieving the SQL Service Counters.
Re: SiteScope SQL Service Counters Retrieval
I checked configuring another SQL Server and able to retrieve the SQL Service Counters. I also compared the services associated with 2 sql servers and they are same.