Friday, March 9, 2012

p

I am having some issues with my replication server. The sqlservr.exe is running 75-100%. Sometimes it pins up above 95 for more than two minutes. It's eating a ton of memory as well. The only thing the server is used for is to replicate our production server. The distribution database runs on it and the log reader, but thats it!

Dell Poweredge 2950
2003 x64
Xeon 5160 3.00
8.0 gbs of ram

Currently replication is running OK with the processor that high. But it only has about 900 mb of memory available. Does anyone have any ideas why sqlserver.exe needs that much horsepower? I just can't image it is right.

Thanks,ok ok i figured this out. i am kind of a newbie. It was an in house app running huge select statements that was eating up all the CPU. I ran a trace and it was pretty obvious. The replication db also serves as the reporting db. Not a replication issue at all, the cpu is running very low now.

thanks

No comments:

Post a Comment