April 28, 2011 at 5:36 am
Hi, I enabled the Resource Governor and I'm intrigued by the following situation: My server has 8GB of RAM to enable PAE (because it is a Win 2k3 32bit), Intel Xeon QuadCore 2.0, the server is configured to use 2 GB to 6 GB and when I run the query in sys.dm_resource_governor_resource_pools return shows that Resource Governor is using only 1GB of memory between the pools, according to the attachment!
Anyone have any idea what is occurring is that or am i looking in the wrong way?
April 28, 2011 at 10:22 am
whats the version of SQL Server and did you enable AWE in SQL Server to allocate maximum RAM and lock pages in memory in the LOCAL SECURITY POLICY of OS
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
April 28, 2011 at 1:34 pm
it´s SQL 2K8 Enterprise (32bit) and AWE is enabled and the service account is in local policy!
April 29, 2011 at 12:22 am
Max Memory Set
1024 MB
106 MB
53 MB
53 MB
106 MB
106 MB
53 MB
53 MB
532 MB
Used Memory
14 MB
68 MB
2.4 MB
check this information,you have to change these setting for default
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
April 29, 2011 at 5:03 am
but i can just set max_memory_percent, only percent for use! and how do i change the value column max_memory_kb????
April 29, 2011 at 7:14 am
sp_configure or right click sql server name properties to change default memory settings. Not looking at SQL but i am sure that the place.
whats the version of SQL Server and did you enable AWE in SQL Server to allocate maximum RAM and lock pages in memory in the LOCAL SECURITY POLICY of OS - Do you still do this with SQL 2008 64 bit ?
Just curious.
April 29, 2011 at 7:41 am
TRACEY-320982 (4/29/2011)
sp_configure or right click sql server name properties to change default memory settings. Not looking at SQL but i am sure that the place.whats the version of SQL Server and did you enable AWE in SQL Server to allocate maximum RAM and lock pages in memory in the LOCAL SECURITY POLICY of OS - Do you still do this with SQL 2008 64 bit ?
Just curious.
the version of sql is enterprise!! and i didnt locate this property to set default memory. where is this property?? the other cases cited I have ever done!
April 29, 2011 at 8:41 am
Can you post the results of this query, please?
select * FROM sys.dm_os_performance_counters WHERE object_name like '%Memory Manager%'
April 29, 2011 at 8:49 am
Colleen M. Morrow (4/29/2011)
Can you post the results of this query, please?select * FROM sys.dm_os_performance_counters WHERE object_name like '%Memory Manager%'
follow attachment: dm_os_performance_counters
The strangest fact is that in the Task Manager Performance tab in the memory is allocated in 6.99 Gb!!
April 29, 2011 at 10:15 am
How did you create resource pool, this will change where you create resource pools,that is Resource Governor
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
April 29, 2011 at 12:00 pm
Please take a look at this thread by someone else facing the same issue.
April 29, 2011 at 12:58 pm
http://msdn.microsoft.com/en-us/library/bb933944.aspx
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
May 23, 2011 at 10:16 am
Colleen M. Morrow (4/29/2011)
Please take a look at this thread by someone else facing the same issue.
thanks! i had no choice and i migrated to SQL Server x64 with W2K8 x64!! is now fully functional!!!!
May 23, 2011 at 3:56 pm
good move - don't understand why anyone uses 32 bit any more.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply