Filegroups and indexes

Hi,
I have two physical disks that each have and NDF file(two different
filegroups: FG1 on Disk1, FG2 on disk2).
Also I have two tables that my queries always join them.
Which decision will lead to better performance:
1) Placing Table1 and Table2 on first disk(FG1) and placing their indexes on
disk2(FG2)
2) Placing Table1 and its indexes on FG1 and placing Table2 and its indexes
on FG2.
Many thanks in advance.
Leila
The only way to know is to test it in your exact situation. It could be
that neither will give you any better performance.
Andrew J. Kelly SQL MVP
"Leila" <lelas@.hotpop.com> wrote in message
news:%239Irja%23oEHA.3460@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I have two physical disks that each have and NDF file(two different
> filegroups: FG1 on Disk1, FG2 on disk2).
> Also I have two tables that my queries always join them.
> Which decision will lead to better performance:
> 1) Placing Table1 and Table2 on first disk(FG1) and placing their indexes
on
> disk2(FG2)
> 2) Placing Table1 and its indexes on FG1 and placing Table2 and its
indexes
> on FG2.
> Many thanks in advance.
> Leila
>
|||Andrew,
What conditions should be met so that it helps to increase performance?
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:#A0VAPApEHA.2948@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> The only way to know is to test it in your exact situation. It could be
> that neither will give you any better performance.
> --
> Andrew J. Kelly SQL MVP
>
> "Leila" <lelas@.hotpop.com> wrote in message
> news:%239Irja%23oEHA.3460@.TK2MSFTNGP15.phx.gbl...
indexes
> on
> indexes
>
|||That's a big subject but when it comes to disks your best bet is to see if
you have disk queue issues first. You can do this by monitoring the Avg &
current disk queues in Perfmon. Here are some links that may help:
http://www.microsoft.com/sql/techinf...perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.co...ance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.co...mance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/de...rfmon_24u1.asp
Disk Monitoring
Andrew J. Kelly SQL MVP
"Leila" <leilas@.hotpop.com> wrote in message
news:uuRgqnApEHA.2032@.TK2MSFTNGP10.phx.gbl...
> Andrew,
> What conditions should be met so that it helps to increase performance?
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:#A0VAPApEHA.2948@.TK2MSFTNGP11.phx.gbl...
> indexes
>