Blue shortcut arrow on Replication Monitor

What does a small blue arrow (like a file/folder shortcut) mean on the Repli
cation Monitor? It
shows on Replication Monitor, Publishers, Agents and Distribution Agents.See if this helps:
http://msdn.microsoft.com/library/e...ltools_8o6r.asp
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Shawn Clabough" <shawnc@.uidaho.edu> wrote in message
news:OvtlRu2nFHA.2860@.TK2MSFTNGP15.phx.gbl...
> What does a small blue arrow (like a file/folder shortcut) mean on the
> Replication Monitor? It shows on Replication Monitor, Publishers, Agents
> and Distribution Agents.

Blue shortcut arrow on Replication Monitor

What does a small blue arrow (like a file/folder shortcut) mean on the Replication Monitor? It
shows on Replication Monitor, Publishers, Agents and Distribution Agents.
See if this helps:
http://msdn.microsoft.com/library/en...tools_8o6r.asp
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Shawn Clabough" <shawnc@.uidaho.edu> wrote in message
news:OvtlRu2nFHA.2860@.TK2MSFTNGP15.phx.gbl...
> What does a small blue arrow (like a file/folder shortcut) mean on the
> Replication Monitor? It shows on Replication Monitor, Publishers, Agents
> and Distribution Agents.

Blue shortcut arrow on Replication Monitor

What does a small blue arrow (like a file/folder shortcut) mean on the Replication Monitor? It
shows on Replication Monitor, Publishers, Agents and Distribution Agents.See if this helps:
http://msdn.microsoft.com/library/en-us/replsql/repltools_8o6r.asp
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Shawn Clabough" <shawnc@.uidaho.edu> wrote in message
news:OvtlRu2nFHA.2860@.TK2MSFTNGP15.phx.gbl...
> What does a small blue arrow (like a file/folder shortcut) mean on the
> Replication Monitor? It shows on Replication Monitor, Publishers, Agents
> and Distribution Agents.

Blocking in Distribution Database

I noticed that the distribution agents are blocking themselves in the
distribution database.
It looks like this when i do a sp_who2 spid/blocked By:
80/Not blocked
80/80
80/80
80/80
80/80
Is this normal?
Probably not. Check to see what the process is doing which is doing the
blocking and being blocked. You may need to use DBCC inputbuffer(spid) to do
this. You will get locking when some of the replication agents are running,
and even EM will cause locking. It is also possible that if your server is
really under substaintial load the log reader and distribution agents will
lock themselves.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Jeff B" <JeffB@.discussions.microsoft.com> wrote in message
news:B25E48D1-6AC8-4D59-892C-AA7E92D7A95A@.microsoft.com...
>I noticed that the distribution agents are blocking themselves in the
> distribution database.
> It looks like this when i do a sp_who2 spid/blocked By:
> 80/Not blocked
> 80/80
> 80/80
> 80/80
> 80/80
> Is this normal?