Our SQL 2005 database server appears to have a memory leak, where RAM usage creeping up quite fast. How do we determine which database is using the memory or what else is?
Any help much appreciated!
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?
I just virtualized(vmware) both front and backend server for Sharepoint 2007 . The issue I'm having is that my Sharepoint Site Usage pages are no longer showing results.
I tried giving WSS_ADMIN_WPG ans WSS_WPG Full control of the logs folder but still no luck.C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\LOGS
I noticed the following 2 event id errors on my front end server
Source: Office Sharepoint Server
Event ID 7888
runtime exception was detected. Details follow.
Message: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
System.UnauthorizedAccessException: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
at Microsoft.SharePoint.SPGlobal.HandleUnauthorizedAccessException(UnauthorizedAccessException ex)
at Microsoft.SharePoint.Library.SPRequest.CrossListQuery(String bstrUrl, String bstrXmlWebs, String bstrXmlLists, String bstrXmlQuery, ISP2DSafeArrayWriter pCallback, Object& pvarColumns)
at Microsoft.SharePoint.SPWeb.GetSiteData(SPSiteDataQuery query)
at Microsoft.SharePoint.Publishing.CrossListQueryCache.GetSiteData(CachedArea cachedArea, SPWeb web, SPSiteDataQuery query)
For more information, see Help and Support Center at
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 utilize SSIS extensively to process data feeds and when those files become large, we find the resources on the SQL are pretty well depleted. That in turns causes the application, whcih is connected to that same SQL Server, to suffer from
a performance stand point. We have to act on this as the problem will only get worse over time and are considering creating a separate SQL instance for SSIS packages but are also interested if there is anything that can be done now to govern the amount of
resources that any given SSIS package can use, with the understanding that doing so will cause them (the SSIS pkgs) to have a longer execution time.
We are using SQL 2008 Enterprise Edition and have been reviewing the Resource Governor within SQL, but it appears that that tool can not govern SSIS package resources, so the question is can anything perform that task?
Thanks in advance for the feedback.
When I go to ANY database (System, AdventureWorks*, user) in Managemant Studio, I right-click on the db, select Reports, select Standard Reports, and select Disk Usage. The disk usage report shows the correct db on top, but always only shows AdventureWorks_Data.mdf
when I expand Disk Space Used by Data Files section. This happens to any db I try. When I look at Database Properties/Files for that database, the logical and physical file names are correct.
Since the correct files appear in Database Properties/Files, I'm hoping it's just a bug in the report. Same thing happens if I run a Disk Usage by Table report for ANY database, The tables for AdventureWorks always only appear,
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 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
logshiping is configured in our enviroment between SQL2005 SP3 Enterprise edition , we made the online secondary server for testing perpose. now again we have restored the latest full backup (size was 1000gb) into secondary server for maintaining the
logshipping with norecovery mode . everything was fine and both databases is also in sync mode. but i have shrink the log file into promary server and database size reduced to 700Gb then automated backup happened and same backup is restored into secondry srever
but secondry server log file size is still showing 350GB.
plz help us how to reduce the log flle of secondry srever, current status is
Primary server DB size is 750gb (50gb log)
secondary srever Db size 1050gb (350gb log)
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..