SAN: tempdb and log files not isolated from others files

HI,
SQL Server 7.0 on NT 4 (clustered)
- 3 DB totaling 7 + 2 + 1 = 10 GIG
- 100 users
- Jobs that insert many (1000 - 5000) rows in databases are executed during
office hour.
Our technical staff want to install our databases on a new Compaq SAN in
this way --> One big array containg 36 disk drives.
They told me that they can create "logical volume" for RAID 1 and RAID5 but
"tempdb" and "log files" are not going to be isolated on a small group on
disk. Data files, log files, tempdb and others files are all going to be
striped on the big array of 36 disks. In others word, we can have 1 piece of
tempdb, 1 piece on log, 1 piece of data file, 1 piece of a .bak file etc...
on the same disk.
With this scenario, is it possible to encounter bad performace ?
Thank you
dannyIt's really hard to say without actually testing it on the hardware you
mentioned and under the max load. It doesn't sound like you have that many
transactions but it really depends on how well the schema was designed, how
you actual use the data, how many and what type of transactions, how much
cache in the SAN etc, etc. 36 Drives will help to reduce head contention
and it will probably be OK but noone can say for sure without much more
intimate knowledge of the above mentioned.
--
Andrew J. Kelly
SQL Server MVP
"Danny Presse" <dpresse@.congresmtl.com> wrote in message
news:%23b3fs0hVDHA.1832@.TK2MSFTNGP09.phx.gbl...
> HI,
> SQL Server 7.0 on NT 4 (clustered)
> - 3 DB totaling 7 + 2 + 1 = 10 GIG
> - 100 users
> - Jobs that insert many (1000 - 5000) rows in databases are executed
during
> office hour.
> Our technical staff want to install our databases on a new Compaq SAN in
> this way --> One big array containg 36 disk drives.
> They told me that they can create "logical volume" for RAID 1 and RAID5
but
> "tempdb" and "log files" are not going to be isolated on a small group on
> disk. Data files, log files, tempdb and others files are all going to be
> striped on the big array of 36 disks. In others word, we can have 1 piece
of
> tempdb, 1 piece on log, 1 piece of data file, 1 piece of a .bak file
etc...
> on the same disk.
> With this scenario, is it possible to encounter bad performace ?
> Thank you
> danny
>