View Complete Post
Memory usage can have a direct impact on how fast an application executes and thus is important to optimize. In this article we discuss the basics of memory optimization for .NET programs.
Subramanian Ramaswamy and Vance Morrison
MSDN Magazine June 2009
Developers using .NET often make memory leak tracking a low priority because the common language runtime takes care of garbage collection. What few developers realize, however, is that their objects' lifespans, along with their size and what other objects have been instantiated, all affect how they are cleaned up. Depending on the particular circumstances, these combinations can negatively affect performance, especially over the lifetime of an application. This article presents a way for developers to see memory usage and understand garbage collection using the .NET Profiler API. Along the way, a sample application to demonstrate these principles is built.
MSDN Magazine January 2003
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.
I have a WCF web service and I want to find out a memory profile of the service per message. In other words I want to issue a message service request from a client and after the message is serviced and a response is received I want to find out (preferably
from the client) how that message affected the memory footprint of the service. What tools are readily available? I am aware of several profiling tools from third parties but I want to know how I can integrate the information available through the Performance
Monitor and Task Manager (for example) with the message processed to yield a profile of what each message does to the memory footprint. This could be used as a leak detection (if the memory after is more than the memory before then that message more than likely
has a leak). If the memory statistic was available during the message processing it could be seen that message A consumes alot of peak memory whereas message B consumes relatively little. Ideas?
Is there a way to check the memory usage (consumption) of individual controls on a web form shown in a browser. Like Repeater Control, Multiline Text box etc. The reason is I am putting the repeater control in session and checking the status of controls, based on which I am doing further actions.
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
Hi i am editing a stored procedure using the SSMS (I have SQL Server 2008 SP1 - Windows 2003 Server Standard). At the begining everything is ok, but around of 3 or 4 minutes of work the ssms is becoming to slow, I open the Task Manager and I see
that the process SSMS.exe is using 1.2GB of RAM Memory. I have open just one script (The stored procedure that I'm editing) but the script isnt running only editing. I dont understand that high memory because i'm not retreiving data of any query and im
not running any thing on my ssms. Take a look of my task manager
Other thing: When I minimize the ssms window the smss.exe process come back to a normal RAM memory usage.
Please any help??
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 have a farm where the Cwentral Admin Appool is using a tremendous amount of memory 1GB plus.
Once started it just seems to keep growing even if no activity is on it.
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
I am looking to use httpmodule and achieve the following. Please let me know if I can use httpmodule for the below,
a) One of the windows authentaicated (ie. AD) site I always want the current login to be as "myserver\superadmin". Can I do that with spsecurity by passing SPToken? If I implement the same, will the entire session be on that same login?
b) On another site, I would like only "myserver\superadmin" to access all site but for normal users I would like to block any url that has "_layouts" by redirecting to home page? Is that okay to do with httpmodule considering the performance
please suggest with any examples.