I would set your database to grow in fixed sized increments and not percentage based.
-Jeff On Fri, Jan 30, 2015 at 1:36 PM, David McSpadden <[email protected]> wrote: > This morning my IVR unit ran out of SQL space even with a 10% growth > selected and having 500GB of space. > > The Autogrow function was not completeing. > > Took support 4 hours to find that it just needed to grow. > > I would like to monitor the db’s so my members are not affected by an > alert I could have gotten days ago. > > > > > > *From:* [email protected] [mailto: > [email protected]] *On Behalf Of *Frank Ress > *Sent:* Friday, January 30, 2015 1:32 PM > *To:* [email protected] > *Subject:* [NTSysADM] RE: monitoring sql db's > > > > SQL Server databases will automatically add space to their data and log > files as needed (in either fixed-size increments, or as a % of size of the > existing file, which is a configurable parameter for each file). > > > > Also, free space will be fragmented within the data file based on a number > of factors. Overall free space may not be particularly useful – it’s > possible to have even more than 10% free, and the database may need to > expand the file anyway, depending on the DML operation required. > > > > What is the goal of alerting on some kind of free space threshold? > > > > *From:* [email protected] [ > mailto:[email protected] <[email protected]>] *On > Behalf Of *David McSpadden > *Sent:* Friday, January 30, 2015 12:15 PM > *To:* '[email protected]' > *Subject:* [NTSysADM] monitoring sql db's > > > > Anyone have a good method,app, or script to alert your admins when SQL > database is below 10% free? > > This e-mail and any files transmitted with it are property of Indiana > Members Credit Union, are confidential, and are intended solely for the use > of the individual or entity to whom this e-mail is addressed. If you are > not one of the named recipient(s) or otherwise have reason to believe that > you have received this message in error, please notify the sender and > delete this message immediately from your computer. Any other use, > retention, dissemination, forwarding, printing, or copying of this email is > strictly prohibited. > > > > Please consider the environment before printing this email. > > > ------------------------------ > > > This communication is for the use of the intended recipient only. It may > contain information that is privileged and confidential. If you are not the > intended recipient of this communication, the disclosure, copying, > distribution or use hereof is prohibited. If you have received this > communication in error, please advise me by return e-mail or by telephone > and then delete it immediately. > > This e-mail and any files transmitted with it are property of Indiana > Members Credit Union, are confidential, and are intended solely for the use > of the individual or entity to whom this e-mail is addressed. If you are > not one of the named recipient(s) or otherwise have reason to believe that > you have received this message in error, please notify the sender and > delete this message immediately from your computer. Any other use, > retention, dissemination, forwarding, printing, or copying of this email is > strictly prohibited. > > Please consider the environment before printing this email. >
