automatically notify when running on low harddisk space

Question

Post reply

automatically notify when running on low harddisk space

Ferry Huang

Old Hand

Points: 365
More actions
February 15, 2006 at 3:15 am

#111657

How to do this?
Regards,
Huang, Ferry
Regards,
Ferry Huang

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

Johan Bijnens SSC Guru Points: 135375 More actions · Answer 1

if you want to do this using SQLServer you can use xp_fixeddrives to see how much space is left on each (local) drive.

Create table #tmpDrives (Drive char(1), MBFree int)

insert into #tmpDrives

exec xp_fixeddrives

select *

from #tmpDrives

where MBFree < 1000 -- e.g.

xp_sendmail ??

or smtpmail ... check out Gert Drapers site (SQLDev.Net)for the dll

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 2

You can also set an alert on a performance counter. In this case, the disk space on a particular drive.

Ferry Huang Old Hand Points: 365 More actions · Answer 3

to alzdba:

sorry, but i want the server alert me automatically, not using t-sql.

to steve:

maybe this is what i want, how to do this? is this using alerts from sql server agent?

Regards,

Ferry Huang

barsuk SSChampion Points: 12280 More actions · Answer 4

in short: you can create a job where going to place above code and run it, say, every hour. If you do this on a regular basis you may want to store your data in a perm table instead of temp table...

barsuk SSChampion Points: 12280 More actions · Answer 5

forgot to mention: encorporate your code in the Stored Proc where the last line of code you can execute your xp_sendmail ...

Ferry Huang Old Hand Points: 365 More actions · Answer 6

sorry barsuk, but i am really new in this. can you guide me how to do that step by step? i'm using enterprise manager here. also i had heard to enable sql server to send a message to an operator, we must set up a MAPI mail account for it, how to do this? please give me a guide.

Regards,

Ferry Huang

barsuk SSChampion Points: 12280 More actions · Answer 7

Did you check BOL?

check some of those links:

http://support.microsoft.com/kb/315886/

http://support.microsoft.com/?id=263556

http://msdn2.microsoft.com/en-us/library(d=robot)/ms189505.aspx

http://msdn2.microsoft.com/en-us/library(d=robot)/ms175189.aspx

Ferry Huang Old Hand Points: 365 More actions · Answer 8

hi, barsuk, i already check the link you give to me. BTW what is BOL?

i already set the sql mail and sql agent mail, what should i do next?

Steve Jones wrote:

You can also set an alert on a performance counter. In this case, the disk space on a particular drive.

what is "performance counter"? and how to set alert no a performance counter?

thanks in advance.

Regards,

Ferry Huang

Ferry Huang Old Hand Points: 365 More actions · Answer 9

hello guys, ...

sorry if i'm asking to much, but i really new in this, and i need your help.

Regards,

Ferry Huang

runaldo SSCommitted Points: 1682 More actions · Answer 10

BOL - Books Online (SQL Server Helpfile)

Performance Counter - Open Administrative Tools on your server and clik Performance. Check out the different counters that are there.

Ferry Huang Old Hand Points: 365 More actions · Answer 11

Oooo, i see

Thanks runaldo.

But i still need a guide for my problem? where is alzdba, steve, and barsuk?

Regards,

Ferry Huang

Johan Bijnens SSC Guru Points: 135375 More actions · Answer 12

we us HP ovow to monitor the physical disks, not the sqlserver infrastructure.

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

cross DBA Old Hand Points: 319 More actions · Answer 13

The obvious answer to this is 'RTFM' (Read The Manual).

BOL = 'Books on Line' also known as 'Help' (click the little button at top right of any Windows screen - clue: it has the word 'Help' written on it.