|
Home > Archive > Microsoft SQL Server forum > April 2005 > Question with filegroups
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
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
| |
| Greg D. Moore \(Strider\) 2005-04-22, 8:23 pm |
|
"Adam" <adam@someone.com> wrote in message
news:4269993c$1_4@al
t.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
>
>
| |
| John Bell 2005-04-23, 7:23 am |
| Hi
You may want to look at:
http://www.sql-server-performance.c...
ance.asp
John
"Adam" <adam@someone.com> wrote in message
news:4269993c$1_4@al
t.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
>
|
|
|
|
|