SQLServerCentral / Discuss Content Posted by Jay Dave / Article Discussions / Article Discussions by Author

A Look at Database Mirroring

sqldba-294117 — Tue, 19 Jun 2007 16:40:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jDave/3046.asp

DB Mirroring Networking Issues

Zgondea Paul — Mon, 23 Jun 2008 04:36:18 GMT

Hello, I am currently working on a database mirroring setup for 10 databases each under 5 GB.When i enable mirroring on the Principal server, even before i actually start mirroring databases i noticed that network wait increases. I am using Quest Performance Analysis to monitor my Principal and my Mirror. I haven't found documentation on this type of wait (DBmirror Events Queue, DBmirror CMD) and don't know if I should be concerned or if this is normal. As i try to add new databases for mirroring i noticed that these wait events increase and at 5-6 databases network workload starts to be a problem as it rises to 80-90% although performance monitor on both mirror and principal report a maximum of 200 KB / sec transfer.Both Principal and Mirror have a Gbit network card and they're both in the same private lan. If you have any suggestions on what i should monitor please give me a hint.Here is a screenshot of what Q. Perf. Analysis signals as a network performance problem. [URL=http://img45.imageshack.us/my.php?image=pacu6.jpg][IMG]http://img45.imageshack.us/img45/187/pacu6.th.jpg[/IMG][/URL]Thank you.

high safety without automatic failover (sync) resulting slow performance.

sivaji — Fri, 18 Jun 2010 03:22:14 GMT

I have done my live database (10gb size) mirroring with high safety [b]without[/b] automatic fail over (synchronous) resulting slow performance. As we have SQL server 2005 [b]std [/b]edition we can not go for asynchronous mode. And we can not go for enterprise edition now due to various other factors. This database is being connected from java web application and my customers are experiencing severe slow performance. Please could someone let me know how to know where and how to start analyzing the issue and possible reasons behind this slow performance like indexes etc...

Patching SRDF SQL 2005

simon.p.miller — Thu, 30 Jul 2009 04:39:02 GMT

Anyone know best practice for patching sql2005 SRDF pair ?We have Cluster prod server hosting 4 instancesWe have standalone DR hosting 4 instancesData and Log luns are replicated via SRDFA (in system dbs)Binaries installed on C drive local disks for prod and DRHow do we patch DR server1.)Break mirror2.) Install SP3 Patch Production3.) Start SQL services DR (will the start without modification - all startup paths are same as prod)4.) Install SP3

Starting SQL Server in Minimal Configuration

sqldba-294117 — Mon, 09 Apr 2007 10:40:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jDave/2963.asp

Microsoft DPM

sqldba-294117 — Wed, 02 May 2007 18:54:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jDave/2986.asp

SMS Script

sqldba-294117 — Sat, 03 Nov 2007 09:29:32 GMT

Comments posted to this topic are about the item [B]SMS Script[/B]

XML Notepad with SSMS

sqldba-294117 — Thu, 28 Jun 2007 12:35:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jDave/3060.asp