djordan 4543 (9/3/2013)
Would it show synchronizing if the database where out of sync for more than 10 seconds because sometimes my proc can run for more than 15 seconds.
Unlikely. Synchronous mirroring means SQL tries to stay synchronous, that means waiting for log commits on the mirror. Falling back to synchronising means it's failing to do what it's required to do.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability