.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

sql 2000 sp4 said correct the memory leak issue but didn't see in the fixlist,can anyone explain?

Posted By:      Posted Date: October 04, 2010    Points: 0   Category :Sql Server


says this bug was first corrected in sp4, but when go http://support.microsoft.com/kb/888799/ cannot find the bug on the fix list, any one can explain?


View Complete Post

More Related Resource Links

sql 2000 Ent memory issue

sql 2000 ent frequently get insufficient memory error when backing up on tlog or do a bulk import, even now increased to 8GB from original 2GB. After restart sql server service, then able to run bulk import, noticed buffer increased around 260MB. of cause tlog can be backup too after sql restart. Don't have any clue now, can someone give some advice or hint? OS is w2k3 Ent 32bit.  

Workflow Designer 4.0 Load() Performance Issue: possible memory leak?


Hello everybody,

I am trying to implement a workflow designer in a windows form application and use the same designer to view different workflows. However, I found the program became slower and slower after loading several workflows.

my steps are as follows:

1. create a wpf user control WFDesigner to package the workflowdesigner;

2. In the user control  WFDesigner , implement a InitiateDesigner method which create a new workflowDesigner instance each time called. I suppose the old workflowDesigner instance would be collected by GC;

3. create a winform application and install the user control created on step 2 to an element host, and put the element host on the form. 

4. add two buttons for test: one will execute  WFDesigner.InitiateDesigner() once and the other will execute it 100 times.

Memory leak?


I’m not sure how I should consider my problem. I’m developing workflow with VS 2008 for MOSS 2007. I’ve created simple method which remove security group “MyGroup” from the item. And it seems that it works:

private void UsunDziedziczenieUprawnien_ExecuteCode(object sender, EventArgs e)


            using (SPSite site = new SPSite (workflowProperties.SiteId))

WmiPrvSE.exe causes a huge memory leak in SQL server 2008 R2, why?

My OS is windows server 2008 r2 data center 64 bit and my SQL server is server 2008 R2. The problem is when I open sql server, the WmiPrvSE.exe process consumes 20 - 60kbs every second. Several hours later, it eats up at least 200mbs memorry and this process seems like it will never stop. Can any experts give me some ideas to fit this mess? PS: My mainboard is Asus striker II formular, cpu is intel quad-core. Also, all my software are updated to latest version.

Memory Management issue while calling COM method from .Net component

Hi all,  The Com Component Method say(GetChildresponse) requires Byte pointer as input. From .Net Component, while calling GetChildResponse  I am creating IntPtr and passing it to Component.  I am only creating the pointer in my .Net Component but allocation of bytes(CoTaskMemAlloc) happens at COM Method. After populating the pointer buffer, I am transferring to memory buffer in .Net method and Free the memorry of the pointer using "Marshal.FreeCoTaskMem" method.  Still I am not sure, whether it is deallocating the memory since the Garbarge collector wont happen immediately.  We are hitting on performance issue while doing load testing and we suspect this might be due to memory allocation that is not getting deallocated properly. Any pointers would be helpful. Thanks, Nithya Sample Code: unsafe {   // Get the physical memory address ocpHeaderBufferPointer = new IntPtr((void*)&ocpHeaderBufferPointer); temporaryResponseBufferPointer = new IntPtr((void*)&temporaryResponseBufferPointer); }   try {   try {   // Call the GetResponse of the pass through ocpChannel   new OCPChannelDSClass().GetResponse((uint)transactionId, ocpHeaderBufferPointer, out ocpHeaderBufferSize, temporaryResponseBufferPointer, out temporaryResponseBufferSize, (uint)timeout); }   catch (Exception ex) { &nbs

SSAS DB migation issue from SQL 2000 to SQL 2008

While  running migration wizard  to migrate sql 2000 Analysys service DB from 2000 to  2008  Validation step  failing with  datatype mismatch.Please assist me here

Can anyone explain how SQL Server performance scales with CPUs/Cores, memory, disk drives, etc?

I have experienced the situation where our application running on an expensive system with two 4 core CPUs ran slower than on a cheap machine with one dual core CPU. Both machines had similar memory capacity. In each case, the same query was being run by only one user. It would be nice to find a way to increase performance, but if adding cores doesn't help, what can a poor developer do? Customers get annoyed when they spend a truckload of money on a new server and nothing changes... Another potential problem is when customers have an expensive SAN system Sometimes the performance is much slower then on a system with conventional storage. Can anyone explain the relationship between SQL Server perfomance and hardware ?

Memory leak on binding to a WPF TreeView

We're having an issue with a TreeView hanging onto a viewmodel set that has been bound to it. We have a static treeview on the main window, and reset its ItemsSource to Nothing or a new viewmodel when new things need to be displayed. The problem seems to be that it's hanging onto the first item that it was bound to, even after the ItemsSource is set to nothing. The connection seems to be through some strange unknown binding that's in the EffectiveValues collection of the TreeView.   I was able to repro this in a test project, so I'll post the simplified code:   TreeView templates:   <Window.Resources> <HierarchicalDataTemplate DataType="{x:Type local:ParentViewModel}" ItemsSource="{Binding ChildVMs}"> <TextBlock Text="{Binding Name}"/> </HierarchicalDataTemplate> <DataTemplate DataType="{x:Type local:ChildViewModel}"> <TextBlock Text="{Binding Name}"/> </DataTemplate> </Window.Resources>   ViewModel definitions: (Shared Function to generate the itemssource for the treeview)   Public Class ParentViewModel Public Shared counter As Integer = 0 Public Shared Function GenerateViewModel() As List(Of ParentViewModel) Dim pvm As New ParentViewModel With {.Name = "Parent" & counter} ' Unique name pvm.ChildV

InteropBitmap memory leak

Goal : Create a scrolling wave form that has a low overhead (WPF) Challenges : Huge bitmaps are not accepted by Image.Source Smaller (but still very big bitmaps) are accepted but overall UX is terrible. Memory conservation Scrolling must be at 60fps Problems encountered : Used GPU memory amount is insane ! (400 to 800 Mb each 10 seconds) So here's what I did : I am rendering that bitmap through an Image.Source that I created with Imaging.CreateBitmapSourceFromMemorySection (which type is InteropBitmap). I have loaded that big bitmap in memory and every time I need to update, I do a CopyMemory then I do InteropBitmap.Invalidate(), so far it's perfect and performance is excellent. That particular type of BitmapSource is said to be the fastest, and it is actually; but after some profiling, it litterally eats GPU memory, as said above. It seems that InteropBitmap never recycles GPU memory, or caches it, I don't know... On my Win7 x64 machine, I have 4Gb of which up to 1.5Gb can be used by the GPU. (Laptop is a Thinkpad T61p with dual-core at 2.5Ghz and a Quadro FX570M with 256Mb) My first and safer solution was to use a WriteableBitmap which works good but no 60 fps here, What do you suggest ? Shall I go WinForms for required performance ?   Thanks for your help !

Permission issue - users not seeing correct master page and css


I have started playing with permission and created a whole that I can not climb out of! Any help will be great!!! Here are my issues:

1. (this one started it all) I added an approval workflow to a library with the thought that a doc would not show to the public until it is approved. Ain't happening...what do I have to do for this process to work?

2. In trying to solve the above I restricted nt auth to the visitors group and then made that group read only. Now members of the visitor group only sees the old master page and css. The only way to fix it so far is to add nt auth to the owners group. that won't fly.


Issue - A significant part of sql server memory has been paged out.


Hello Experts,

I am running a huge SSRS 2008 report and it gets rendered sometimes and sometimes it gives me an error,

"The report execution has expired or cannot be found. (rsExecutionNotFound)”.

When I see SQL Server log after this issue comes I see following message there;

"A significant part of sql server memory has been paged out. This may result in performance degradation. Duration: 300 seconds. Working set(KB): 97672, memory utilization 42%"

Please help me to know what is the issue and how to fix it.


SharePoint memory leak (8l1n)

hi , I'm annoied with the memory leak problem these days. the following text is copied from the ULS log. Does anyone can read this?  or pick up some clues out of it?

it's high appreciate for your help!

8l1n High     An SPRequest object was not disposed before the end of this thread.  To avoid wasting system resources, dispose of this object or its parent (such as an SPSite or SPWeb) as soon as you are done using it.  This object will now be disposed.  Allocation Id: {BE9269D2-BE0D-4A94-BBD9-71FD642892F2}  This SPRequest was allocated at    at Microsoft.SharePoint.Library.SPRequest..ctor()     at Microsoft.SharePoint.SPGlobal.CreateSPRequestAndSetIdentity(Boolean bNotGlobalAdminCode, String strUrl, Boolean bNotAddToContext, Byte[] UserToken, String userName, Boolean bIgnoreTokenTimeout, Boolean bAsAnonymous)     at Microsoft.SharePoint.SPWeb.InitializeSPRequest()     at Microsoft.SharePoint.SPWeb.EnsureSPRequest()     at Microsoft.SharePoint.SPWeb.get_Request()     at Microsoft.SharePoint.SPListCollect... 
09/21/2009 13:16:35.11* w3wp.exe (0x1780)                        0x13D0 Windows SharePoint Services    General                        8l1n High     ...ion.EnsureListsData(Guid webId, String strListName)     at Microsoft.SharePoint.SPListCollection.EnsureListsData(String strListName)     at Microsoft.SharePoint.SPListCollection.ItemByInternalName(Strin

how to free something to increase available Virtual memory sql 2000


MemoryLoad = 60%         
Total Physical = 6141 MB  
Available Physical = 2428 MB                       
Total Page File = 8006 MB 
Available Page File = 3630 MB                      
Total Virtual = 2047 MB   
Available Virtual = 6 MB 

the reason for failure backup, connection is virtual address space run out, see the available virtual is 6MB, is this something to do with, if so can it be increased by freeing something instead of restart the sql?

VS 2010 memory leak?


It happens frequently when I try to copy & paste code inside VS 2010 with following message:

insufficient available memory to meet the expected demands of an operation at this time, possibly due to virtual address space fragmentation. Please try later.

and I check the memory usage with taskmanager on my computer. It is fine.

In order fix it, I need to close VS 2010 and restart again.

So is it a memory leak or can be fixed in some way?

ResXResourceReader memory leak?


I have occasion in my program to compile some CSharp code on the fly, with embedded resources from a .resx file. To do this, I use a System.Resources.ResXResourceReader to read the ResX file and a System.Resources.ResourceWriter to create the binary resource file. However, when I step through the code, I find that ~15MB of memory gets taken up when the ResXResourceReader reaches a Node whose value is a Bitmap, and that memory doesn't get freed even if I explicitly dispose the Bitmap. The ResXResourceReader is getting disposed (it's declared in a using statement). How can I keep this memory leak from happening? Here's the code where I read through the ResX file:


using (System.Resources.ResourceWriter Writer = new System.Resources.ResourceWriter(FileName = System.IO.Path.GetTempPath() + ClassName + ".resources"))

using (ResXResourceReader ResXReader = new ResXResourceReader(this.ResourceFileName))
                foreach (System.Collections.DictionaryEntry Node in ResXReader)

SQL Server 2000 is getting very slow, memory usage also very high but restarted db service it comes



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





Memory issue vith SQL2008 SP2 on a 64 bits W2008


Hi to all !

Sometimes, my production system crashes, and a "memory status" is displayed in my errorlog.

I suspect that a stored procedure could be responsible...

Is anybody can tell me what pool is concerned by the issue ?

There is no message before the memory status, and just after it, i have :

2010-10-27 16:40:26.46 spid117     Error: 701, Severity: 17, State: 123.
2010-10-27 16:40:26.46 spid117     There is insufficient system memory in resource pool 'internal' to run this query.

Thanks for help !



Memory Manager                                   KB
---------------------------------------- ----------
VM Reserved                                 4311480
VM Committed                                4287208
Locked Pages Allocated    
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend