That's very cool. From: [email protected] [mailto:[email protected]] On Behalf Of Frank Ress Sent: Friday, January 30, 2015 2:12 PM To: [email protected] Subject: [NTSysADM] RE: monitoring sql db's
Forgot to mention one of the most popular monitoring/alerting tools among the DBA crowd. It prioritizes issues, and provides background on the problem and how to go about correcting it. http://www.brentozar.com/blitz/ Also, Brent is an MVP, and a very good speaker. Of course, you'd have to be able to install the stored procedure to use this - you may need to look for zero-footprint options if Blitz or something like it isn't an option. From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of David McSpadden Sent: Friday, January 30, 2015 12:36 PM To: [email protected]<mailto:[email protected]> Subject: [NTSysADM] RE: monitoring sql db's 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]> [mailto:[email protected]] On Behalf Of Frank Ress Sent: Friday, January 30, 2015 1:32 PM To: [email protected]<mailto:[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]> [mailto:[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. ________________________________ 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.
