Sunday, March 25, 2012

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.developersdex.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.developersdex.com ***

No comments:

Post a Comment