Viewing 15 posts - 61 through 75 (of 195 total)
Assuming you're talking about transactional replication. If so and you are 100% certain that no data will change while you're moving to the new server than you can resubscribe without...
March 5, 2009 at 1:09 pm
neold gave answer already, but so that you have a second opinion...I agree, merge is the way you want to go based on the scenario you just described.
This shouldn't be...
March 5, 2009 at 1:07 pm
Replication honors transactional boundries, and the values for commitbatchsize and commitbatchthreshold dictate the number of transactions that are delivered to a subscriber.
How it works is NOT very well documented in...
March 5, 2009 at 1:01 pm
If one of the subscribers is shut down or otherwise drops off the network then the distribution agent for that subscription would fail, but the other subscribers should be fine....
March 5, 2009 at 12:48 pm
The negative space is likely a result of inaccuracies in your catalog views. Re-run sp_spaceused with the @updateusage parameter set to true; that will run DBCC UPDATEUSAGE which should correct...
March 5, 2009 at 12:44 pm
Perry Whittle (2/19/2009)
Great blog Kendal (you have way too much time on your hands 😀 )very informative
Thanks for the positive feedback!
I posted part 7 this afternoon. Wrapup coming tomorrow.
February 19, 2009 at 3:20 pm
RichardB (2/19/2009)
Fair enough - but if you haven't read the book I thoroughly recommend it 😀
I may do that, thanks.
To show you that I do not intend to mislead anybody...
February 19, 2009 at 9:41 am
The graphs make out there is a huge difference - because of where you have cut the axes. Naughty, naughty.
First off, thanks for taking the time to read my...
February 19, 2009 at 9:15 am
FYI I finally got the chance to post the results of my RAID 1\5\10 tests.
The entire series is here: http://kendalvandyke.blogspot.com/2009/02/disk-performance-hands-on-series.html
Part 6, specifically about RAID 10 vs. RAID 1, is here:...
February 18, 2009 at 3:19 pm
Not very much information provided, so I'll talk in some generalities...if your server is acting as both the publisher and the distributor you are likely to run into IO contention...
February 16, 2009 at 8:52 am
Perhaps this will help:
January 18, 2009 at 8:10 pm
There are a number of excellent white papers available on tuning SQL2005 including the disk subsystem ( from Microsoft )
I've read the whitepaper but whitepapers tend to be general in...
December 30, 2008 at 8:55 am
Kenneth Wilhelmsson (12/30/2008)
RBarryYoung (12/29/2008)
No, RAID 1 has twice the Read IO throughput of a single disk.
How can that be, Barry?
RAID 1 can only have two drives, and one is...
December 30, 2008 at 6:10 am
matt stockham (12/23/2008)
If I remember correctly, fragmentation statistics aren't accurate for multiple files either.
Great idea, and for clarification I looked this one up. The value for Extent Scan Fragmentation in...
December 28, 2008 at 10:22 pm
First off, thanks for the reply...
RAID 1 Disadvantages:
Highest disk overhead of all RAID types (100%) - inefficient
RAID 10 suffers the same 100% inefficiency as RAID 1 with regards to mirroring...
December 28, 2008 at 9:12 pm
Viewing 15 posts - 61 through 75 (of 195 total)