View Complete Post
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?
just wondering how do you handle similar situation, we had a call from angry client saying they are unable to do anything and things take too long to complete. when i logged in i noticed that sql server taking all memory (6GB) for some reason. interestingly
CPU usage is normal.
I know i can run profiler to see what queries are taking such huge memory before it happens but what if it already happened and you want to see whats currently eating all that memory ? thanks for the advise.
sql server is 2008 and our desktop app is C# 2008.
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
My name is Johnathan and I work as an asp.net web devoloper.
My company is starting to transfer from classic asp to asp.net 4.0 in our websites. During the transition I have encountred a few issues:
Thanks alot and have a nice day!
I am posting this in the .NET Framework inside SQL Server forum as I assume the issue is related to CLR / SQL Server. Please let me know if this is the incorrect forum.
I am receiving the following error in the event log:
AppDomain [DB_NAME].dbo[runtime].5253 was unloaded by escalation policy to ensure the consistency of your application. Out of memory happened while accessing a critical resource.
System.Threading.ThreadAbortException: Exception of type 'System.Threading.ThreadAbortException' was thrown.
The system that this is occurring on is a Windows Server 2003 R2 SP2 (32 bit), SQL Server 2005 SP2 with 8 GB of RAM:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
9.00.3042.00 SP2 Standard Edition
The CLR assembly is relatively simple and is referenced by both store procedures as well as by a table trigger (update). Essentially the CLR assembly instantiates an object (in a referenced webservice on a separate&
I am facing slow down problem in SQL Server 2000. SQL Server is very very slow during that time memory also very high usage but when I restart SQL Service it comes to normal. Please advice, if anyone who has experienced in this type of situation. Appreciate
if you help to resolve this problem. Thanks
What is the usage of Row Guid under SQL Server 2005? It seems not much information state the main purpose of it?
in one of our SiteCollections we cannot start den Usage Report. It says "Server Out of Memory". We have lot of SiteCollections and it happens only in this one. Fyi: We have 16GB RAM.
Any Ideas? Thanks alot..
this is ram,
I am new to the reporting services,just one month back i joined in the company.there i got trained in ssrs 2005 .
nd my pblm is i inserted one of the csv file into the sql server 2005,it contains 102866 records,nd then i started generating summarized record through sql server 2005 reporting services.when i started generating the reports with few columns i didnt get
any pblm,but when i started including more columns with aggregate functions i am getting the ecxeption called
system out of memory exception.and by google search i found some solutions like enabling the AWE,but still i am getting the same exception
my server configuration is
64 bit windows server 2003,
SQL SERVER 2005 STANDARD EDITION
PLEASE HELP ME OUT IN RESOLVING THIS ISSUE,I WILL BE VERY THANKFUL TO YOU,
THANKS IN ADVANCE.
I want to find out how to get memory information from SQL Server using DMVs that will equal to or be very close to the memory shown in Mem Usage column of Windows Task Manager for sqlservr.exe. I have tried to sum
single_pages_kb, multi_pages_kb, and virtual_memory_committed_kb from sys.dm_os_memory_clerks but the combined total is still less than the Mem Usage from Windows Task Manager.
i would like to ask what the difference between sql server 2000 and 2005