Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Mirroring and performance Expand / Collapse
Author
Message
Posted Tuesday, February 19, 2013 11:15 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 2, 2013 9:54 PM
Points: 24, Visits: 88
hi, anyone know how to maintain the performance of database while mirroring. Because we notice that the system become slower after we do the mirroring and back to normal while we pause the mirroring. Please advise on what can I do to get a better performance while mirroring.

Thanks in advance!
Post #1421932
Posted Wednesday, February 20, 2013 12:23 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 8:38 AM
Points: 223, Visits: 1,725
Which mirroring operating mode do you use?
Post #1421945
Posted Wednesday, February 20, 2013 12:25 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 2, 2013 9:54 PM
Points: 24, Visits: 88
Asynchronous (high performance)
Post #1421947
Posted Wednesday, February 20, 2013 12:41 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:11 AM
Points: 7,010, Visits: 8,461
I would double check:
1- network bandwith and consumption ( drastically enhanced with SQL2008 ! in case you still need an upgrade reason )
2- I/O subsystem performance
3- ram pressure

of course ... before and after mirroring activation.



Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #1421951
Posted Wednesday, February 20, 2013 8:29 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 2, 2013 9:54 PM
Points: 24, Visits: 88
we checked on the server performance and everything seems ok. Any other idea?
Post #1422386
Posted Thursday, February 21, 2013 3:06 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:11 AM
Points: 7,010, Visits: 8,461
Can you post these properties of your two sqlserver instances ?
Select  Serverproperty('Edition') as Edition
, Serverproperty('ProductVersion') as ProductVersion
, Serverproperty('ProductLevel') as ProductLevel



Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #1422468
Posted Thursday, February 21, 2013 3:46 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 2, 2013 9:54 PM
Points: 24, Visits: 88
Both of the servers shows this information:

Edition: Enterprise Edition
Product version: 10.50.1600.1
Product level: RTM
Post #1422483
Posted Thursday, February 21, 2013 5:09 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:11 AM
Points: 7,010, Visits: 8,461
fatinnadiah88 (2/21/2013)
Both of the servers shows this information:

Edition: Enterprise Edition
Product version: 10.50.1600.1
Product level: RTM


You posted in a SQL 2005 forum !

Your server is SQL2008R2 !

btw the current service pack for SQL2008R2 is SP2 !

Upgrade to SP2 if you can and then reassess your issue


Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #1422505
Posted Thursday, February 21, 2013 7:10 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 2, 2013 9:54 PM
Points: 24, Visits: 88
current is SP4 and upgrade to SP4??
Post #1422843
Posted Thursday, February 21, 2013 7:10 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 2, 2013 9:54 PM
Points: 24, Visits: 88
sorry. I mean SP2.
Post #1422844
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse