we use single mssql2005 run a SP need around 20min

but same data and same SP run in sql2005 cluster need around 50min

anyone know the problem, we connect SAN for the mssql 2005 cluster

You need to compare the non-clustered on the same SAN disks with the
clustered on the SAN disks:

Can you run the single mssql2005 on the same SAN disks running the same SP ?

Please post back the result

thanks,
Edwin.


"ken" <keung61581 (AT) yahoo (DOT) com.hk> wrote