high safety without automatic failover (sync) resulting slow performance.

  • 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...

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply