July 14, 2003 at 8:58 am
Is anyone aware of performance degradation writing to a SAN over fibre optic network? We r using SQL Server 2000 (Enterprise version) with Compaq Proliant DL580 G2, writing to Compaq SAN. Is any network tuning needed? A gigabit ethernet card pushes the data over to the SAN.
Also, we r taking about 37 hours building a cube for a database barely 15GB. Database is shipped by Microsoft and is used by their product Microsoft Proect Server. So, database level tuning is out of question.
Any help would greatly be appreciated.
Thanx in advance,
Bhushan
July 14, 2003 at 11:27 am
Shouldnt need anything. You can have someone check the switch, see if you're having problems there. Is performance on the SAN ok otherwise? At some point you're going to max out the cache and be working at the limits of your physical disks - how many spindles, what rpm?
Andy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply