Prev: 'INITCOLVS' is not a recognized built-in function name
Next: Invalid object name 'dbo.sysmergepublications'
From: Paul Ibison on 8 Nov 2006 14:59
Matthew,
this partly depends on what you are reindexing - system tables or user
tables. Generally speaking though, I ensure synchronization isn't occurring
while reindexing takes place, otherwise there tend to be job failures
because of blocking.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .


From: Matthew Mark on 8 Nov 2006 15:53
Paul,

I have never run reindexing on a replicated db. I have ,though, run a script
that runs the reindexing on all user tables. Are these MSarticles etc tables
system tables? I'd assume they are since the replication process creates it.

To avoid asking you a lot of specific questions, is there a comprehensive
guide I can read? The microsoft info online is usually good, only if you
already know the pitfalls. I don't.

If I make a mistake here because I didn't do my homework...., well, I'm sure
you understand. We don't replicate on our development server, so I can't
exactly practice ahead of time.
--
Matthew Mark



"Paul Ibison" wrote:

> Matthew,
> this partly depends on what you are reindexing - system tables or user
> tables. Generally speaking though, I ensure synchronization isn't occurring
> while reindexing takes place, otherwise there tend to be job failures
> because of blocking.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
>
>
From: Hilary Cotter on 8 Nov 2006 15:57
I am unsure what you mean here. Can you clarify it? I normally issue the
following dbcc dbreindex('msmerge_contents')

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"Matthew Mark" <MatthewMark(a)discussions.microsoft.com> wrote in message
news:9038947F-DAA7-476C-92ED-729E905E77E3(a)microsoft.com...
> When I do reindex, and loop through the tables, doesn't it include these
> tabels too?
> --
> Matthew Mark
>
>
>
> "Hilary Cotter" wrote:
>
>> reindexing does not propagate to the subscribers, I meant that you should
>> reinindex msmerge_contents, and msmerge_tombstone.
>>
>> --
>> Hilary Cotter
>> Director of Text Mining and Database Strategy
>> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
>>
>> This posting is my own and doesn't necessarily represent RelevantNoise's
>> positions, strategies or opinions.
>>
>> Looking for a SQL Server replication book?
>> http://www.nwsu.com/0974973602.html
>>
>> Looking for a FAQ on Indexing Services/SQL FTS
>> http://www.indexserverfaq.com
>>
>>
>>
>> "Matthew Mark" <MatthewMark(a)discussions.microsoft.com> wrote in message
>> news:2CB7AB6E-8D3B-48D8-A092-E55A8A25540A(a)microsoft.com...
>> > Here's what I understand from this.
>> >
>> > Since I couldn't find a MSMerge table I assume you mean to reindex the
>> > Article (tables) in MSarticles from the publisher.
>> >
>> > If so, how does this fall into the procedure. For example, based on
>> > what I
>> > know now, here's how I would do this.
>> > 1. Turn all merge agents off.
>> > 2. Put DB in restricted mode.
>> > 3. Run DBCC reindex, looping through all tables in this database.
>> > 4. Put dB back in Full access mode.
>> > 5. Turn merge agents back on.
>> >
>> > So, how does your suggesting fit in or modify this plan?
>> >
>> > Does the reindexing naturally replicate to the subscribers? or ?
>> >
>> >
>> >
>> > thanks
>> >
>> >
>> > --
>> > Matthew Mark
>> >
>> >
>> >
>> > "Hilary Cotter" wrote:
>> >
>> >> For merge replication it helps to reindex or defragment the msmerge
>> >> tables.
>> >> You need to stop the merge agents which you are doing this. Ideally
>> >> you
>> >> would stop all users while you are doing the reindexing.
>> >>
>> >> --
>> >> Hilary Cotter
>> >> Director of Text Mining and Database Strategy
>> >> RelevantNOISE.Com - Dedicated to mining blogs for business
>> >> intelligence.
>> >>
>> >> This posting is my own and doesn't necessarily represent
>> >> RelevantNoise's
>> >> positions, strategies or opinions.
>> >>
>> >> Looking for a SQL Server replication book?
>> >> http://www.nwsu.com/0974973602.html
>> >>
>> >> Looking for a FAQ on Indexing Services/SQL FTS
>> >> http://www.indexserverfaq.com
>> >>
>> >>
>> >>
>> >> "Matthew Mark" <MatthewMark(a)discussions.microsoft.com> wrote in
>> >> message
>> >> news:15C56BD5-DED8-41D2-9C16-9C87B664751C(a)microsoft.com...
>> >> > Does anyone know of a good set of guidelines to follow, after
>> >> > running
>> >> > DBCC
>> >> > Showcontig on a publisher of replication and DBCC reindexing is
>> >> > called
>> >> > for?
>> >> > What are the pitfalls and things to watch out for? I can't afford to
>> >> > make
>> >> > a
>> >> > mistake since there are three servers involved and it's in
>> >> > production.
>> >> >
>> >> > I can do the reindexing during night time hours. I've read a lot of
>> >> > material
>> >> > but haven't found "replication considerations" and have not found
>> >> > anything
>> >> > other than generalities when explaining how do analyze the Index
>> >> > fragmenting
>> >> > statistics.
>> >> > --
>> >> > Matthew Mark
>> >> >
>> >>
>> >>
>> >>
>>
>>
>>


From: Paul Ibison on 9 Nov 2006 04:24
Matthew,
I don't know of any guide about reindexing and replication. However I'm not
too sure there's much to it. If you know the difference between DBCC
DBREINDEX and DBCC INDEXDEFRAG, understand locking and blocking and can see
what the agents require access to in order to work, these are the basic
facts. All I can sey is that a simple guideline is to run DBCC DBREINDEX not
overly often and when you do, try to ensure that synchronization isn't
occurring.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .




First  |  Prev  | 
Pages: 1 2
Prev: 'INITCOLVS' is not a recognized built-in function name
Next: Invalid object name 'dbo.sysmergepublications'