Thanks for the response,

I think I will give that a try. I believe it to be a PerfMon issue rather than a problem with SQL.

For now, I have set PerfMon...

Hi all,

It seems that this case isn't quite solved.

The server now have 12GB of RAM in it and I assigned a "max server memory (MB)" of 8000.

I have been monitoring...

Hi all,

Many thanks for all of your input.

Over the weekend we added an additional 8GB RAM to the server and increased the SQL max memory setting to 8000 MB.

The server...

Many thanks for your prompt reply.

Please let me know if you need more information.

1. Your Windows version.

Windows Server 2008

2. Windows...is it 32-bit or 64-bit?

64-bit

3. Your SQL Server version.

SQL Server 2008...

Many thanks for taking the time to reply.

I am - as it happens - currently reading your book on performance tuning as I was looking for some inspiration :-).

I...

I was afraid you might say that.

As this is an out of the box...

Not necessarily. IO is not the only thing that slows a query down. Could be blocking or other waits. Could be pure CPU time. That said, the slower query...

Thanks for your reply,

In that case I'm not sure why the same query would generate significantly more reads from the buffer pool.

I would have thought more reads from buffer pool...

Thanks for this Anthony.

Hopefully this answers the OPs question although I haven't had a chance to try it myself.

I'll post my PLE question separately as it is more of a...

Just to follow up on this:

I was given this formula to use although I haven't yet confirmed it is correct:

(CAST (value_in_use AS INT)/1024/4)*300 FROM sys.configurations WHERE NAME = 'max server...

Sorry to bump this post, but I too am looking for a means of determining our "DataCacheSizeInGB" as per Jonathan Keyayias' article.

http://sqlskills.com/blogs/jonathan/post/Finding-what-queries-in-the-plan-cache-use-a-specific-index.aspx

As an "accidental DB" it would be great if...