I have just created 2 very simple SQL Server 2008 Transaction Replications for 2 databases evolving only five tiny tables, the bigger has no more than 400 records. The replications are working perfectly and the respective jobs are programmed as “start when the agent starts”.
Looking the SQL Check process box, I can see both replications represented by 2 red bubbles. Why is that? Does SQL Check classify replications as dangerous processes or is it warning me about something going wrong?
Thanks and regards,
I’d expect the bubble simply to be an indicator that it’s an active process using CPU. The size/growth of the bubble would be a stronger indicator of a performance issue. As the process uses more and more resources its size will grow relative to the other sessions shown in their own bubbles.