June 4, 2014 at 4:18 am
HI Experts,
Can you please explain me..
when I execute to find the memory high, the below query..
select * from master..sysprocesses order by CPU desc
*without the status filter
this is what i got:
CPU :127743
Status: sleeping
lastwaittype: MISCELLANEOUS
programn name: Replication-LogReader
cmd: AWAITING COMMAND
Could this be the problem? or should i ignore it since the status is sleeping?
June 4, 2014 at 6:11 am
I assume this is related to your other post in SQL Server 2014 Administration? Please don't cross-post. It would have been useful if you had mentioned that you are running transactional replication in your other post!
Regards
Lempster
June 4, 2014 at 6:53 am
Why do you think that the replication log reader, a process which runs all the time to implement replication, is a problem?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply