May 2, 2011 at 8:56 am
I'm betting the answer is yes, but my quick scan doesn't produce a definite answer:
Does Replication use memory outside the SQL Server allocation?
If so, anyone know roughly how much? (Scenario in question is nightly snapshot replication of roughly 75 GB of data. (and before any other comments, it must be nightly snapshot - transactional and merge replication won't work for lots of reasons)
Based on some outside indicators I'm suspecting we may need to reconfig the server memory allocation a bit.
Thanks.
May 2, 2011 at 11:03 am
There is a snapshot.exe that is launched on the distribution server when the snapshot agent is running. You will want to monitor that process for memory usage during your nightly run to get an idea of what the resource requirements are.
I will say though that if you think that you are starving SQL or the OS when a replication agent starts up then I would suggest lowering max server memory for your instance. Are you running 32-Bit or 64? What is your memory configuration for SQL and how much does the box have?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 2, 2011 at 11:28 am
Dedicated SQL Server box replicating to dedicated SQL Server box. Both on VM, both 32-bit.
Publisher/distribution server has 8 GB max configured in VM, 6 GB max server memory in SQL Server (2 min). Subscription server is allocated 14 GB max in VM, max sql server memory of 12 GB, min of 2 GB. The two share a VM resource pool with 19.something GB reserved, 2.something GB shared (the actual amounts vary), 22 GB reserved.
NOTE: This is NOT my configuration. I had to fight tooth and nail (and show him several memory-related crashes/errors) just to get it to this point as my IT admin is convinced that shared memory is an OK thing.
I am getting memory warnings on my monitor tool precisely when the replication process is running so I'm certain that's the issue and that we need to reconfigure the memory. Just wanted some independent confirmation that there were outside processes to be considered.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply