Elliot,

I will take your advice and let you know how it works out for me.

Thanks again !!

Thanks for the explanation. It is just a red flag to me to see a server consume 16plus gigs in one day when the previous server which was 32...

Elliot, My previous server was a Windows 2003 enterprise server 32 bit with 32 gigs of RAM and it would take a full 5 days for this server to...

Other than locking the pages in memory and setting the max amount of ram consumption in SQL are there any other memory tweaks that anyone is aware of for a...

Yes it did copy over the master. I know on a 64 bit system enabling AWE is worthless so I unchecked that after the server was brought online and...

When I do a sp_configure it does not list out the max in memory Can someone give me the command so I can see if I already have it...

Can you please provide me the procedure to do this?

Ok, I do not think this is my issue but it is good to know.

Thanks again for all your information!

How can I determine if any queries are waiting on CMEMTHREAD? Is there a command I can run to see this? If yes can you please let me...

Here is the results after running that command on my server.

2.687500

Is this high enough to cause an issue. I have 32gig of RAM on the server and I allow...

OK I was able to get the TSQL command to work but what can I run to see the current consumed memory that is cached?

Can you please type out the command for me seeing I get a syntax error when trying it on a test server I have? Also what command can I...

I will look into this. Is this the command that needs to be issued when I am having the issue?

(DBCC FREESYSTEMCACHE (‘TokenAndPermUserStore’))

If yes then what exactly will...

Thank you Cindy........I believe you are on the right track. All my research has pointed me to what you have explained.

Thanks again for the Info.

Thanks for the response but all the links I find tell me to first install the SP3 on the Active node and the SP3 software is Cluster aware so it...