| Author |
Topic |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2008-05-06 : 14:18:54
|
| Is there an alert for physical memory in SQL2K5? My requirement is - I should get an alert when the free space on a particular drive comes below a threshhold.------------------------I think, therefore I am - Rene Descartes |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-06 : 14:21:28
|
| You can do this in Performance Monitor.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-05-06 : 14:29:06
|
Which is it?Physical memory, free space or both?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-05-06 : 14:30:51
|
| free space------------------------I think, therefore I am - Rene Descartes |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-06 : 14:33:41
|
| http://weblogs.sqlteam.com/tarad/archive/2007/12/18/60435.aspxTara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-05-06 : 14:45:03
|
| Thanks Tara. How about - Execute master..xp_fixeddrives ? Can we leverage this xp?------------------------I think, therefore I am - Rene Descartes |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-06 : 14:45:56
|
| Yes but it won't work on mount points, hence my article.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-05-06 : 14:54:22
|
| Unfortunately I don’t know about mount points! I have a strong feeling that we don’t have them in our prod environment. Here is what I am planning to do (till we get the mount point)1. execute fixeddrives and store the results in a table2. check for the threshhold 3. put the whole thing in a job4. configure mail for job failure 5. If the threshhold is met, do a simple – select * from non_existant_table – job will fail, and I will get a mail. This may be stupid approach. But I have a feeling it will work ;-)------------------------I think, therefore I am - Rene Descartes |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-06 : 15:01:07
|
| I don't know why you'd want a job to be in a failure state for this condition. Just send an email when the threshold exists but have the job be successful.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-05-06 : 15:05:23
|
| Yes you are right! I was just trying to avoid the mail code ;-)------------------------I think, therefore I am - Rene Descartes |
|
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2008-05-06 : 15:15:29
|
| How often will this job run? Let's say it runs once a day at 11pm to check the drivespace. What if there is a run away process that fills up the drive(s) in 3hrs at say 10am? You would still be toast. You'd need your job running about once a minute in order for it to find such issues. |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-05-06 : 15:24:30
|
| This is not a regular thing, space crunch may happen once in a while. Also I will keep a large treshhold (e.g. say 5GB). I may run the job every hour or every 3 hours.------------------------I think, therefore I am - Rene Descartes |
|
|
|
|
Alert for Physical memory