InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 02:36:05 GMT20http://www.sqlservercentral.com/Forums/Topic939441-382-1.aspxI have done my live database (10gb size) mirroring with high safety [b]without[/b] automatic fail over (synchronous) resulting slow performance. As we have SQL server 2005 [b]std [/b]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...Fri, 18 Jun 2010 03:22:14 GMTsivaji