I want to know what should be best memory configuration for SQL Server 2008 R2.
View Complete Post
We are running SQL Server 2008 R2 on on Window Server 2008 (x64).
Once in every 2 weeks we end up restarting the SQL Server, due to Physical Memory keep growing.
Is there a good way to pinpoint the problem what cause this Physical Memory to grow?
We have a situation where one of our customers is running Windows 2003 Enterprise Edition 32bit with 8 GBs of physical RAM. Upgrading to Windows Server 2008 64bit is not an immediate option (although I wish it were). All the documentation about SQL Server
2008 Workgroup edition indicates that the new version will address 4 GBs of memory however it does not distinguish between 32bit vs 64bit.
Previously we have run SQL Workgroup 2005 under Windows 2003 and have applied the /3gb switch in boot.ini to get SQL to recognize the maximum amount of memory possible. Now that we are using SQL 2008 with the /pae switch, do we need to still specify the
/3gb switch or can SQL 2008 32bit actually see more than the 3GBs and address 4? I haven't been able to find any information on this configuration.
We are using SQL Server 2008 x64 SP1 CU8 EE, and we have 32 GB of RAM on the server. We currently have the instance restricted to 14 GB of RAM, the "Lock Pages in Memory" security setting on the service account, and AWE enabled in SQL Server. This server
is part of a 3 node active/active/passive cluster. My question is:
How do I know how much memory sql server is actually using, or if the server is under memory pressure?
We just upgraded to SSAS 2008 64 bit (and windows 2008 R2) a couple of weeks ago and now we have an issue that I can't seem to figure out. Our cubes have not changed at all. Previous to the upgrade we were running server 2003 and SSAS
2005 54 bit.
The issue is over the past week the SSAS servers have decided to take up almost all the memory (about 90%) on the server and render itself useless. It is the SSAS service that is taking up almost all the memory and if I stop other services to
free up some it just takes that up too. So here is a break down of the issue and what I have tried. The issue seems to be happening faster and faster now so I am at a loss currently.
Setup that has issue:
What I have tried
Results of what I have tried so far: memory still hits the 90% within 24 hours so that tells me the changes have done nothing. I don't know what to do. <
I am using Windows Server 2003. I have installed SQL Server 2005 and SQL 2008 R2 version in the machine. The sql server 2008 R2 version has the instance name as SQL2008R2
I am trying to configure "Reporting services Configuration Manager" for the SQL 2008 r2. I gave the machine name and hit the Find button, I am not able to get the Report server instance name.
But when I gave the server name, i am able to browse to the folders page in the Internet explorer. so the server is available . I gave like this in the IE, and I am able to see the page:
In the eventvwr, I found the following errror "The Drive:\Program Files\Microsoft SQL Server\MSRS10_50.SQL2008R2\Reporting Services\ReportServer\RSReportServer.config file failed to load. This error may occur if the XML is not valid. "
How to get the Report server instance name in the configuration manager.
We are facing problem with the high memory usage with SQL Server 2008. 64 bit , standard edition sp2 . 8 GB RAM , 8 processors .
Memory usage keep on growing ..sometimes it will reach to 7.5 GB also .... and its not coming down ..untill we restart the service...
These are the details of DBCC MEMORYSTATUS :: Please suggest how to overcome this problem
Memory Manager KB
VM Reserved 8484792
VM Committed 4220368
Locked Pages Allocated 0
Reserved Memory 1024
Reserved Memory In Use &n
Okay so i have a physical server i am trying to replace with a virtual server. Its doing a large load process every night, about 190GB on one disk.
The VM is:
On vSphere 4.1 ESXi
O/S is Windows Server 2008 R2 Enterprise
SQL version is SQL Server 2008 R2 Enterprise.
Now 20GB of memory
Disks assigned to this virtual are all seperate LUNs except for the O/S which is on a shared LUN which is not busy. So 1 LUN/Datastore per 'disk drive on this SQL virtual. Data/Log/TempDB/Backup are on their own LUNs.
All the recommended exclusions are in place for McAfee on a SQL Server.
ESXi 4.1 Enterprise host is not overcommitted. Has 4 x 6core 2.6Ghz AMD processors. BL685c G6 and 128GB of memory. Almost nothing else is running at the time i am testing this load and host is not overcommited or stressed or anywhere near it.
SQLServer process shows 127,236K Working Set and 130,040K Peak working set and memory Private working set 88,828k and Commit Size of 302,792k.
It seems when i check the memory usage in task manager it doesn't show much. In Windows 2003 X64 in would show the GB being used, like 8GB right in task manager. But i don't see that in Windows 2008 R2 task manager. I downloaded SysInternals and it shows
the memory on the Windows 2008 r2 box as 15Gb of AWE memory. How can this be? The case is th
Am trying to install SQL Server 2008 R2 Express Database with Advanced Services 64-bit on Win7 Enterprise N 64-bit standalone.
Had previously installed SQL 2005 Express with tools, but that has been completely uninstalled and computer restarted.
Have Msoft .NET Framework 4 Client Profile plus Msoft SQL Server native Client currently installed.
Chose download from here (http://www.microsoft.com/express/Database/InstallOptions.aspx) and everything seemed to be running smoothly until during New Installation phase of SQL Server
Installation Center, setup encountered "Attempted to read or write protected memory...Error code 0x84B10001."
Have been searching for solutions, but most are dated back in 2007-2009, and I'm hoping (!) there are some later solutions available. What are my options?
Thanks in advance! ~chornung
I want to talk about one of the most discussed SQL issues. Memory memory management.
I am working on a SQL server 2008 R2 with all the combined DBs of 60GB. User activity is not very high. This is sharepoint DB. Most of the time CPU utilization is not very high but memory is consumed around 98%.
Current memory is 12GB. How can I calculate the memory required on this server.
Hi, I just want to make sure that we setup this server the best way possible as we are moving from a previous box where
performance was affected mainly because of partitioning and SQL memory optimizations.
Dell PowerEdge R710
Windows 2008R2 64bits is installed on Volume 1.
- I would like to know what suggestions you might have for the Initialization of the other 2 volumes (MBR or GPT).
- Any other settings like partition align = 64
- Memory Settings at the OS level.
- Memory Settings on SQL.
- Any other recommendations.
Please I have SQL Server 2000 running on Windows 2003 SP2 (A/P) Cluster,Now we are adding new SQL Server 2008R2 Instance to Cluster.
I want know "Database Engine Domain Group","SQL Server Agent Domain Group" section,can I select excisting SQL Server 2000 Engine Domain group or I required to Configure some thing else.
How to find out "Database Engine Domain Group","SQL Server Agent Domain Group" of excisting SQL Server 2000.
Thanks in Adavnce