cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

MS SQL Server Extension: Status OK but no Data

TahirJanwari
Observer

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.

4 REPLIES 4

AntonPineiro
DynaMight Guru
DynaMight Guru

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

❤️ Emacs ❤️ Vim ❤️ Bash ❤️ Perl

jlgervais
Newcomer

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 ...

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/

Mike

TahirJanwari
Observer

Featured Posts