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 |
|
poratips
Posting Yak Master
105 Posts |
 Posted - 2013-07-17 : 17:26:03
|
| Hello,We have sql 2005 and running Replication fro m3ed party s Publication and we have subscription.Sometimes performance is too slow for our other user and we have to kill those users which ones are waiting.The DB runs for suvscription is almost above 200 GB.Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
poratips
Posting Yak Master
105 Posts |
Posted - 2013-07-18 : 14:17:30
|
| Thanks Tara.I am watching running queries during that time but also know that sometimes we run batch job and other reports so it might slows down too.I am watching Sql Activity Monitor and see most of the jobs are from replication and we are only subscriber so we don't have any control over publisher.Do you suggest any troubleshooting on subscriber side?Some of the custom Index, I tried to rebuild and updated stats.Mostly I can see user waits while watching WAITSTAT and it's mainly CXPACKET and PAGEIO_LATCH but it's shows up nd goes.Thanks |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
poratips
Posting Yak Master
105 Posts |
Posted - 2013-08-15 : 16:22:43
|
| Thanks Tara.I already run Missing Index report also and implemented couple indexes which help but not much as whenever Month Ending process running, it causing lots of Waiting sessions and causing the slow performance issue.Thanks. |
|
|
|
|
|
|
Replication - Slow Performance