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


Top 5 Contributors of the Month
Sharon Maxwell
Post New Web Links

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

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

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


View Complete Post


More Related Resource Links

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

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

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

Windows Service .NET running on CLR 4.0 High CPU Usage

  

We have a windows service which hosts different appdomains. This processes uses remoting over IPC and TCP to communicate across the different app domains and with other processes.

 

This process is compiled using .NET framework 2.0 (vs2005) but we forced it to run on CLR 4.0 using the following entry in the config file.

  <startup useLegacyV2RuntimeActivationPolicy="true">
    <supportedRuntime version="v4.0"/>
  </startup>

 

The problem is that after some hours of running, the process starts eating up the CPU cycles. When debugging with WINDBG we notice that the thread consuming much of the CPU is in fact the Garbage Collector (<gcServer> is set to true).

 

On inspection of the Heap we notice that there is a very huge array on the LOH of the type System.LocalDataStoreElement with around 18million entries all set to null. This array is copied and increased each time, which is what is causing the cpu issue.

Now in our services we are passing Identities to impersonate user in the other appdomains / processes in the Named dataslots for the different threads (we have an object which implements the ILogicalThreadAffinative).

 

This issue is not present if the process runs on the CLR 2.0. Anybody can shed to us som

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


High Availability: Keep Your Code Running with the Reliability Features of the .NET Framework

  

Reliability requires the capacity to execute a sequence of operations in a deterministic way, even under exceptional conditions. This allows you to ensure that resources are not leaked and that you can maintain state consistency without relying on application domain unloading (or worse, process restarts) to fix any corrupted state. Unfortunately, in the.NET Framework, not all exceptions are deterministic and synchronous, which makes it difficult to write code that is always deterministic in its ability to execute a predetermined sequence of operations. In this article Stephen Toub will show you why, and explore features of the .NET Framework 2.0 that help you to mitigate these situations and write more reliable code.

Stephen Toub

MSDN Magazine October 2005


Design: Inspect and Optimize Your Program's Memory Usage with the .NET Profiler API

  

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.

Jay Hilyard

MSDN Magazine January 2003


Previous Day - High Level Reporting Usage Summary

  
Want to provide a subscription to send to management the High Level Reporting Usage Summary report. Want to always send previous day's data Monday thru Friday. How can I set that up?

Running a single SQL update query on multiple foxpro databases

  
Hi, Env : SSIS 2008 My requirement is to run a update SQL statement on multiple foxpro databases. The fox database paths are available in a SQL server table.  I've created a for each loop control and assigned the database path to a variable named dbpath. Within the loop, I added an "execute sql task" control. Now what properties are to be set to get the requirement done. Appreciate any help. Regards. BH  Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH

Consistently running out of page file memory with full text indexer

  
Using MS SQL Server 2008 SP1 x64 Standard Edtion on Windows 2008 R2 Enterprise, I'm about to full-text index for the first time 1 table and 2 views. The table contains about 250'000 entries with a data space of 180 MB. As soon as I activate the full text indexing, the fdhost.exe task starts to consume slowly but surely all the available page file space (this can be easily watched using the Resource Monitor and the Commit Charge graph on the memory tab). Once all the virtual memory has been consumed, the server becomes unusable since it can't open any new windows any more, and RDP stops working. The machine specs are as follows: 12 GB of RAM 80 GB free on hard disk out of 136 GB 8 CPUs Custom size paging file with sizes between 24 GB - 60 GB (originally, this was system managed size, but then the server ran out of memory sooner) Max SQL server memory set to 6 GB (first 10 GB, then 8 GB) I've set the max fulltext crawl range to 8. During the indexing, the 8 CPUs are bit busy for a while, but not excessively. What is astonishing is that there is almost no use of physical memory during the indexing (I can see an increase from 2 GB to 3 GB which still leaves plenty of RAM available). Does anybody have an idea how I can convince fdhost.exe to consume physical memory and leave the paging memory alone? Or what else can I try?

MDX works fine in SSMS but not in query designer

  
Hi all,   I am trying to include this query in my query designer in SSRS. The query below is as follows:WITH MEMBER [Time].[Fiscal Month].[All].[ Subtotal] AS ' AGGREGATE( EXISTING { [Time].[Fiscal Month].[All].CHILDREN }) ', SOLVE_ORDER = 1000  SELECT NON EMPTY { { { { [Time].[Fiscal Month].[All].CHILDREN }, { [Time].[Fiscal Month].[All].[ Subtotal] } } * { { [Measures].[SKU Distinct Count] } } } } ON COLUMNS , NON EMPTY { [Sales Force].[Retailer Code].[All].CHILDREN } ON ROWS  FROM [Sales]CELL PROPERTIES VALUE, FORMATTED_VALUE, CELL_ORDINAL The error i am getting isThe query cannot be prepared: The query must have at least one axis. The first axis of the query should not have multiple hierarchies, nor should it reference any dimension other than the Measures dimension..Please let me know where am i going wrong.Thanks and regards,ram

SQL server management studio 2008 freezes when running a query to Grid result

  
Hello, I've got problems when I run a Query to a grid result using SQL server management studio 2008 under W7 pro. When I execute the query, the first part of the grid returns, but then it freezes. The query should present a double resultset and contains approx 6100 records, devided over 2 grids. Strange enough, the query runs fine when I export to TXT or to a file. It seems though that the problem is building the grid. When it occurs I cannot end the application bij shutting down de SSMS window, but have to kill the Ssms.exe. In task manager I see only 25% CPU usage and approx 20% memory usage. Nothing exiting there I guess. Suggestions anybody? Microsoft SQL Server Management Studio      10.0.2531.0 Microsoft Analysis Services Client Tools      10.0.3798.0 Microsoft Data Access Components (MDAC)      6.1.7600.16385 Microsoft MSXML      3.0 4.0 5.0 6.0 Microsoft Internet Explorer      8.0.7600.16385 Microsoft .NET Framework      2.0.50727.4952 Operating System      6.0.6001 regards, Pim

Form background images and memory usage

  
Hello everyone, please forgive me if this is the wrong forum for this post. I have written a Windows App in C#. It's a real small application (something like a widget) that stays on your desktop and shows pictures of a folder in a random sequence. Before showing another picture i use : this.BackgroundImage.Dispose(); so that i keep memory usage low. If i won't do that i can see memory rising (depends on the image size). Now the code i use to change the picture is : this.BackgroundImage = Image.FromFile(path, true); So my question is about this last line of code. Is this a good approach of changing the picture after a while? (this code runs in a loop) Should i care about memory usage? The form is a small one for this kind of app, so loading big and large pictures can have some issues i guess. I have been monitoring my app for some time , memory and cpu usage were really low but i would like to know another and better approach on this one if somoeone knows.  de_Stan

Query to list currently running queries on the sql server 2000

  
Hi all Who to check, what all queries are running curently on the sql server 2000, I need to list who all logged in and what queries are getting executed and how long its running. Thanks in advance. shan  

MDX Query tuning with subcubes usage

  
Hello, I've an SSAS DB with 8+ dimensions among which 4 are regular dimensions and 4 are parent-child dimensions. The problem is I've an MDX query whose execution is taking 45 seconds of time. Following is my MDX query : Select Non Empty(Hierarchize({{DrillDownLevel({{[PCDim1].&[716]}})}})) on Rows         ,Non Empty(Hierarchize({{Descendants({[TimeDim1].&[5045],[Time].&[TimeDim1]},[Time].[Month],SELF)}})) on Columns From MyCube where ({[PCDim2].&[101],[PCDim2].&[102]} *         ([PCDim3].&[1],[PCDim4].&[1],[RegDim1].&[104]),[RegDim2].&[1],[RegDim3].&[14],[Measures].[MTD]) I tried to speedup the query execution by using the subcubes. Following is the altered query:   Select Non Empty(Hierarchize({{DrillDownLevel({{[PCDim1].&[716]}})}})) on Rows         ,Non Empty(Hierarchize({{Descendants({[TimeDim1].&[5045],[Time].&[TimeDim1]},[Time].[Month],SELF)}})) on Columns From ( Select {[PCDim2].&[101],[PCDim2].&[102]} on Columns From MyCube ) where (([PCDim3].&[1],[PCDim4].&[1],[RegDim1].&[104]),[RegDim2].&[1],[RegDim3].&[14],[Measures].[MTD]) surprisingly this took more time to execute when compared with the earlier query execution time. I've read that using subcubes in MDX query would speedup the query

MSSQL SERVER RUNNING - HOW DO YOU RUN A QUERY?

  
I have MSSQLSERVER (Running - \\D1XFZ9C1\SQLEXPRESS-MSSQL Server) running. Under my Programs I have MicroSoft SQL Server 2005 but the only items listed are Configuration Tools. Am I missing something? I am trying to run a CREATE DATABASE query in order to create a database for PRO WPF using VB 2008 (Visual Studio 2008) but I don't know where to run it. Can anyone please help as I am new to this.
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