adding a filegroup

when you add a filegroup to a existing server on a half full harddrive
does it take longer to add if the file group size is very large likje
over 100 gigs
*** Sent via Developersdex http://www.codecomments.com ***
Is the question does it take longer to load a 100 gig database on a 1/2 full
hard drive then an empty one?
I would think that it would take longer depending on the fragmentation of
your hard drive, your speed of your new drives, your bus speed, your RAID
controller, what type of cabling you are using to connect to your RAID, the
list goes on and on...
Please clarify...
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
"Bill" <nospam@.devdex.com> wrote in message
news:%23THF5$K7GHA.3492@.TK2MSFTNGP06.phx.gbl...
>
> when you add a filegroup to a existing server on a half full harddrive
> does it take longer to add if the file group size is very large likje
> over 100 gigs
> *** Sent via Developersdex http://www.codecomments.com ***
|||Mr Bruk:
What I meant was, does it take longer to add a small file group vs a
very large file group, on a drive that already has data on it.
Is adding a file group to a dataset set to a fixed amount of time with
no connection to the size of the filegroup.
In other words does it take longer to add a 100 gig file group vs a 20
gig filegeroup?
Bill
*** Sent via Developersdex http://www.codecomments.com ***
|||A filegroup doesn't by itself have any size. It is the database files that belongs to a file group
that has size. Yes, adding a larger file will take longer than a small file. You can test this for
yourself. Create a database with a data file of size 20 MB vs 20GB and you will see this. Note that
in 2005, you have "instant file initialization" but only for database files (see
http://www.karaszi.com/SQLServer/info_dont_shrink.asp for a few comments on instant file
initialization and what permission is needed). So in 2005, try both with a large data file and a
large log file to see the difference.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Bill" <nospam@.devdex.com> wrote in message news:%23%23wrYsT7GHA.4552@.TK2MSFTNGP05.phx.gbl...
> Mr Bruk:
> What I meant was, does it take longer to add a small file group vs a
> very large file group, on a drive that already has data on it.
> Is adding a file group to a dataset set to a fixed amount of time with
> no connection to the size of the filegroup.
> In other words does it take longer to add a 100 gig file group vs a 20
> gig filegeroup?
>
> Bill
> *** Sent via Developersdex http://www.codecomments.com ***
|||this question is straightforward the filegroup is being added due to the
other filegroups being full.
My question is does it take four times longer to add (blank as of yet)a
80gig filegroup vs a 20gig filegroup... At this time there is no data in
there, this is being done to add hd space for more room for additional
data..
Bill
*** Sent via Developersdex http://www.codecomments.com ***
|||See my reply from earlier today. Again, a filegroup doesn't have a size, the files does. Depending
on whether you get instant file initialization is a big factor. If you don't get instant file
initialization, then you look at create time for a file which proportional to the file size (windows
has to zero out the newly allocated hard drive space).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Bill" <nospam@.devdex.com> wrote in message news:O0zUTjW7GHA.3812@.TK2MSFTNGP02.phx.gbl...
>
> this question is straightforward the filegroup is being added due to the
> other filegroups being full.
> My question is does it take four times longer to add (blank as of yet)a
> 80gig filegroup vs a 20gig filegroup... At this time there is no data in
> there, this is being done to add hd space for more room for additional
> data..
> Bill
> *** Sent via Developersdex http://www.codecomments.com ***