HELP: SQL Server Won't Release Memory

Tod1d

Hi,

I am having an issue with SQL server that slows everything to a crawl,
and makes almost any query impossible to complete.

Here are the symptoms:
I stop SQL, I start SQL. The task manager shows SQL starting up and
quickly allocates 50 MB of memory. I then open SQL Manager and I can
open up the instance of SQL Server and I expand to see all of the
databases, memory rises to about 70MB allocated. I then expand a
database and view a list of tables. The memory allocation quickly
rockets to 860+ MB and any attempt to query they database results in
huge hang times.

I have MacAfee anti-virus in place and it is constantly scanning for
viruses, so I don't think it is a virus. The log files do not appear
to be large. I have done everything I know to do to resolve this. Any
help would be much appreciated.

Does anyone have any ideas?

Thank you for taking the time to read this.

Tod

Jul 20 '05 #1

Subscribe Reply

9979

Simon Hayes

"Tod1d" <to****@icqmail .com> wrote in message
news:d3******** *************** ***@posting.goo gle.com...

Hi,

I am having an issue with SQL server that slows everything to a crawl,
and makes almost any query impossible to complete.

Here are the symptoms:
I stop SQL, I start SQL. The task manager shows SQL starting up and
quickly allocates 50 MB of memory. I then open SQL Manager and I can
open up the instance of SQL Server and I expand to see all of the
databases, memory rises to about 70MB allocated. I then expand a
database and view a list of tables. The memory allocation quickly
rockets to 860+ MB and any attempt to query they database results in
huge hang times.

I have MacAfee anti-virus in place and it is constantly scanning for
viruses, so I don't think it is a virus. The log files do not appear
to be large. I have done everything I know to do to resolve this. Any
help would be much appreciated.

Does anyone have any ideas?

Thank you for taking the time to read this.

Tod

Have you tried excluding your MSSQL data folders (all the .mdf/.ndf/.ldf
files) from the virus scan? If the antivirus software is scanning a database
file when MSSQL starts up, then there could easily be a problem of some
kind.

http://support.microsoft.com/default...b;en-us;309422

Simon

Jul 20 '05 #2

Erland Sommarskog

[posted and mailed, please reply in news]

Tod1d (to****@icqmail .com) writes:

I am having an issue with SQL server that slows everything to a crawl,
and makes almost any query impossible to complete.

Here are the symptoms:
I stop SQL, I start SQL. The task manager shows SQL starting up and
quickly allocates 50 MB of memory. I then open SQL Manager and I can
open up the instance of SQL Server and I expand to see all of the
databases, memory rises to about 70MB allocated. I then expand a
database and view a list of tables. The memory allocation quickly
rockets to 860+ MB and any attempt to query they database results in
huge hang times.

McAfee could indeed be a culprit, as Simon suggested. You should
also check if you have your databases set to autoclose, and you should
also check that you don't have ODBC tracing on. (Check this from the
ODBC applet in the Control Panel.)

As for the memory, this behaviour is by design. SQL Server grasps as
much memory it can, because it thinks that memory is good for cache.
If there are other applications on the same machine, SQL Server will
yeild if they need memory, but it may not yield fast enough. You can
control how much memory SQL Server may use from the Memory tab in
Enterprise Manager.

--
Erland Sommarskog, SQL Server MVP, so****@algonet. se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Jul 20 '05 #3

Similar topics

2890

Memory issues with Terminal Server??

by: Justin Lazanowski | last post by:

Cross posting this question on the recommendation of an I have a .NET application that I am developing in C# I am loading information in from a dataset, and then pushing the dataset to a grid, or other controls depending on the particular form. This application is setup with one MDI parent calling MDI children with the exception of one Modal form (the report viewer). When I run the application and run one of the screens that pulls...

.NET Framework

1538

PLS HELP - Forcing Gobal Garbage Collection

by: MuZZy | last post by:

Hi, I got a situation here :) an dwonder if someone can help me. I have an MDI app and say, the child form has a button, clicking on which calls a database transaction - grabbing a lot of tables to the form's TDataSet variable. One transaction grabs about 10 or more Mb of data. If i do several transactions, the memory occupied by the app goes say goes up to 180Mb - i watch it in Task Manager. Now i close the child form, and...

C# / C Sharp

2132

Pls HELP!- DataSet Inherited object not finalizing

by: MuZZy | last post by:

Hi All, I got a issue here and hope someone can help me: Let's consider this code: // =================== CODE START ================================= using System; using System.Data; namespace TestNamespace {

C# / C Sharp

1592

Release won't run

by: markus | last post by:

(Please excuse me for not really knowing where to post this. I picked the biggest and best audience I know of.) I am having trouble running my release build from VC7. It doesn't. When started, it just shows a message box about failing to initialize app + hex address + OK button to close it down. The debug build runs fine as does a test MDI app from VC++ project wizards (both release and debug).

.NET Framework

2806

Urgent help on IXMLHTTPREQUEST

by: Agam Mehta | last post by:

Hi, Everything works fine with ixmlhttprequest. It gives me "access violation" only when i am trying to release it from the memory (i.e pXMLHttpReq->Release()). Below is my code. ////////////////////////////////////////////////////////////////////////// ::CoInitialize(NULL); // Variables.

.NET Framework

1667

Help with transferring Session object between pages.

by: ESmith | last post by:

I have multi-page form where I pass an object between pages as follows: On each page: // What page to go to next private void btnContinue_Click(object sender, System.EventArgs e) { if (Page.IsValid) { MyXferObj obj = new MyXferObj();

ASP.NET

1705

I Really need urgent help

by: Chris | last post by:

Hi, All my websites and webservices are down. I get the following message Server Error in '/mywebservices' Application. -------------------------------------------------------------------------------- Compilation Error Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

ASP.NET

2254

Help with destruction of an object created with the new operator- destructors

by: Pablo | last post by:

Hello, I am writing a windows application using C++ and BorlandBuilder 6 compiler. It is an event driven program and I need to create objects of some classes written by me. One of the classes contains a pointer to int values as a filed. In the definition (implementation) of constructor I use this pointer to create table of int values with the new operator. The number of elements of the table is provided by the user during execution of the...

C / C++

4750

Help needed in using FSO's, TextStreams, etc. --- Code Review and Advice requested

by: Hexman | last post by:

Hello All, I'd like your comments on the code below. The sub does exactly what I want it to do but I don't feel that it is solid as all. It seems like I'm using some VB6 code, .Net2003 code, and .Net2005 code. I'm developing in vb.net 2005. This test sub just reads an input text file, writing out records to another text file, eliminating records that have a '99' in them (it is similar to a CSV file). Some of my concerns are:

Visual Basic .NET

8996

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9388

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8256

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6800

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6078

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4608

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4879

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2791

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2217

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General