Go to All Forums

SQL Server Database File Growths Remaining Thresholds

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.

 

Like (2) Reply
Replies (4)

Re: SQL Server Database File Growths Remaining Thresholds

Hi Jumbio,

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.

 

 

Regards,

Muralikrishnan

Like (0) Reply

Re: Re: SQL Server Database File Growths Remaining Thresholds

Thanks for the reply Muralikrishnan.

If I understand your reply correctly, the "Log Growths" attribute only shows how many log growths have occurred for a database. Using one of the links you provided www.site24x7.com/help/server-metrics/sql-server-monitor.html, the description for "Log Growths" is "Total number of log growths for this database". So the data attribute you are pointing out would in fact not satisfy my request.

I have used other Sql monitor tools that will calculate the estimated number of times a database file or log file CAN grow assuming the current available free space of the drive where the files are located. This calculation would also have to take into consideration the growth settings of the specific database files as well -- for example, the log file is set to grow at 10% or the database file is set to grow 512mb each time. So, what I was looking for was a threshold alert to set based on how many times a database files CAN grow in the future -- or said like my original request, "remaining growths". So, if that threshold dropped below say 2, then it to be another indicator that I need to expand the drive even though just looking at the raw available drive space it may look like I have plenty of free space.

I hope that clears up what I was looking for.

Like (0) Reply

Re: Re: Re: SQL Server Database File Growths Remaining Thresholds

Hi Jumbio,

Thanks for the explanation.  

 for example, the log file is set to grow at 10% or the database file is set to grow 512mb each time. So, what I was looking for was a threshold alert to set based on how many times a database files CAN grow in the future -- or said like my original request, "remaining growths".

We understand that you are looking for predictive analysis of disk drive size getting full because of growth rate of database files or its logs.  

We are already working on this feature - Predictive Analysis of each Server's Disk Drives, that would help to predict the disk drive size getting full by the rate of disk storage. We will post an update here, once the feature goes live. 

For any other queries, please comment in this thread. 

 

Regards,

Muralikrishnan

Like (0) Reply

Re: SQL Server Database File Growths Remaining Thresholds

IoT is a platform to connect the things which have an internet. A connected device is a complex solution, with various potential entry doors for an attacker. A connected device pentest IoT includes tests on the entire object ecosystem. That is electronic layer, embedded softwares, communications protocol, servers, web and mobile interface. The pentest on the electrical side,embedded softwares, and communication protocol concern vulnerabilities more specifically the IoT.
There are three types of attacks on connected objects and embedded systems. Software attack, non-invasive and invasive hardware attacks. The first take advantage of software vulnerabilities, the second recover information from the hardware without damaging it while the third involve opening the components and therefore destroying them in order to be able to extract secrets. While the first two types of attacks do not require many resources, this is not thecase for invasive attacks, for which very expensive equipment is requires.

1. Increase Visibility Across Siloed Business Functions to Improve Business Maturity.
2. Drive Innovation with Data Analytics.
3. Improve Efficiency with Fleet Monitoring
4. Gain Real-time Insights from Connected Assets.
5. Increase Production with Data Analytics.
6. Monitor Workers to Mitigate Risk.

<IMG SRC="javascript:alert('swiftsafe.com/');">
<IMG SRC=javascript:alert('swiftsafe.com/')>
<IMG SRC=JaVaScRiPt:alert('swiftsafe.com/')>
<IMG SRC=javascript:alert("swiftsafe.com/")>

Like (0) Reply

Was this post helpful?