Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««12345»»»

Drive Space Monitoring Gets An Update Expand / Collapse
Author
Message
Posted Monday, October 4, 2010 9:33 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 30, 2014 9:52 AM
Points: 8, Visits: 227
We had to roll our own solution since we are using windows mountpoints for mapping new SAN luns into our clusters. Any chance you will be adressing that issue?
Post #997643
Posted Monday, October 4, 2010 9:37 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, July 14, 2014 7:57 AM
Points: 1,321, Visits: 729
Probably not, since I don't have a setup like that that I can test with. Sorry!
Post #997651
Posted Monday, October 4, 2010 9:49 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, April 1, 2011 2:17 AM
Points: 28, Visits: 44
Mat Raftree (10/4/2010)
We had to roll our own solution since we are using windows mountpoints for mapping new SAN luns into our clusters. Any chance you will be adressing that issue?


It can be done in Powershell using the "win32_mountpoint" class... I've been experimenting with it myself as I have the exact same problem.
Post #997660
Posted Monday, October 4, 2010 12:36 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 9:17 PM
Points: 21,211, Visits: 14,908
Thanks for the article.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #997781
Posted Monday, October 4, 2010 5:58 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 29, 2013 8:34 PM
Points: 110, Visits: 120
Though, I did not test it yet on my environment right now but I'm very thankful and very grateful to Shaun for having this kind of article... Thanks a lot Shaun!!!!
Post #997988
Posted Monday, October 4, 2010 7:38 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, July 14, 2014 7:57 AM
Points: 1,321, Visits: 729
Glad to help!
Post #998024
Posted Tuesday, October 5, 2010 3:16 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, April 27, 2011 1:18 PM
Points: 13, Visits: 99
Still can't get the files. Anyone else have any luck ?

Oops ! my bad... I have it working now...

ThanX for the great script


AmcAmx
Post #998791
Posted Wednesday, October 6, 2010 3:22 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 5, 2012 3:17 AM
Points: 2, Visits: 14
It works fine for usual drives with a drive-letter

As soon as a disk has been mounted as a subfolder in a existing drive and the databases are within the mounted drive....it doesn't work.

Regards,
Dominic
Post #999078
Posted Wednesday, October 6, 2010 5:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 5, 2012 3:17 AM
Points: 2, Visits: 14
DAMM!!!....sorry guys....I saw now the similar posts :-S

Post #999122
Posted Wednesday, October 6, 2010 7:54 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, July 18, 2014 2:40 AM
Points: 29, Visits: 523
Great article and scripts. I'm in the process of trying them out now. Just a small issue. Please remember the square brackets [] in your dynamic SQL either side of the servername. That way server instances will get taken care of also.

Post #999321
« Prev Topic | Next Topic »

Add to briefcase «««12345»»»

Permissions Expand / Collapse