Is it possible to monitor how many file growths are possible for SQL databases -- data and log files? For example, I know I can monitor the percentage of free space available on a hard drive, but I would also like a monitor that tells me how many times a data file or log file could grow based on the current growth settings in Sql Server and the current available free space of the hard drive.
We already have this covered in our SQL Server Monitoring. You can install our Windows agent in the server where the SQL server is running. After successful installation, the SQL server would be automatically discovered and mark it up for monitoring.
You will be able to find the monitor listed under the <Server name>-SQLSERVER.
As for the database metrics, follow the below steps to view them:
1. Login to Site24x7 and navigate to Server > Microsoft SQL Server
2. Click on the monitor <Server name>-SQLSERVER.
4. Navigate to the tab Database.
5. Under Database Details, you can find the 'Log File Size (GB)', 'Log Growths', 'Log File Used Size (GB)', and 'Data File Size (GB)'.
Read our documentation on what other performance metrics we provide for SQL monitoring.
Hope this fulfills your requirement. Let us know for further queries, if any.