Security for SQL Server Monitoring

Security for SQL Server Monitoring

  1. Do I have to provide my SQL Server credentials for Site24x7 to monitor them?
    No, Site24x7 does not ask for your SQL Server credentials for monitoring.
  2. Does Site24x7 connect to the SQL Servers directly?
    No, Site24x7 does not connect to the SQL Servers. 
  3. Do you use T-SQL query?
    No T-SQL query is used to fetch data.
  4. Do you have access to SQL queries, tables, and all database related data?
    No, Site24x7 does not have access to SQL queries, tables, rows, columns or any other information in your SQL database.
  5. How do you collect performance metrics for SQL monitoring?
    Performance metrics is collected via perfmon counters.
  6. How are the SQL cluster related performance data collected by Site24x7?
    SQL cluster related performance metrics like cluster name and owner node is collected using the following PowerShell cmdlet:
    Get-ClusterResource
  7. What performance data is collected by Site24x7 for monitoring SQL Servers?
    Data for the performance metrics listed in this document are collected by Site24x7 for monitoring SQL Servers.
  8. What logs are collected for SQL Server monitoring?
    SQL Server logs and SQL agent logs are collected for SQL monitoring.
    Note: This is applicable only when AppLogs is enabled.

Related Articles
  1. Windows agent security
  2. Add SQL Server monitor
  3. Performance metrics for SQL Server monitoring