check diskspace

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » check diskspace

13 posts, Page 2 of 2

««1 2

check diskspace

Rate Topic

Display Mode

Topic Options

Author

Message

Jeff Moden

Posted Thursday, November 08, 2012 11:07 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 9:57 PM
Points: 32,906, Visits: 26,790

SGT_squeequal (11/8/2012)

@jeff here you go, save it then rename it to .vbs Smile

Heh... I saw some CDO email in there. You're a man after my own heart. Thanks for posting the code.

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1382645

vikingDBA

Posted Friday, November 09, 2012 8:55 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 8:19 AM
Points: 189, Visits: 863

If you don't have any mount points, here is a script for using the xp_fixeddrives function. The threshold is set in the if exists line, and sends an email showing all drives with free space below the set threshold. Hope it helps someone.

CREATE TABLE #DriveSpace
(DriveLetter char(1),
MBFree int)

INSERT INTO #DriveSpace
EXEC master.dbo.xp_fixeddrives

if exists (SELECT * FROM #DriveSpace WHERE MBFree < 10000) -- value to set threshold at, in MB
BEGIN
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'SQL Server Agent Mail Profile',
@recipients = 'someone@mycompany.com',
@query = 'CREATE TABLE #DriveSpace2 (DriveLetter Char(1),MBFree int); INSERT INTO #DriveSpace2 EXEC master.dbo.xp_fixeddrives; SELECT DriveLetter, MBFree FROM #DriveSpace2; DROP TABLE #DriveSpace2' ,
@subject = '<ServerName> - Low Disk Space',
@attach_query_result_as_file = 1 ;
END
DROP TABLE #DriveSpace

Post #1383070

sqlfriends

Posted Friday, November 09, 2012 9:27 AM

SSCommitted

Group: General Forum Members
Last Login: Today @ 10:00 AM
Points: 1,605, Visits: 2,783

Thanks much, we don't have mount points. I will give it a try

Post #1383094

« Prev Topic | Next Topic »

13 posts, Page 2 of 2

««1 2

Permissions