SQL Permissions for Monitoring Microsoft SQL Server using Metricbeat

Elastic Stack Beats
1

I am looking to implement monitoring Microsoft SQL Server using Metricbeat. What are the minimum SQL user permissions needed for performance and transaction log metric sets?

2

You need to be able to access the following tables:

  • sys.dm_db_log_space_usage
  • sys.dm_db_log_stats([id])
  • sys.databases
  • sys.dm_os_performance_counters
3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.