Viewing 3 posts - 1 through 3 (of 3 total)
Find the file Quest \sqlserver_spotlight\2005\QS_GeneralDBStats.sql and change (readpast) with(nolock)
March 26, 2015 at 2:42 pm
#1786692
What is the line speed between the distibutor and the subscriber? i believe here we are talking about LAN speed. if yes, it's 1 GB.
March 21, 2012 at 9:25 am
#1462218
How many rows are there in your msrepl_commands table on the distribution server = 112078447
Yes, I do see ASYNC_NETWORK_IO (most signifiacant Waiting Tasks rate 750 tasks/s) and WRITELOG.
No, its not...
March 21, 2012 at 9:23 am
#1462216