INFO/SUGGESTIONS Please : SQL performance (fragmented disk)

I'm a developer at my company, but I've worked with hardware quite abit at my last job. I'm finding it hard to talk to one of our system admins here.

I'm running into what looks like disk issues on our SQL Server, I know the DB files all reside on a large SCSI Raid, the only files on the RAID are the DB files, no OS or program files.

Also the disks have never been defragmented, he wants to say :

1. SCSI and RAID eliminate the impact of fragmentation.
2. SQL doesn't get impacted by physical fragmentation.

I know both to be false statements but don't want to start an argument, nor go over his head.

I would like to "find" some reputable articles dealing with disk fragmentation and SQL(database) performance..

If anyone has a good site that displays good information I would greatly appreciate it.

OR

If anyone has some personal experience with issues like this, please share them..

You may want to read the following white paper: 'Microsoft SQL Server 2000 Index Defragmentation Best Practices' (http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx), which may give you more idea about fragmentation.

Thanks

Stephen

Info about Active/Active SQL 2000 Cluster

Hi all,
i need configure a active/active SQL2000 cluster but i don't have experience
in this scenario
The hardware and installation of MSCS di the same for the active/passive
configuration ?
In active/active configuration i must install more SQL virtual server (two)
on the same node ?
Thanks.http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/adminsql/ad_clustering_81ma.asp
>--Original Message--
>Hi all,
>i need configure a active/active SQL2000 cluster but i
don't have experience
>in this scenario
>The hardware and installation of MSCS di the same for the
active/passive
>configuration ?
>In active/active configuration i must install more SQL
virtual server (two)
>on the same node ?
>Thanks.
>
>.
>|||Thanks,
but a last questions :
if i configure a active/active SQL Cluster may my web application may point
to virtual istance and the modified a date and a view the same data on the
both virtual SQL server ?
This mean active/active SQç cluster ?
bye
"Julie" <anonymous@.discussions.microsoft.com> wrote in message
news:11f5401c4423b$b8eadd40$a101280a@.phx.gbl...
> http://msdn.microsoft.com/library/default.asp?
> url=/library/en-us/adminsql/ad_clustering_81ma.asp
>
> >--Original Message--
> >Hi all,
> >
> >i need configure a active/active SQL2000 cluster but i
> don't have experience
> >in this scenario
> >
> >The hardware and installation of MSCS di the same for the
> active/passive
> >configuration ?
> >
> >In active/active configuration i must install more SQL
> virtual server (two)
> >on the same node ?
> >
> >Thanks.
> >
> >
> >.
> >|||Not unless you replicate the data between the 2 virtual servers...
An active/active cluster has a virtual server on EACH of the physical
servers... Each virtual server is alive and doing a piece of work ( like
one might be HR and the other the SHOPFloor server)... Each virtual server
can fail over to the other physical server... But they are otherwise NOT
related to one another... (unless YOU do something to move data between the
two)
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
<io.com> wrote in message news:%23ayW5OkQEHA.1620@.TK2MSFTNGP12.phx.gbl...
> Thanks,
> but a last questions :
> if i configure a active/active SQL Cluster may my web application may
point
> to virtual istance and the modified a date and a view the same data on the
> both virtual SQL server ?
> This mean active/active SQç cluster ?
> bye
>
> "Julie" <anonymous@.discussions.microsoft.com> wrote in message
> news:11f5401c4423b$b8eadd40$a101280a@.phx.gbl...
> > http://msdn.microsoft.com/library/default.asp?
> > url=/library/en-us/adminsql/ad_clustering_81ma.asp
> >
> >
> > >--Original Message--
> > >Hi all,
> > >
> > >i need configure a active/active SQL2000 cluster but i
> > don't have experience
> > >in this scenario
> > >
> > >The hardware and installation of MSCS di the same for the
> > active/passive
> > >configuration ?
> > >
> > >In active/active configuration i must install more SQL
> > virtual server (two)
> > >on the same node ?
> > >
> > >Thanks.
> > >
> > >
> > >.
> > >
>