sql server - distribution.dbo.MSdistribution_history comments explanation -


the comment column of distributor.dbo.msdistribution_history contains comments such as

<stats state="2" fetch="11554" wait="214007" cmds="17898546" callstogetreplcmds="106880">     <sincelaststats elapsedtime="300" fetch="8" wait="291" cmds="1948689" cmdspersec="6495.000000" /> </stats>

the state value translates 

state   indication 1       normal log 2       reader thread has wait writer 3       writer thread has wait reader

is comment telling me reader thread waiting writer thread has read 1948689 cmds since last stats entry. or telling me reader thread waiting writer thread , writer thread has written 1948689 cmds since last stats entry?

http://social.msdn.microsoft.com/forums/en-us/sqlreplication/thread/0b8bac44-da87-4115-90f6-b8bf1e1d0bd8

both cmd values relate number of commands written. since last stats - cmds cmds written since last entry , stats- cmd accumulation of cmds written since last comment state of 1.


Comments

Post a Comment

Popular posts from this blog

c# - Operator '==' incompatible with operand types 'Guid' and 'Guid' using DynamicExpression.ParseLambda<T, bool> -

i'm using dynamic linq library , there source code , basic docu , nuget version pm> install-package dynamiclinq i'm trying construct clause involves guids i have tried string "id == @0" . parameter array object[] value ( guid xxxx ) var whereclausesb = buildlogicalkeywhereclause2(entity, logicalkey); //build string var parms = buildparamarray(entity, logicalkey); // object[] var wherelambda = ofsi.bos.core.dynamicexpression.parselambda<t, bool>(whereclausesb.tostring(),parms); //parse an exception thrown in dynamicexpression.parselambda operator '==' incompatible operand types 'guid' , 'guid' i have tried guid , string.(fail) i tried , "id = @0" (fail). string == string works, int32==int32 not guid == guid not any ideas? try using equals method instead of == operator in string: "id.equals(@0)"
Read more