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
>
>
Sunday, February 12, 2012
About FILEGROUP
Labels:
create,
database,
filegroup,
filegroups,
microsoft,
mysql,
oracle,
performance,
server,
sql,
toincrease
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment