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


Top 5 Contributors of the Month
david stephan
Santhakumar Munuswamy
Asad Ali
Fauzul Azmi
Post New Web Links

90% of used physical memory missing

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

I am running Analysis Services 2008 R2 on a Windows 2008 x64 SP2 box with 32 GB Ram

After the server has been running for a few hours Resource Monitor displays 99% used Physical Memory

However when I look at processes I can see msmdsrv.exe consuming around 3.8GB (Committed 3.8 GB , Working Set 3.6GB) and no other process consuming mor than 100kb. The total process barely consume more than 4GB of Ram so I am trying to see where the remaining 28GB is going

Some other posts with similar sounding problems indicated this may be due to SQL Server allocating memory from AWE but this issue occurs without SQL Server being started.

I have checked the various SSAS perfmon counters but these show a similar picture.

Is there someway to see where memory is being used?

Thanks

Patrick

 

 

 




View Complete Post


More Related Resource Links

SQL Server 2008 R2 on Window Server 2008 Physical Memory keep growing

  

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?

Thank you

Armine Bell


How to derive actual physical memory consumption by a process?

  

Hello,

I am doing performance analysis of SSRS reports (2008).

Before doing anything, I check in Task Manager(Performance tab) and see that my overall physical memory which is 8GB, is already divided between available memory and system cache. I have also setup perfmon counters and logging data for available memory counter.

Now when I launch a huge report with 2 million records, it starts consuming the available memory and I notice in Task Manager(Performance tab) the available memory is reducing BUT I also notice that the system cache is also reducing (I assume that perhaps OS is borrowing memory from system cache to put it in available memory?) If my assumption is correct, then I would not be able to calculate how much physical memory my report used because it also includes a portion of system cache(?)

OR is the system cache reducing due to disk I/O?

This is getting confusing for me, please help me out experts.

Regards.

 

 


How to derive actual physical memory consumption by a process?

  

Hello,

I am doing performance analysis of SSRS reports (2008).

Before doing anything, I check in Task Manager(Performance tab) and see that my overall physical memory which is 8GB, is already divided between available memory and system cache. I have also setup perfmon counters and logging data for available memory counter.

Now when I launch a huge report with 2 million records, it starts consuming the available memory and I notice in Task Manager(Performance tab) the available memory is reducing BUT I also notice that the system cache is also reducing (I assume that perhaps OS is borrowing memory from system cache to put it in available memory?) If my assumption is correct, then I would not be able to calculate how much physical memory my report used because it also includes a portion of system cache(?)

OR is the system cache reducing due to disk I/O?

This is getting confusing for me, please help me out experts.

Regards.

 

 


How to write memory stream to a physical path

  

Hello I have the  a stream called mstream that I would like to right to a physical path.  How would I do it. 

This is my approach

 byte[] buffers = mStream.ToArray();


        using (FileStream fs = new FileStream(filePath + "emailAttachments\\calendar" + usersession + ".ics", FileMode.CreateNew))
        {
            foreach (byte[] buffer in buffers)
            {
                fs.Write(buffer, 0, buffer.Length);
            }
        }

But I'm gettin an error cannot  covert byte[] to byte.  Please assist.  Thanks.


SharePoint Tutorial -SharePoint Physical Architecture

  
The SharePoint physical architecture consists of services running on one or more servers.

Services
There are three types of services that together run the SharePoint farm: web, application and database services. Web services through Internet Information Server is what processes the ASP.Net and sends back the html to a user's browser. Application services is where the "brains" of SharePoint are located. All of the SharePoint specific logic and services are processed there. Database services are run by SQL Server and it's where all the data/content for SharePoint is stored.

How to detect and avoid memory and resources leaks in .NET application

  
Despite what a lot of people believe, it's easy to introduce memory and resources leaks in .NET applications. The Garbage Collector, or GC for close friends, is not a magician who would completely relieve you from taking care of your memory and resources consumption.

I'll explain in this article why memory leaks exist in .NET and how to avoid them. Don't worry, I won't focus here on the inner workings of the garbage collector and other advanced characteristics of memory and resources management in .NET.

Content Query Web Part missing in SharePoint 2010

  
If you don't see content query web part listed in the web parts list, this is because you have not enabled "Search Server Web Parts" feature in site collection features. Enable this feature and content query web part will show in the list of web parts.

Draw lines excactly on physical device pixels

  
When you draw a line in WPF you will experience that they often appear blurry. The reason for this is the antialiasing system that spreads the line over multiple pixels if it doesn't align with physical device pixels.

file upload in chunks or not buffering in memory before writing to disk?

  

What are the options for handling file uploads to reduce the memory footprint?  Is there a way to upload in chunks?  Is there a way to stream upload directly to disk instead of loading entire file in server memory?


Thanks


Missing 'new item templates'

  

 Hi all,

          I am a 'newbie' to VWD and I am slowly working through the Basic Walkthrough Help files, and learning plenty along the way.

However, when I tried to create a new database in the LINQ control walkthrough I found that the option to create a new database is missing, and further investigation has found that many other new item templates are missing.

I am using a brand new machine with Windows 7 Ultimate and have enabled IIS and .NET from Control Panel-Programs-Turn Windows Features On-Off. I used the WPI to install all basic elements eg. IIS Components, SQL Server Express.

The only 'new item templates' I have when I right-click the App_Data Folder and choose 'new item' are:-

ADO.NET Data Service

AJAX Enabled WCF Service

Dynamic Data Field

SQL Server Database

Text File

XML File

Does anyone know where I have gone wrong.

 

Michael J. Hill


Visual Studio 2008 Memory problems

  

My memory in task manager reaches about 900,000K  and I don't know why it does this. Definately slows everything down, especially when I rebuild my tableAdapters, takes about 30 seconds sometimes to rebuild the project.


Crystal Report gives System.AccessViolationException: Attempted to read or write protected memory. T

  

when a crystal report for same id is opened again at same time or refreshed then it gives the

"System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt."


Stack Trace is :-


Stack Trace:

[AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.]
CrystalDecisions.ReportAppServer.Controllers.DatabaseControllerClass.SetConnectionInfos(ConnectionInfos ConnectionInfos) +0
CrystalDecisions.CrystalReports.Engine.Table.ApplyLogOnInfo(TableLogOnInfo logonInfo) +362
CrystalDecisions.CrystalReports.Engine.ReportDocument.SetTableLogon(Tables tables, String user, String password, String server, String database, Boolean ignoreCase) +258
CrystalDecisions.CrystalReports.Engine.ReportDocument.SetDatabaseLogon(String user, String password, String server, String database, Boolean ignoreCase) +204
CrystalDecisions.

Maximum memory for string ? . System.MemoryOutOfException Occurs when reading the Content of the fil

  

Hi,

I have a C++ code which reads a file [vtk file - its similar to text file only]. and try to store it in string.

here's the code:

String^ ParallelProjectionRenderer::GetVolumeDataAsString(String^ FileName)

{
    vtkSmartPointer<vtkDataSetWriter> sWriter = vtkSmartPointer<vtkDataSetWriter>::New();

    String^ FileName = "D:\\Users\\...";

    char * sptName = static_cast<char *>(Marshal::StringToHGlobalAnsi(FileName).ToPointer());

    sWriter->SetFileName(sptName);

    sWriter->Register(nullptr);

    sWriter->SetInput(this->dataSource);

    sWriter->SetFileTypeToASCII();

    sWriter->Write();

    sWriter->Delete();

    String^ result= File::ReadAllText(FileName);   [it breaks here with system.memoryoutofexception when the file size is huge]

    return result;

}

this code executes fine when the file size is less than 8mb.

I wanted to know whats the maximum memory allocated to the string.


As a workaround i skipped reading out in C++ code. and i tried to read the file contents in asp.net C# code and stor

Tools for memory error check in VS2005

  

Dear all,

I am going to write vs2005 program with ASP.NET and C++.

As you know that C++ will involve a lot of memory error handling.

Do you know is there any tools for checking memory error in Code Behind C++??


CLR Inside Out: Memory Usage Auditing For .NET Applications

  

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


Debug Leaky Apps: Identify And Prevent Memory Leaks In Managed Code

  

When is the .NET Garbage Collector unable to reclaim memory? The answer might surprise you. Stay tuned.

James Kovacs

MSDN Magazine January 2007


CLR Inside Out: Investigating Memory Issues

  

Memory issues can manifest in a wide variety of ways. This column shows you how to collect the data you need to determine what types of mem¬ory issues you are experiencing.

Claudio Caldato and Maoni Stephens

MSDN Magazine November 2006


Categories: 
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