Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

high safety without automatic failover (sync) resulting slow performance. Expand / Collapse
Posted Friday, June 18, 2010 3:22 AM


Group: General Forum Members
Last Login: Thursday, July 1, 2010 6:33 AM
Points: 11, Visits: 61
I have done my live database (10gb size) mirroring with high safety without automatic fail over (synchronous) resulting slow performance. As we have SQL server 2005 std edition we can not go for asynchronous mode. And we can not go for enterprise edition now due to various other factors. This database is being connected from java web application and my customers are experiencing severe slow performance. Please could someone let me know how to know where and how to start analyzing the issue and possible reasons behind this slow performance like indexes etc...
Post #939441
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse