Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jonv15
Starting Member
1 Post |
 Posted - 2006-09-22 : 19:16:32
|
| I am working on a contract job and currently they have environment where merge replication is setup. They have been having issues with performance in general not just with replication and the first thing I noticed was they did not have a db maintenance plan setup. With setting up the DB Maintenance plan on a db that is being replicated to and from (since it is merge) will the maintenance plan cause any conflics with the merge replication running simultaneously? |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2006-09-23 : 16:28:10
|
| Have you verified they do not have scheduled jobs running, which are doing the maintenance and backups?In answer to your question, it could cause conflicts, especially if they are already having issues. Have you looked at the performance counters and ran profiler to figure out where the performance issues are stemming from?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
SQL Server 2000 Merge Rep & DB Maintenance Plan