Prev: COUNT and AVG problem
Next: Using TransferData
From: M A Srinivas on 20 Aug 2007 08:53
All the datbases in one server are mirrored to another server with
safety=off . Bot the server are on the same location running on 64
bit windows and sql server 64 bit with SP2 .

When I query wait tasks dmv (sys.dm_os_waiting_tasks) , always higher
wait types are dbmirroring_cmd . Is there a way to know how much
performance impact on the application
due to mirroring . Disabling mirroring is not an option .
This is to ascertain whether clustering is better than mirroring from
performance point of view and by how much ?

wait_duration_ms wait_type
798000 DBMIRRORING_CMD
797937 DBMIRRORING_CMD
797890 DBMIRRORING_CMD
797453 DBMIRRORING_CMD
797312 DBMIRRORING_CMD
796875 DBMIRRORING_CMD
796625 DBMIRRORING_CMD
796562 DBMIRRORING_CMD
796203 DBMIRRORING_CMD
511203 DBMIRRORING_CMD
287406 DBMIRRORING_CMD
251203 DBMIRRORING_CMD

 | 
Pages: 1
Prev: COUNT and AVG problem
Next: Using TransferData