13 Dec 2024 06:06 AM
Hi Everyone,
We’re currently facing an issue with an MSSQL Extension that is critical to our setup, and I’m hoping someone in the community can provide some insights or guidance.
We’ve recently configured the MSSQL Extension, and everything seems to be in place. The configuration checks out, and the status is displayed as "OK." However, we are not seeing any data being collected.
When we looked into the logs, we noticed the following entries:
1. Polling Failure:
- While polling for endpoint `***********:1447`, the query failed for multiple metrics, including:
`always_on_availability_groups, always_on_availability_replicas, always_on_availability_databases, instance_performance_cache_hit_ratio, instance_process_memory, instance_performance_latches, instance_performance_queries, instance_performance_locks, instance_process_cpu, instance_performance_general, instance_performance_memory, instance_performance_replica, database_transactions_azure, database_log_managed, database_log_azure, database_transactions_managed`.
2. No Events Generated:
- For the same endpoint, the group `'largest_files_azure'` did not produce any events.
We’ve seen similar patterns across other logs as well, but we haven’t been able to identify the root cause.
If anyone has faced a similar issue or has insights into what might be causing this, please share your thoughts!
Thanks in advance for your help.
13 Dec 2024 08:46 AM
Hi,
Which version SQL are you using?
Looks like maybe user created in database is missing some privileges, maybe, not sure 100%.
Let wait another answers.
Best regards
23 Dec 2024 03:36 PM - edited 23 Dec 2024 03:58 PM
Having the same issue
I've Created my SQL User with basically no rights (public only), since the required rights are not specified when you create your configuration
I get the Databases list, but nothing else
So I've GRANT VIEW SERVER STATE TO MyDynatraceUser and started to get a few metrics
I now have to figure if other rights are needed to get logins, statistics, locks, latches ...
23 Dec 2024 03:53 PM
Hi,
The required access is under “permissions” on the hub tile, both in product and the public one: https://www.dynatrace.com/hub/detail/microsoft-sql-server-2/
23 Dec 2024 03:58 PM
@jlgervais you can find permission needed for user in this community post: