We recently installed a EMC FC4500, and are running SQL2000(ent)on the SAN. We have noticed that the performance on SQL processes is slower (about afactor of6) on the SAN than on the original local RAID.
We have noticed that when running the process on the DB that is on the SAN, the number of reads in the process goes up about
a factor of 6.
Anyone ever run into this? We have noticed increases in other SAN functions (backups, and SQL backups) it is just when it runs this process runs. Kind of banging our heads
right now as to if it is a SQL issue or a SAN issue.
Thanks for any info.