Post reply

Database mirroring creating a performance hit on principle?

  • June 24, 2011 at 7:14 am

    #253381

    I have a client reporting sluggish performance on the principle server in a mirrored environment.

    Running sp_who2 yielded some large cpu times and disk IO times. Here is a link to the screen shot

    mirror_sp_who

    The secondary server is seeing a few 'SQL Server has encountered x occurrence(s) of I/O requests taking longer than 15 seconds to complete on file...' x is sometimes in the tens of thousands.

    Could these spid's be the culprit? Has anyone encountered anything like this? Is it as simple as killing those processes? Any help would be immensely appreciated. Thanks!

  • June 24, 2011 at 8:01 am

    #1343669

    Will mirroring blow up if I kill these processes? Will they automaticlly pick back up?

  • June 24, 2011 at 2:02 pm

    #1343912

    Is this synchronous or asynchronous mirroring?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 3 posts - 1 through 2 (of 2 total)

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