February 19, 2013 at 11:15 pm
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!
February 20, 2013 at 12:23 am
Which mirroring operating mode do you use?
February 20, 2013 at 12:25 am
Asynchronous (high performance)
February 20, 2013 at 12:41 am
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
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- 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
February 20, 2013 at 8:29 pm
we checked on the server performance and everything seems ok. Any other idea?
February 21, 2013 at 3:06 am
Can you post these properties of your two sqlserver instances ?
Select Serverproperty('Edition') as Edition
, Serverproperty('ProductVersion') as ProductVersion
, Serverproperty('ProductLevel') as ProductLevel
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- 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
February 21, 2013 at 3:46 am
Both of the servers shows this information:
Edition: Enterprise Edition
Product version: 10.50.1600.1
Product level: RTM
February 21, 2013 at 5:09 am
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
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- 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
February 21, 2013 at 7:10 pm
current is SP4 and upgrade to SP4?? :unsure:
February 21, 2013 at 7:10 pm
sorry. I mean SP2. 😛
February 21, 2013 at 11:54 pm
indeed.
( for both sqlserver instances please, RTM is already a couple of years old and there are many fixes implemented with the SPs )
You only need to apply the latest one !
If your sqlserver instances are clustered instances, best is to apply the SP on the passive node(s) for the instance, then failover ( - it will apply the needed upgrade stuff at instance startup time - ) and then apply the SP on the node that was serving the instance before.
Described nicely in the read-me doc of the servicepack. :hehe:
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- 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
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply