polling for endpoint xyz.tech:2020 query have failed - Monitoring a MSSQL DB cluster using Extension 2.0

[dyn98007]

Hello:

This is related to com.dynatrace.extension.sql-server ...

Facing below Warning messages in the Logs...The endpoint in the message is a SQL Server cluster endpoint.

------------------

While polling for endpoint xyz.integration.system.tech:2020 query have failed: always_on_availability_groups, always_on_availability_replicas, always_on_availability_databases, instance_process_cpu, instance_performance_cache_hit_ratio, instance_process_memory, instance_performance_queries, instance_performance_latches, instance_performance_locks, instance_performance_general, instance_performance_memory, instance_performance_replica, database_log_managed, database_transactions_azure, database_log_azure, database_transactions_managed

------------------------------------

Can I know how this can be resolved, since it is causing "No data available" in the Dashboard?.

Thank  you!

[MostafaHussein]

there's many things still missed within the context as the following:

- did you tested the connectivity outside the extension?

- what's the user permissions that are set ?

- what's the extension type v1 or v2, Activegate extension or OneAgent extension?

- what's the extension link or the extension name? 

BR,
Mostafa Hussein.

[dyn98007]

Hi @MostafaHussein 

Extension name: com.dynatrace.extension.sql-server ( hub/ext/com.dynatrace.extension.sql-server)

ActiveGate Extension 2.0

Regarding user permissions , Is there a Dynatrace documentation around the permissions required for a Database user of a MSSQL Cluster?

[MostafaHussein · Accepted solution]

Regarding user permissions, yes there's specific tables/views permissions is needed as the below list

• sys.dm_os_sys_info
• sys.dm_os_performance_counters
• sys.dm_exec_sessions
• sys.databases
• sys.query_store_runtime_stats
• sys.query_store_plan
• sys.query_store_query
• sys.query_store_query_text
• msdb.dbo.backupset
• msdb.dbo.backupmediafamily
• msdb.dbo.backupmediaset
• msdb.dbo.backupfile
• msdb.dbo.sysjobs
• msdb.dbo.sysjobsteps
• msdb.dbo.sysjobhistory
• msdb.dbo.sysjobservers
• msdb.dbo.sysjobactivity
• msdb.dbo.systargetservers
• sys.master_files
• sys.db_database_backups
• sys.database_files
• sys.availability_groups
• sys.availability_replicas
• sys.availability_databases_cluster
• sys.dm_hadr_availability_group_states
• sys.dm_hadr_availability_replica_states
• sys.dm_hadr_database_replica_states

also check this link for more details about needed permissions based on versions https://www.dynatrace.com/hub/detail/microsoft-sql-server-2/

BR,
Mostafa Hussein.