Hi all. i have notice a performamce degrade with mirroring. some users even report TIMEOUT on some queries. onSQL STD Sp2.
Database Mirroring wouldn't cause any performance loss, so you have to identify the root cause on slow running queries and check the index defragmentation plans.
the queries were running fine before mirroring. Now i even have timeout when saving transaction in the database. any advice Thanks
What is the defragmentation practice on this database? Are you running UPDATE STATS against these tables within this TIMEOUT queries?
autoupdate stats is on. We have no other defrag actions running. What are the required actions that we need to do for performance optimisation.?