469,082 Members | 1,216 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,082 developers. It's quick & easy.

Question with filegroups

I'm trying to tweak our DB as much as I can. We have the full application
database sitting on a RAID 10. Logs, tempdb, etc.. are on separate arrays.
I read some articles about making separate filegroups. Of course, they all
say to move them to different arrays, which because of budget is not
possible right now. I also read articles that say to put large tables in a
filegroup then add another data file to the group. This allows SQL Server
to use multiple threads to access the tables. Therefore, to my question.
If I split our database up into multipele file groups on the same array,
could I see a performance gain. Would the database be able to issue
different threads for each group when a query is run and improve overall
performance.

Thank you,

Adam
Jul 23 '05 #1
2 1618

"Adam" <ad**@someone.com> wrote in message
news:42**********@alt.athenanews.com...
I'm trying to tweak our DB as much as I can. We have the full application
database sitting on a RAID 10. Logs, tempdb, etc.. are on separate arrays. I read some articles about making separate filegroups. Of course, they all say to move them to different arrays, which because of budget is not
possible right now. I also read articles that say to put large tables in a
filegroup then add another data file to the group. This allows SQL Server
to use multiple threads to access the tables.
This was true up to (or thru, I always forget) SQL 7.0. It's no longer
true.
Therefore, to my question.
If I split our database up into multipele file groups on the same array,
could I see a performance gain. Would the database be able to issue
different threads for each group when a query is run and improve overall
performance.
No. But, for VLDB, maintenance can sometimes be easier. (and SQL 2005 will
have some REAL nifty things in this regard.)

Thank you,

Adam

Jul 23 '05 #2
Hi

You may want to look at:
http://www.sql-server-performance.co...erformance.asp

John

"Adam" <ad**@someone.com> wrote in message
news:42**********@alt.athenanews.com...
I'm trying to tweak our DB as much as I can. We have the full application
database sitting on a RAID 10. Logs, tempdb, etc.. are on separate
arrays. I read some articles about making separate filegroups. Of course,
they all say to move them to different arrays, which because of budget is
not possible right now. I also read articles that say to put large tables
in a filegroup then add another data file to the group. This allows SQL
Server to use multiple threads to access the tables. Therefore, to my
question. If I split our database up into multipele file groups on the
same array, could I see a performance gain. Would the database be able to
issue different threads for each group when a query is run and improve
overall performance.

Thank you,

Adam

Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by rc | last post: by
13 posts views Thread by MissLivvy | last post: by
3 posts views Thread by Stevey | last post: by
3 posts views Thread by datapro01 | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.