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

    • Related Articles

    • Troubleshooting false positive alerts in monitoring

      Problem False positive alerts are being generated. Possible cause The monitoring system is down in some locations. The Website monitor might be configured for one location, such as Seattle, but may appear down when accessed from another location, ...
    • Troubleshooting steps when no data is received from the SQL server

      As we use "Perfmon" to fetch data for Microsoft SQL monitoring, please check if the counters related to SQL are present in the user's perfmon. Please follow the steps below: Open the server machine in which the issue is occurring. Start -> Run and ...
    • Executables and scripts to allow for Windows server monitoring

      One of the reasons you could not enable Site24x7 server monitoring could be your organization's group policy denying access to the executables, scripts, and batch files associated with Site24x7 server monitoring. Mark the following executables, ...
    • Exclude the selective SSH algorithms in On-Premise Poller during SFTP Transfer monitoring

      By excluding SSH algorithms, you can restrict Site24x7 SSH Client from using the excluded algorithm while connecting to the SSH server during SFTP Transfer monitoring. Follow the steps mentioned below for SSH algorithm exclusion in On-Premise Poller ...
    • Response time in Website monitoring

      In website monitoring, response time is calculated as the total time taken to resolve the DNS, complete the TCP hand-shake, negotiate an SSL handshake (for HTTPS) and download the full HTML output from the server. However, it does not include getting ...