Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Friday, June 18, 2010 3:22 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, July 01, 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