Sunday, February 12, 2012

About FILEGROUP

Hi all,
I would like know if I create many FILEGROUPs in SQL, this will help to
increase performance of this SQL Server.
ThanksPerformance might be improved if you follow some basic principles. Red more
here:
http://msdn.microsoft.com/library/d... />
1_4cj7.asp
...and here:
http://msdn.microsoft.com/library/d... />
1_9vn7.asp
ML|||Prformance can be improved if and only if you can have more files and a tabl
e
is based on more than one file group so that threads are spread accross disk
s
like in RAID models
--
Regards
R.D
--Knowledge gets doubled when shared
"ReTF" wrote:

> Hi all,
> I would like know if I create many FILEGROUPs in SQL, this will help to
> increase performance of this SQL Server.
> Thanks
>
>

No comments:

Post a Comment