Prev: 'INITCOLVS' is not a recognized built-in function name
Next: Invalid object name 'dbo.sysmergepublications'
From: Matthew Mark on 8 Nov 2006 11:51
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: Hilary Cotter on 8 Nov 2006 12:43
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: Matthew Mark on 8 Nov 2006 13:14
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: Hilary Cotter on 8 Nov 2006 13:43
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: Matthew Mark on 8 Nov 2006 14:20
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
> >> >
> >>
> >>
> >>
>
>
>
 |  Next  |  Last
Pages: 1 2
Prev: 'INITCOLVS' is not a recognized built-in function name
Next: Invalid object name 'dbo.sysmergepublications'