SQL Permissions for Monitoring Microsoft SQL Server using Metricbeat

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?

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

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