This place rocks... I ask for help and I get tons of help. This is the second time I asked for help here and both the times I was pointed...

Paul, I will keep an eye out on that figure. I hope it does not grow out of hand pretty quickly. One good thing is that we do not see...

george sibbald (1/12/2011)

---

have you used sysmon to track memory usage by process? Use private bytes and working set counters for all instances under the process object.

If you see an instance...

sqlbuddy123 (1/12/2011)

---

What is the Size of the Page File ?

Try to disable any unnecassary or unused windows services on the server and see it it frees up some memory on...

Paul, The system_cache_kb is currently 593464. Unfortunately all the memory counters are kind of useless since I did a controlled reboot of the Server.

Hi Jeffrey,

The max memory setting is 226304. We set it at 221 GB leaving 35 GB for the OS.

Michael Valentine Jones (1/12/2011)

---

The high memory usage sounds like a good thing to me, because it means SQL is able to use it.

What do the Performance Monitor counters show for...

Tom.Thomson (1/12/2011)

---

I think it does, but that still implies a gradual increase because it never...

Paging seems low. But it is just knocking me off my mind that 34 GB could be used in such a short time. As per Microsoft, the available should not...

Gus, That server runs only SQL Server. No other applications are in that box. We used performance monitor to find out about the health of the Server. The memory is...

Hey people who hang out here and people who walk by here....:-) I would like to hear your advice regarding this issue I am facing please.

Yes yes... Sorry. Typing fast and not reading before you post will give you embarrassing moments.. 🙂

You can set up snapshot replication with Script or by just using the GUI. It is easy to use the GUI.

Even if you have a script, you cannot use...

Make sure the distribution server runs on SQL Server 2008 that has SQL Server agent running in it. You cannot use the Express (Your subscriber) to act as distributor. The...

Too bad for you Steve...:-) You got one more vote.