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/techinfo/administration/2000/perftuning.asp Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.com/sql_server_performance_audit.asp Hardware Performance CheckList
http://www.sql-server-performance.com/best_sql_server_performance_tips.asp SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_perfmon_24u1.asp
Disk Monitoring
--
Andrew J. Kelly SQL MVP
[quoted text, click to view] "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...
> > 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
> > >
> > >
> >
> >
>
>
