Export SQL database details

Please follow the below steps to fetch individual database reports from SQL servers:

1. Log in to Site24x7.
   
2. Navigate to Server > Microsoft SQL Server > click on the SQL server from which you want to export data.
   
3. Go to Database, and scroll down to Database Details.
4. Across the required database, click on the Data File Size.
   
   
5. A new Attribute Report will open.
6. Click on the Share This button on the top right corner of the report.
   
   
7. 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.

Add a SQL server

• Related Articles

• I am unable to see any data for failed jobs in my database

  If you are unable to see data for failed jobs or if there is a mismatch between the failed jobs data in the SQL performance monitor and the SQL insight monitor, check if you have granted the necessary permission. Data in the SQL performance monitor: ...

• Why is the PostgreSQL individual database monitor shown as down even though that database is up in my instance?

  If your PostgreSQL individual database monitor shows as down in Site24x7 but the database is active (up) in your instance, verify that if you have given the necessary permissions for the database user to access that specific database. Refer to our ...

• APM Insight provides information on the parameters it sends to the SQL queries

  The parameters in slow SQL queries can be tracked and displayed under the traces tab. We have the option to obfuscate the values of SQL query parameters using a configuration "Obfuscate SQL Parameters". It will be enabled by default. The screenshot ...

• Unable to add SQL insight monitor

  If the SQL Insight monitor is not getting added even after entering your credentials, try these troubleshooting steps: Ensure that the Auto-discover applications feature is enabled. If not, you will need to trigger discovery using the Discover ...

• I can only see a limited amount of MySQL database monitors added. How to add new databases for monitoring?

  By default, MySQL instances will be auto-discovered and added as free monitors. MySQL data collection and monitoring will start once the agent is provided with the proper credentials. Check this article on how to add or update credentials. New ...