February 16, 2009 at 12:00 pm
Hi
Is this possible to know the estimated time to for DBCC DBREINDEX to run on a table with 3GB size. I am reindexing merge agent system table
"msmerge_contents".
Thanks
February 16, 2009 at 2:37 pm
If this is a table that SQL Server uses in order to manage the replication, I’d check first if I can rebuild the index. I once had a problem with one of our servers that had lots of replications (about 150 publications) that suddenly stopped working. We opened a case with Microsoft and it turned out that that a job that checked fragmentation for all tables and rebuild clustered index where we had fragmentation, worked on one of the tables that manage the replication. This caused the replications to stop working and we had to drop all the replications and recreate them. Although it was transactional replication on SQL Server 2000, I’d still check with Microsoft if I can rebuild indexes on that table. If you can rebuild the index, check out in BOL alter index statement. You can rebuild indexes with alter index statement and if you have enterprise edition you can do it while the index and the table are still online.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 16, 2009 at 2:43 pm
But the problem is my replication synchronization job is getting failed . Message comming is : The process couldnot deliver update at the Publisher .Try Rebuilding indexes and in MSDN article they have mentioned to recreate indexes on system table "msmerge_contents".
How how can i get rid of this problem without havig to create indexes on this table ?? Any suggestions.
February 16, 2009 at 3:20 pm
I didn’t say that you shouldn’t rebuild the index. I said that you should be sure that you can. If there is an article at MSDN that says that you can and should rebuild the index, then go ahead and do it.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply