Export SQL database details
Please follow the below steps to fetch individual database reports from SQL servers:
- Log in to Site24x7.
- Navigate to Server > Microsoft SQL Server > click on the SQL server from which you want to export data.
- Go to Database, and scroll down to Database Details.
- Across the required database, click on the Data File Size.
- A new Attribute Report will open.
- Click on the Share This button on the top right corner of the report.
- Export your database details as CSV or PDF file, or send it as an email.
You can also set the option to auto-discover and add new databases for monitoring.
Security for SQL Server Monitoring
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. Does Site24x7 connect to the SQL Servers directly? No, Site24x7 does not connect to the SQL ...
Troubleshooting tips when there are continuous alerts for SQL performance metrics including page reads/sec, page writes/sec, page life expectancy
Page reads and writes per second denote the number of physical database page reads and writes issued respectively. Page life expectancy is the number of seconds a page will stay in the buffer pool without references. These are critical performance ...
Export my monitoring reports
You can export your monitoring reports in CSV or PDF formats, in addition to emailing the report. Log In and navigate to Reports Choose your required report Click the Share option at the right hand side of the report screen You can schedule your ...
Verifying the NetFlow port of an On-Premise Poller
For NetFlow analysis, you need to configure your devices to export flows to Site24x7 On-Premise Poller, which is the NetFlow collector. The On-Premise Poller will be listening to the particular port to receive flows, which is why a proper port number ...
FAQs related to SQL cluster monitoring
Please find below some common FAQ's related to the migration from stand alone SQL servers to SQL failover cluster: Will my SQL clusters be monitored automatically now that you have released the feature? Yes, with an upgrade to the agent's latest ...