colin.Leversuch-Roberts (8/16/2011)

---

1. push don't pull file copies - e.g copy to and not copy from.

2. I always use robocopy

3. make sure the server advanced settings it optimised for programs and...

Hi All,

Problem has been resolved. The problem was with the memory allocation by the VM host. Even though there is 8GB assigned to the server the limit was...

slanky2 (8/11/2011)

---

Another question:

I have SQL Engine, SSIS, SSRS and SQLAgent all using the same domain account which has the lock pages in memory security setting. Is this good or...

Another question:

I have SQL Engine, SSIS, SSRS and SQLAgent all using the same domain account which has the lock pages in memory security setting. Is this good or bad...

GilaMonster (8/11/2011)

---

As I've said repeatedly, it's not the queries. The buffer pool (which includes the data cache, plan cache and memory grants for queries) is limited by the server max...

Hi Gila,

Anymore suggestions? I'm stumped. Thanks for your help!

I am using Idera SQL Diagnostics Manager to monitor the server and can see that SQL never uses the full amount allocated to it, but it does appear to use...

GilaMonster (8/11/2011)

---

slanky2 (8/11/2011)

---

Hi Gail,

That was what I thought. Since I set the max memory to use then queries shouldn't use anymore than that.

I ran

sp_configure 'min server memory', 1024

RECONFIGURE

GO

sp_configure 'max...

Hi Gail,

That was what I thought. Since I set the max memory to use then queries shouldn't use anymore than that.

I ran

sp_configure 'min server memory', 1024

RECONFIGURE

GO

sp_configure 'max server memory',...

As a test I just ran a query to select * records from a table with over a million records in it and the memory usage spiked to maximum (8GB)....

Thanks for the reply.

I don't see any oher process that would be using all of this RAM.

At the moment Task Manager is stating that over 7GB of RAM...

Did you ever find a solution to your problem? I am having the same problem. I have about 20 databases on the server. They all backup fine...

When I stopped and restarted the SQLAgent it worked fine. Weird!

It would be great if I could see the script.

It would be great if you could send me the script. Could the script also contain code to remove filed that are older than 4 days?