January 15, 2016 at 2:17 pm
In resource monitor I'm seeing read i/o's from disk averaging around 500mb per second (the distribution DB itself is only about 4.5mb. The write i/o's are around 400k. The db is not growing and CPU looks good. I've checked replication and it seems optimal as well.
Any thoughts?
Thanks.
Tom
January 16, 2016 at 1:48 am
What's your problem exactly?
-- Gianluca Sartori
January 19, 2016 at 10:47 am
Sorry. My question is, what could be causing such high disk read i/o's from the primary distribution data file? It is 100 times the amount of the write i/o's and 10 times higher than the actual size of the database.
(Additional information: I have noticed the row count in the MSrepl_commands table is 8,395,134, which seems high to me, and I do not see a "Distribution clean up: distribution" job listed under the jobs.)
January 21, 2016 at 9:40 am
Fixed it. The distribution cleanup job was not performing and I was able to run the stored procedure manually.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply