Monday, March 26, 2012

How to track SQL server and file growth

HI, Forgive me as I try to work through my thoughts here. I am looking for
some help in creating a script that will gather drive data from 3 SQL
servers and record that to a SQL database. The data to be recorded was
originally just (DriveLetter, Size, SpaceUsed, SpaceAvailable). Now it
includes (FileNames, and Sizes) of MDF and LDF files in specific folders. I
started this yesterday and have a VBS script that pulls the original data
and saves it to a CSV file, then I created a VBA macro in an XLS file which
pulls that data in to a spreadsheet and assigns each servers data to a
different tab. But this requires a VBS file on each server and each VBS
file creates their own CSV file (on a central server where the XLS file is
located).. Anyway I would like to change what I have already done so that
there a fewer pieces, more data, and it is saved to an MDF. Can someone
help with this?I don't know how you built VBS file since you have not shown us the source
so , take a look at
http://www.sql-server-performance.c...with_dts_05.asp
"WANNABE" <breichenbach AT istate DOT com> wrote in message
news:e2d66s$2GHA.1292@.TK2MSFTNGP03.phx.gbl...
> HI, Forgive me as I try to work through my thoughts here. I am looking
> for some help in creating a script that will gather drive data from 3 SQL
> servers and record that to a SQL database. The data to be recorded was
> originally just (DriveLetter, Size, SpaceUsed, SpaceAvailable). Now it
> includes (FileNames, and Sizes) of MDF and LDF files in specific folders.
> I started this yesterday and have a VBS script that pulls the original
> data and saves it to a CSV file, then I created a VBA macro in an XLS file
> which pulls that data in to a spreadsheet and assigns each servers data to
> a different tab. But this requires a VBS file on each server and each VBS
> file creates their own CSV file (on a central server where the XLS file is
> located).. Anyway I would like to change what I have already done so that
> there a fewer pieces, more data, and it is saved to an MDF. Can someone
> help with this?
>|||Thanks!!!, that looks like it just what I need. May need a little tweaking,
but so far so good..
Thanks again
======================================
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23piXMw$2GHA.1068@.TK2MSFTNGP05.phx.gbl...
>I don't know how you built VBS file since you have not shown us the source
>so , take a look at
> http://www.sql-server-performance.c...with_dts_05.asp
>
> "WANNABE" <breichenbach AT istate DOT com> wrote in message
> news:e2d66s$2GHA.1292@.TK2MSFTNGP03.phx.gbl...
>

No comments:

Post a Comment