Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » Mirroring and performance
Add to briefcase
11 posts, Page 1 of 2
12»»

Mirroring and performance Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
fatinfzi
Posted Tuesday, February 19, 2013 11:15 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 02, 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
e4d4
Posted Wednesday, February 20, 2013 12:23 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 2:23 PM
Points: 160, Visits: 1,142
Which mirroring operating mode do you use?
Post #1421945
fatinfzi
Posted Wednesday, February 20, 2013 12:25 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 2:13 PM
Points: 6,866, Visits: 8,071
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

     Jul 13

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
fatinfzi
Posted Wednesday, February 20, 2013 8:29 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 2:13 PM
Points: 6,866, Visits: 8,071
Can you post these properties of your two sqlserver instances ?
Select  Serverproperty('Edition') as Edition
      , Serverproperty('ProductVersion') as ProductVersion
      , Serverproperty('ProductLevel') as ProductLevel

Johan

     Jul 13

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
fatinfzi
Posted Thursday, February 21, 2013 3:46 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 02, 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
ALZDBA
Posted Thursday, February 21, 2013 5:09 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 2:13 PM
Points: 6,866, Visits: 8,071
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

     Jul 13

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
fatinfzi
Posted Thursday, February 21, 2013 7:10 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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

Add to briefcase
11 posts, Page 1 of 2
12»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.