you are correct its 64 bit.....so since I can not lock pages in memory one of the work arounds is to set max/min memory.

So I set it ..sp_configure 'max server...

wish I could George, that would most likely solve my problem.....but you can not lock pages in memory on standard edition......only enterprise....microsoft is looking at this issues know....who knows it...

standard edition, this is not possible, only on Enterprise.

yes I have had similar problem in the past, you more than likely need to uninstall the .net framework. my guess is its the 32 bit version and you need...

Still looking for some answers on this? anyone figure it out?

slavao should be able to help you out

http://blogs.msdn.com/slavao/

check your permon and look for target vs total. Target memory is amount of memory sql server can use while Total memory is amount of memory sql server is using.

sql...

all depends on the amount of traffic you are getting...the big thing is its not going to hurt it!! it will allow the SQL OS to be a little...

one important thing if you are going to be using temp tables make sure your temp DB is on it own spindle.

With that said make sure you create one...

hi there , few things ...there is misleading thing on memory setting so to be safe please read the following

please read this article from Slava...

http://blogs.msdn.com/slavao/archive/2006/11/13/q-a-does-sql-server-always-respond-to-memory-pressure.aspx

http://blogs.msdn.com/slavao/archive/2005/04/29/413425.aspx

4 gig is a very small...

please check Slava's post on the 64 bit and AWE, according to him it is still used

http://blogs.msdn.com/slavao/archive/2005/04/29/413425.aspx

please see Slava's post....Microsoft does recommend it be turned on! this only goes for enterprise addition.

http://blogs.msdn.com/slavao/archive/2005/04/29/413425.aspx

others that will help

http://blogs.msdn.com/slavao/archive/2006/11/13/q-a-does-sql-server-always-respond-to-memory-pressure.aspx

http://blogs.msdn.com/slavao/archive/2005/08/31/458545.aspx

see this post for standard edition

http://sqlblogcasts.com/blogs/grumpyolddba/archive/2008/01/06/configuring-windows-2003-x64-for-sql-server.aspx

good luck!

Hi there,

SQL is always going to grab as much memory as it can. The SQL OS Buffer pool will grab as much as possible, it will then page out...

Thanks guys....good to know I was in the right direction!

found the problem, I had left the duration on 15 secs I needed to set it to 1 sec.....and then WORKS