My relication is transaction replication. I create 32 streams do the job.But awayls change to single stream after hours. I found no any error in log and .err file on both distributor and subscriber.what's wrong? please help me.
The distribution agent will switch to use only one session if one of the sessions raises an error or if the blocking monitor thread detects blocking. Some of the errors will not be automatically be logged by SQL Server.
To determine why the distribution agent has switched to use only one session, please follow the steps in the section
How to troubleshoot a Distribution Agent that switches to use only one session in this KB article: