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 04, 2010 9:33 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 31, 2014 12:23 PM
Points: 8, Visits: 215
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 04, 2010 9:37 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 9:08 AM
Points: 1,231, Visits: 717
Probably not, since I don't have a setup like that that I can test with. Sorry!
Post #997651
Posted Monday, October 04, 2010 9:49 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, April 01, 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 04, 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 @ 6:50 PM
Points: 20,455, Visits: 14,074
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 04, 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 04, 2010 7:38 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 9:08 AM
Points: 1,231, Visits: 717
Glad to help!
Post #998024
Posted Tuesday, October 05, 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 06, 2010 3:22 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 05, 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 06, 2010 5:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

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

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

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 8:40 AM
Points: 29, Visits: 501
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