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

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

dyn98007 — Tue, 05 Nov 2024 22:10:34 GMT

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!

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

MostafaHussein — Wed, 06 Nov 2024 11:01:50 GMT

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.

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

dyn98007 — Wed, 06 Nov 2024 21:14:55 GMT

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?

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

MostafaHussein — Wed, 06 Nov 2024 22:50:30 GMT

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.