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 |
|
alliance
Starting Member
2 Posts |
 Posted - 2010-09-21 : 21:25:19
|
Hi guys, I would like to ask some help from you. Here's the problem. We have a transactional replication going on in our project, and it is my first time to handle such system. We are using MS SQL 2000 server. I configured the system so that primary keys are copied. I didn't encounter any issues in deploying the servers as well as configuring it. In fact, the initial replication already started, "7 days ago", and it's taking FOREVER to finish. I don't know how to explain it, but i'll post a print screen so that you can see what's going on here. As you can see, Snapshot agent is done, and distribution agent is still in process. The distribution agent is working around 5 days on XMLTransactionsLog table already. The table has 133 MILLION rows, and the agent is like copying 100,000 rows in 10 minutes. Are there any ways to speed up this process? Any configurations that I should make? Please help.. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
alliance
Starting Member
2 Posts |
Posted - 2010-09-22 : 01:50:45
|
quote:
Originally posted by tkizer
Check blocking via sp_who/sp_who2/sysproceses, hardware via PerfMon, and the Error Log. You may want to pop open Profiler, although I'm not sure exactly what you'd see.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
Thank you for your reply. Sorry for the noob question, but how am I going perform this steps? I'm very new to SQL Servers and I only know very few things about them. I was able to check the Error log on the distribution agent though, there are errors that say 'The Agent is Suspect. No Response within the last 10 Minutes'. I increased the Inactivity threshold to resolve the error. |
 |
|
|
|
|
|
|
|
Copying rows is taking forever to finish