SQL Server Performance


Discussion in 'SQL Server 2005 Database Mirroring' started by Akthar, Mar 13, 2008.

  1. Akthar New Member

    Hi all.
    i have notice a performamce degrade with mirroring. some users even report TIMEOUT on some queries. onSQL STD Sp2.
  2. satya Moderator

    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.
  3. Akthar New Member

    the queries were running fine before mirroring. Now i even have timeout when saving transaction in the database.
    any advice
  4. satya Moderator

    What is the defragmentation practice on this database?
    Are you running UPDATE STATS against these tables within this TIMEOUT queries?
  5. Akthar New Member

    autoupdate stats is on. We have no other defrag actions running.
    What are the required actions that we need to do for performance optimisation.?

Share This Page