Memory full SQL SERVER 2008

Question

Memory full SQL SERVER 2008

Helical Johan

Ten Centuries

Points: 1033
More actions
July 8, 2011 at 4:48 pm

#239409

Hi,
I have sql server 2008 in windows server 2008, together 32 bits. The problem is
in the memory. It´s full. I enabled the option: Use AWE to allocate memory.
But, this problem persist.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 1

How much physical Memory do you have on the machine and what is the MaxServerMem Set to?

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Jody.WP Mr or Mrs. 500 Points: 518 More actions · Answer 2

Hi ,

Of the total physical memory in the server , how much is SQL set to use?

Regards

Jody

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 3

Suggested Max Memory Settings for SQL Server 2005/2008

http://www.sqlservercentral.com/blogs/glennberry/archive/2009/10/29/suggested-max-memory-settings-for-sql-server-2005_2F00_2008.aspx

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Perry Whittle SSC Guru Points: 234013 More actions · Answer 4

Helical Johan (7/8/2011)
Hi,
I have sql server 2008 in windows server 2008, together 32 bits. The problem is
in the memory. It´s full. I enabled the option: Use AWE to allocate memory.
But, this problem persist.

have you set the local security policy "lock pages in memory" for the SQL Server service account (requires a reboot)

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

Helical Johan Ten Centuries Points: 1033 More actions · Answer 5

Hi,

The machine memory is 4.00 GB, and maximun server memory is 3000 MB

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 6

Helical Johan (7/11/2011)
Hi,
The machine memory is 4.00 GB, and maximun server memory is 3000 MB

It's getting kinda late but could you please elaborate on that?

Thanks!

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/