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


Post New Web Links

sqlservr.exe high memory utilization

Posted By:      Posted Date: September 29, 2010    Points: 0   Category :Sql Server
 

We have a new SQL Server 2008 R2 implementation running on a Windows 2008 R2 64-bit virtual server w/ 12GB RAM.

We've moved only 1 database to this system so far and although it is a highly accessed DB, it ran quite nicely on a Windows 2003 32bit system w/ 3 GB RAM and SQL 2000.

After a fresh boot, the memory utilization is practically nil, however it slowly grows over a week until it is nearly maxed out.  The process eating up the memory is sqlservr.exe.

So, why would the memory be so high and why would it grow slowly over time.  (I've been reading a bit on the Address Windowing Extension (AWE) though I'm not sure this is or isn't what we're experiencing.)

Thanks for your help!

Kind Regards,

Dave




View Complete Post


More Related Resource Links

sql server high memory usage

  

Hello Guys

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.


prk

Very Low Procedure Cache Hit Ratio and High CPU Utilization

  

I have a SQL Server 2005 32 bit instance that occassionally has issues with the Procedure Cache.  This instances 200+ databases and is configured with 4 processors and 12 GB of memory.

The Procedure Cache Hit Ratio drops to 25% for an extended period of time.  The size of the procedure cache during this time is very small.  I am able to tell this by quering the DMVs.  Also, DBCC Memory status shows a small procedure cache area.

Using tools such as vmstat.exe or sqbmemory (from Red-Gate) I see that the Commited memory value drops from around 1900 MB to 600 MB and the Reserved memory value increases from 50 MB to 1350 MB.  The memory is being stolen from the Committed bucket and is being reserved by some other SQL process such as XML or CLR.

After we restart the instance, the memory pressure issues go away.

Do any of you know if there is a DMV or a tool that I

SQL Server 2008 - High Memory Usage

  

Hi ,

  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

High CPU and Memory on Production

  

As a standard drill what all metrics should one look into during high CPU and Memory Usage on production and how?

Please Help with scripts/tips/reading material.

What all parameters can we proactively monitor on perfmon and what sql traces should be run at such times. PLEASE HELP.


High memory usage by the SSMS.exe and no Running Query

  

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 http://i875.photobucket.com/albums/ab319/jacarmonaro/highMemory.jpg

Other thing: When I minimize the ssms window the smss.exe process come back to a normal RAM memory usage.

Please any help??

 


JAC

High memory usage by the SSMS.exe and no Running Query

  

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 http://i875.photobucket.com/albums/ab319/jacarmonaro/highMemory.jpg

Other thing: When I minimize the ssms window the smss.exe process come back to a normal RAM memory usage.

Please any help??

 


JAC

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

  

Hi,

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

 

S.Jay

 


Mikha

SQL Server CPU utilization high when idle

  

Hello,

I'm running SQL Server 2008 on an 8 CPU machine with 32 gigs of RAM.  When the SQL Server instance is idle, no client requests, the sqlservr.exe process consumes about 10-18% of the CPU on the machine.  I can't seem to figure out why it is consuming this much.  

I found another post here suggesting a user run a script which gets the processor utilization history.  I ran this command and it returns SQLProcessUtilization as 12-13% for the last 30 minutes of usage.  

I ran the profiler and captured the SQL and there was very little being run, all I saw was a query for the DBVersion every 10 seconds or so, and the Duration was 1 with the SQLBatch::Completed in 20 ms.

I'm not as familiar with SQL Server as I am with Oracle, so any help would be appreciated. 

TIA

Gary


Understanding Memory Utilization in SQL Server

  

Hello,

I'm trying to understand multiple aspects of how memory is allocated and used within SQL Server.  The primary goal I have is to find the optimum amount of memory for our current server AND optimum if we were to split multiple databases out into separate physical servers.

Current environment:

  • SQL Server 2005 Standard x64
  • Windows 2003 R2
  • 98GB RAM
  • 3 primary databases residing on this single physical server
  • currently has both min and max memory configured to 91GB

My understanding (and this seems to be backed up by books online) is that SQL Server will allocate memory as needed but not release any until it hits the min memory value, if it exceeds min it will release as SQL Server decides is appropriate but will not drop below min.  Am I correct in my understanding so far?

The 91GB is used on this server which tells me (if my understanding is correct) that this box is potentially benefiting from that full amount of memory or it never would have fully allocated.  I still suspect that I have much more RAM than I really need (in a practical sense if not a technical one).  I suspect that there may be data cached that is never being hit again but SQL Server is simply using the memory because it can and if we were to cut available RAM in half or even third it would sti

High CPU Utilization of w3wp.exe and Event ID 5000 caused by Search

  

Hello, I am trying to trouble shoot an issue related to my SharePoint server having the CPU pinned down by w3wp.exe.  The only exception I was able to identify has been related to Search.

Event ID 5000 Office SharePoint Server

 

EventType ulsexception12, P1 w3wp.exe, P2 6.0.3790.1830, P3 42435e74, P4 microsoft.office.server.search, P5 12.0.6245.0, P6 4bbd6526, P7 3012, P8 191, P9 deletedconcurrencyexception, P10 837s.

I am having no luck with any of the codes as part of this error message.  Could any one point me in the right direction related to Event ID 5000 ulsexception12.  To my knowledge there have been no changes made to Search or SSP.

Any help would be greatly appreciated.  thank you


Mark A. Eckert SharePoint Consultant Pharmica Consulting, Inc.

ASP.NET Best Practices for High Performance Applications

  
This article lists the techniques that you can use to maximize the performance of your ASP.NET applications. It provides common issues, design guidelines, and coding tips to build optimal and robust solutions.

High-Performance .NET Application Development & Architecture

  
It has always been a goal of project architects to plan an effective strategy from the ground up in regards to an new application. All relevant factors are taken into consideration with respect to the application, from its design and layout to a functional website infrastructure. Pre-.NET strategies and design guidelines still effective now were developed with Microsoft's DNA (Distributed interNet Application) platform. This model successfully served the purpose of architecting N(any number of)-Tier (levels) applications. In its basic sense, as in most robust, distributed applications, you'll architect 3 main layers or Tiers: presentation, business rules and data access.

High Performance ASP.NET - Speeding Up ASP.NET Pages

  
have been writing a series of blog posts, which I have named High Performance ASP.NET Websites Made Easy! There is no rhyme or reason to the order of these posts and certainly can be read in any order:

Developing High Performance and Scalable ASP.NET Websites
Avoid Chatty Interfaces Between the Tiers in Your ASP.NET Web Application
ASP.NET Page Profiling - Page Tracing - High Performance and Scalable ASP.NET Websites Made Easy
Web Applications: N-Tier vs. N-Layer - Benefits and Trade-Offs
Query Analyzer - Sql Server Database Indexes and Execution Plans

10 Tips for Writing High-Performance Web Applications

  
Writing a Web application with ASP.NET is unbelievably easy. So easy, many developers don't take the time to structure their applications for great performance. In this article, I'm going to present 10 tips for writing high-performance Web apps. I'm not limiting my comments to ASP.NET applications because they are just one subset of Web applications. This article won't be the definitive guide for performance-tuning Web applications-an entire book could easily be devoted to that. Instead, think of this as a good place to start.

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.

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


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.


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