Why SQL Server 2000 Service Eating So Much Memory?

Feb 9, 2007

Hi to all, i have a very important problem...pls help me

I have a server with Windows 2003 Server (3GB RAM) and SQL SERVER 2000 running on it, my problem is that sqlserv.exe eat 2GB RAM even if on this server nothing happen....if i restart the service of SQL Server everything is ok eat just 30 MB RAM but after some minutes...after i made a simple select or a simple delete....simple things he arrive to 2GB RAM...this not happen until now(2 days ago)...the problem is that when he arrive to ~2GB RAM the statio run very slow and i receive the error "Time out expire"

this problem happens and on my local station where i have Win XP PRO (1 GB RAM) SQL Server 2000....

thx a lot

View 1 Replies


ADVERTISEMENT

Fuzzy Lookup Componant Eating All Available Virtual Memory

Jan 23, 2006

Hey,

I have a large set of data that I need to match against another large set of data.  The reference table has 9.8mill rows and my input has 14.6mill rows.  I started with a new project.  I added my connection, then a task to clear the result table, then my data flow, then my OLE source, then my Fuzzy Lookup task, then my SQL Server Destination.  I set the connection of my OLE source and set the query to pull the data.  Then I set the connection of my Fuzzy Lookup task, set the reference table and told it to create a new index (the problem also occurs if I use a generated index) and then set up the matching criteria.  Then I set the connection and destination for the SQL Server Destination.

After setting all this up, I hit Run.  The thing ran great until ~ 800k rows and then it failed.  I ran it several times and it always failed right around 800k with a message saying there was not enough space and then an error with buffers being passed to the Fuzzy Lookup component.  I opened Task Manager and watched the resources as it ran and was amazed at what I saw.  The Fuzzy Lookup component eats up every bit of Virtual Memory available and when it can't take any more, it errors out.  I tried setting the Max Memory setting on the component and it seems to have no effect.  I also played with the buffer settings on the data flow task to no avail.  I even went as far as to put an identity on my input table and create a function that outputs selects that use a between on the identity to break the data into 600k chunks.  I set up a ForEach component and DTS variables, but the Fuzzy Lookup component does not free the VM after the iteration of the ForEach component!

I ended up running each chunk of 600k one at a time.  I have to automate this for the future, so I need a solution.  Does anyone have an idea for me?
 
 

View 7 Replies View Related

Multiple RadCharts And Multiple SQLDataSources Eating Up My Memory!

Mar 20, 2008

[.NET 2.0, Visual Basic, RadChart/RadPanel/RadTimer controls (www.telerik.com), SQLDataSource controls, SQLServer 2002]
I have only been working with .NET for about a month now so my knowledge and understanding are pretty low in some areas, including this one.
What I have is a number of webpages that have several RadChart controls on them (8 to 12 charts per page). Each of these charts is bound to a seperate SQLDataSource with a variation of the following query:
1    SELECT [QC Shot Logs].penetration, charges.penmra, charges.penmts, [QC Shot Logs].time2    FROM [QC Shot Logs] INNER JOIN (select top 1 run.runid, run.linerpress#, run.partid3    from run where run.linerpress# = '1' order by run.[date] desc) as drun ON [QC Shot Logs].RunID = dRun.RunID4    INNER JOIN Charges ON dRun.PartID = Charges.PartID5    where [qc shot logs].shottype < 3 order by [qc shot logs].timeEach chart represents the results of a quality control check on explosives that my company uses and puts the data in a visual format so that it is easy to see if the blasts passed or failed inspection. The different variations in the SQL code above are simply a change in line #3: where run.linerpress# = '1',  where run.linerpress# = '2', and so on up to '12'.
Data is added and modified in the database quite a bit throughout the day at random times, so I need the charts to refresh their data pretty frequently (done with a RadTimer control). The problem that is caused then is that I have 12 RadCharts individually bound to 12 SQLDataSources that all get refreshed every 30 seconds or so, which takes quite a bit of time. The main Quality Control computer monitors four webpages at a time, one of them with 12 Charts/Sources, and three with 8 Charts/Sources each. Having 36 charts up at a time with 36 hits on the database going as well causes a great deal of lag on the system. In addition to that though, there are also two other pages (each with 12 charts/sources) that can be viewed by any number of people at any time, which (obviously) causes more lag on the system.
 So, on to my actual questions:
1) Can I use a single SQLDataSource control to gather all of the data I need for the 8-12 RadCharts on a single page? I'm not too well versed in SQL either, so I don't know if I can modify the SQL so that it picks up all of the information I need, or if I can gather the data for the first chart, change a variable to pull the data for the second, change the variable again, etc.
2) Is there a way to refresh the RadCharts so that the data they display is relatively real time without having to refresh the SQLDataSources as well?
And then, of course, any suggestions at all that you can give me that will help to improve overall performace or anything of the like is definitely appreciated.
 

View 3 Replies View Related

Sql Server 2000 Using Less Memory After More Memory Added

Aug 22, 2007

sql server 2000 is running on windows server 2003 ... 4gb of memory on server .... 2003 was allocated 2.3gb nd sql server was allocated (and using all of it) 1.6gb for total of approx 4gb based on idera monitor software ... all memory allocated betweeen the OS and sql server .... then 4 more gb of memory added for total now of 8g ... now idera monitor shows 1.7gb for OS and 1.0 gb for sql server ..... 'system' info shows 8gb memory with PAE ... so I assume that the full 8gb can now be addressed .... why are less resources being used now with more total memory .... especially sql server ..... i thought about specifying a minimum memmry for sql server but i amnot convinced that would even work since it seems that this 1gb limit is artificial .... it it used 1.6 gb before why would it not use at least that much now ??

thank you

View 4 Replies View Related

SLQ Server 2005: Why Is Eating My RAM?

Apr 25, 2008

Hello again.I'm developing an ASP.NET web application with VS2005 and SLQ Server 2005. The problem is with SQL Server: I tried to add a new column to an existent table (with more than 2500 rows) by mean SQL Server, but it takes almost 1 minute to do each click when I open the table in edit mode. I don't think that it is normal. May be it because the size of the databases? (8 databases: 30GB in total)? may be a error of configuration? I reviewed the RAM use of SQL Server and it takes 1.1 GB!!! so, I rebooted the server and then it was taking 540Kb of RAM. I don't know if this is the better place to do this question, but if it isn't please refer me to the right place to do it. Thanks in advance. PD: sorry for any misspell/mistake, I'm not a fluent English-speaker.

View 5 Replies View Related

DB Engine :: Reboot / Restart Service After Setting Max Server Memory

Apr 29, 2015

After I have set the maximum sql server memory in sql server 2014 using sp_configure, do I need to reboot whole server or restart sql service?

View 4 Replies View Related

SQL Server 2005 Service Broker - Activation Stored Procedure Memory Usuage

Nov 9, 2007

We are looking for some guidance with an issue we have picked up with our implementation of Service Broker here on the ABSA Capital project and I am hoping you can help or point us in the direction of someone.

The architecture we have implemented for service broker is to make use of an Activation stored procedure on two queues (1 SP per queue) to process the messages received. What we have found is that the activation stored procedure runs on a background session and its CPU time and memory just grows to the point where it brought one of our UAT servers to a grinding halt.

Is there anyway we can reduce the memory consumption of the activation stored procedure or is this one of those things that still need to be ironed out in Service Broker?

View 6 Replies View Related

SQL Server 2000 Std Memory

Feb 12, 2007

I have SQL Server 2000 STD installed on a Windows Server 2003 STD machine. It's essentially the only app on this box. I have 4GB of RAM installed. SQL is configured to dynamically allocate memory. I run a batch file daily to restart the SQL services as SQL does not seem to release memory once it's got it. I don't think this is a problem because, like I said, it's basically the only app. But I want to make sure my OS memory settings and SQL's memory settings are optimized. Will adding the /3gb switch to the boot.ini file make a difference? Also, can someone educate me a little on PAE and AWE?
Thanks

View 1 Replies View Related

SQL Server 2000 Memory Issues

Aug 23, 2007

Every day or two I have to restart my SQL Server because users are receiving timeouts and very slow page loads.  My mem usage in Task Manager show that SQL Server is at 1,200,000k compared to 400,000k when I restart it.  Performance Monitor also shows that Buffer Manager/Target Pages and Total pages are maxed out.  Any advice?  Thanks!
 
 

View 1 Replies View Related

SQL Server 2000 And Memory Consumption

Sep 14, 2005

Hello!


We have a SQL Server 2000 that has been working nice
without any issues. Lately we noticed the fact that the amount of memory that
it is using has increased and once it took down the web server as the total
amount of memory used was 2G. Due to this fact I have set Memory Max to 500MB.
Now as I look in Task Manager the Memory usage is at 530396k which is 518MB.
Any reason why would it exceed the 500MB?

What we did before was to stop the SQL Server and restart it, and it takes about
2 days until it gets back to +500MB.

What can I do to stop this behavior?

Thanks.

View 3 Replies View Related

SQL Server 2000 Memory Issues

Jun 13, 2006

Dear All,

We have a Windows 2003 Enterprise server with SQL Server 2000 Enterprise on it. This has the AWE settings for 'max memory setting' to 5120MB. This server has 6GB of memory, or rather about 5.8GB due to PAE. From yesterday morning the server has become almost unresponsive when the SQL service is running, and pretty much all the memory, ie < 1MB on average is listed as being free.

The database has been growing constantly and is now 46GB, with database file size of 67GB.

We moved the database onto a new box which was being prepared for another service, and this has 8GB or ram and no AWE settings. It is running fantastic.

We are going to rebuild the original box and the SAN structure, but I want to do some fiddling before we do. I was going to set awe-enabled to 0 to see if that setting was allowing the OS to have no memory, but from reading http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx it says If AWE is enabled and is taking too much memory, SQL Server must be shut down to reconfigure it, causing downtime (which makes a high availability option such as failover clustering less available). Because the memory pages used by the instance of SQL Server are taken from the nonpageable pool of Windows memory, none of the memory can be exchanged. This means that if the physical memory is filled up, SQL Server cannot use the page file set up on a physical disk to account for the surplus in memory usage. How do you reconfigure AWE settings if the SQL service is shutdown?

Also, how can I figure out whether the server is deficient in physical RAM, or it is just a 'max memory' setting we need to tweak, or is it just trial and error?

Incase it might help, we have ~3 meaningful DB's on the server apart from 'master'. One is an archive DB ~80GB, one is ~5MB and the live DB which is the size mentioned above. Unfortunately I don't know table sizes.

Pax

View 3 Replies View Related

SQL Server 2000 Not Using All Memory Allocated To It.

Aug 1, 2007

One of our servers has 20GB of memory and SQL server has been allocated 18.5 GB out of it, however SQL Server only uses about 9GB or so.

OS: Windows 2003 Server
MS SQL Server 2000 SP4
awe enabled
min & max server memory (run values) are: 18432
/PAE switch in boot.ini

any help why SQL server is not using 18.5 GB allocated to it, would be greatly appreciated?

View 8 Replies View Related

Memory Usage For SQL SERVER 2000

Mar 23, 2006

Good day to all of you
I am faced SQL SERVER 2000 Memory usage problem. I am using Windows 2000 Server SP4 and SQL SERVER 2000 SP4. When User running some in-house application software, the memory for sqlservr.exe was increased . But, when user logout from the software. The sqlservr.exe did not decrease the memory. I have around 100 Users in my company. SQL Memory will countinues increase till max memory usage in CPU.

May i know how to order SQL SERVER need to purge memory when USER was log off from the Program? Or my SQL SERVER was corrupted /missing file?

Please advice

Many thanks!
Melvin

View 4 Replies View Related

SQL Server 2000 2GB Memory Limit?

Jul 23, 2005

SQL Server 2000 SP3 on a Dell dual 2.4GHz Xeon box 3GB RAM Windows 2KSP4. Two aplication dbs, each less than 2GB in size.Had a problem where we would run Solomon queries and what not againstthe box. It had 2GB RAM, and sqlserv.exe would take up to 1.85GB ofRAM, exhausting the physical RAM on the box. SQL would choke and theSolomon users would have problems, and I would have to restart the SQLservice.I added another GB of RAM, bringing the box to 3GB, and increased thepaging file. The OS sees it, and SQL sees it. I check EnterpriseManager, and tell SQL to dynamically configure memory, and it offers anupper limit of 3071MB, so it "sees" the 3GB.I can stress the box with queries to the point that sqlserv.exe takes1.99GB of memory (as viewed through Task Manager) and then SQL serverchokes. It never goes past 2GB, and the OS and box continue runningfine.Does SQL server 2000 have some upper limit, or do I just need to changesome setting through EM?Thanks.

View 2 Replies View Related

SQL Server 2000 Memory Reclaim

Jul 20, 2005

Hi,I guess SQL server does not release claimed memory even if it is notused. Is there anyway to free the unused memory?Thanks,John Jayaseelan*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!

View 1 Replies View Related

SQL Server 2000 - MSDN - AWE Memory

Aug 16, 2007

We use MSDN SQL 2000 , the enterprise edition for our development servers,
which have always had 2GB RAM.
Now they are bringing in a Win 2003 Enterprise with > 12GB RAM .
They want SQL SERVER 2000 to use AWE memory up to 12GB . Is there any limitation
on MSDN Ent. Edition using more memory.?

View 2 Replies View Related

SQL Server 2000 -- Taking Over My Memory

Feb 3, 2006



I am running SQL Server 2000 on a desktop PC. Just recently upgraded my PC to 2gig of ram from 1 gig, in part, to try and fix the problem below. Didn't work. Have SP3 installed but not SP4 at this point.

When I open up query analyzer and edit some code, regardless of whether I actually execute the code, SQL server eventually sucks up available and cached memory to the point that my system comes to an effective halt --takes forever to do anything either in SQL server or other applications. In the task manager PF Usage climbs to just over the 2gig memory limit.

I conceptually understand the dynamic memory operation of SQL server ... but why is it sucking up most available memory when nothing is executing?

Is there a way I can release/clear the memory? Ideally, code that coould be run under a stored procedure would best meet my needs. Right now, I am "fixing" by shutting down and then restarting SQL server.



Thanks,

View 8 Replies View Related

SQL Server 2000 Memory Problem

May 10, 2007

Hi to alll,


I use sql server 2000 ver 8.00.2039
I would like to know if is possible to free some ram memory without restart the service .

I have about 1.7 Gb of memory used

I have just tried to use these commands


DBCC DROPCLEANBUFFERS
DBCC FREEPROCCACHE
dbcc free


but seems that nothing happens

Any idea?

thank you in advance

View 3 Replies View Related

SQL 2000 Server Memory Issue! CRITICAL!

Apr 4, 2007

Good day everyone!

The issue I'm going to pose here has to do with SQL Server allocated memory BEING EXHAUSTED by an application (a simple data receiver from GPS units) when the number of units connecting to it is considerably increasing.
This happens to an extent that no more connections from the units are valid and therefore lots of data (Afterwards) is being lost.
This causes a real problem with the installations and the projects which are running the system.

I will hereby post all of the info which might be useful for any Database Experts among you, so you can perhaps help me figure out the source(s) of the mentioned problem, and possible solution(s) of the issue.

1- The Operating System used:
Windows 2003 Server (Ent. Edition)

2- The Database Server used:
Microsoft SQL 2000 Server

3- The amount of memory:
1 GB (but on some sites there are 4 GB and the same problem
is faced)

4- The conditions where the issue happens
When the amount of the received data - which gets written to
the SQL Server tables - exceeds a certain limit.

5- Number of applications used:
We are using two applications:
a- The receiver, which is a simple application that only
receives the data from the GPS units installed at the cars
of the clients' fleet(s), and writes them to the database
(Day and Night - running all the time), so the memory used
gets bigger and bigger till it floats the memory used by
MS SQL Server 2000. As a result of this the connections
made from the units furtherly to this point (to the receiver)
are not being received and written to the database.

b- the other application is quite heavy.. it does data
management on SQL Server 2000 and exhausts the CPU.
It reads from tables and makes analysis for GPS data...
This is done while "vehicle tracking".. so it makes
calculations on the received data and stores them into
output tables.

6- The programming language used in writing these 2 applications:
Delphi 7

7- What are we doing right now to handle this problem?
We need to flush the memory on periodical basis.
This is being done by stopping the SQL Server, or by
restarting the PC.
And it is not solving the problem entirely, especially that
there must be a way to handle this.
BTW, the memory is not being flushed when we turn the
application off.

8- What do we need to know?

a- We've found, after research, that there are "Temporary tables" or
objects in SQL Server 2000, that the DB system creates.. also page
files, and temp tables.
What are these for? And does handling them in a certain manner help
solve the problem?
b- Is there a way to monitor our applications to see where they are
increasing the usage of memory and how this is happening?
c- Is there a script that writes to the database that we can use to see if
the problem is from our applications? And in case it is, then is there a
command we should write or a function or script we should run in order
to flush the MS SQL 2000 Server periodically, so that it doesn't flood?


What comments can you have on this issue?
Are there solutions at hand?


I thank everyone for trying to help!

All the best :beer: :beer:
TD.


P.S. you can write to me at: database1980 (AT) hotmail (DOT) com

View 14 Replies View Related

SQL Server 2000 Max Outs Memory Even With 32GB RAM

Oct 6, 2006

Hi

I am joining the thread that initially Mike started. We have a x64 bit SQL Server with 32GB RAM. On start up sqlserver.exe starts with 15 to 20MB of RAM. After that the memory gradually increases at a step of 100MB and reaches 31.8 GB at the end. We don't see a out of memory situation so far and the memory remains the same, once the sqlserver.exe reaches that level we are facing application in stability issue. There is no other application running in this server. At present the database size is 28GB and we have employed the following,

There is a database replication running

A weekly maintenance plan to reindex, backup and other maintenance is running.

There is a log back up job which runs once in 2hrs time.

The temdb size grows to 3gb max. We didn't see any temp table created left out orphan in the temdb.

We have the required indexes placed in the tables to reduce the scan time. Also the server is configured to use dynamic memory allocation that is all are factory settings.

The database is encounters on an average 200 to 500 connections at a time. One observation is the memory goes up as soon as the replication starts, this is at one of the 2 servers.

Please advise what is causing this issue and how to go abt it.

View 2 Replies View Related

SQL Server 2000 Standard Memory Flatline

Jun 26, 2007

Hi all,



We have an SQL 2000 Standard SP4 system with 3gb of RAM running on Windows 2003 Server R2 Standard.



The SQL memory usage of this server flatlines at around 1665mb and will not go any higher.



I understand SQL 2000 Standard on Windows 2003 Server Standard has a 2gb memory limit, however why wont the memory push up to this limit? The OS shows there is around 700mb of the 3076 unused (SQL uses 1660, windows uses around 700 making the maximum used around 2300 of the 3076)



I have set the /3gb switch on windows boot, I have changed the SQL memory configurations many different times. If I try and set 'min server memory' to anything over around 1500mb I get the error on SQL startup;



Warning: unable to allocate 'min server memory' of 1720mb



In the above example surely if the Server has a 2gb limit it should let me set say 1720/2048 ? or 1920/2048 or even 2048/2048, however anything over around 1500 generates the above error.



Our server continues to flatline at 1660mb, any help to squeeze out an extra 200-400mb of RAM would be appreciated or an explination as to why it can not be done.



Thanks for your help

Jim

View 1 Replies View Related

Memory Configurations For SQL Server 2005 EE X64 With SQL Server 2000 EE X32 On Windows Server EE X64 Server

Apr 20, 2007

My server is a dual AMD x64 2.19 GHz with 8 GB RAM running under Windows Server 2003 Enterprise Edition with service pack 1 installed. We have SQL 2000 32-bit Enterprise installed in the default instance. AWE is enabled using Dynamically configured SQL Server memory with 6215 MB minimum memory and 6656 maximum memory settings.

I have now installed, side-by-side, SQL Server 2005 Enterprise Edition in a separate named instance. Everything is running fine but I believe SQL Server2005 could run faster and need to ensure I am giving it plenty of resources. I realize AWE is not needed with SQL Server 2005 and I have seen suggestions to grant the SQL Server account the 'lock pages in memory' rights. This box only runs the SQL 2000 and SQL 2005 server databases and I would like to ensure, if possible, that each is splitting the available memory equally, at least until we can retire SQL Server 2000 next year. Any suggestions?

View 8 Replies View Related

Extended Memory For SQL7 On Advanced Server 2000

Jan 24, 2002

Could anyone inform me how much the conventional memory SQL7 Enterprise on Advanced Server 2000 can have?
The SQL is on an active/active cluster. Currently each runs at 2GB of memory, with available memory for failover. I am planning to add another 2GB to each SQL node. Is this possible? Are there any configurations I need to do? Do I need to set AWE enabled? and How much?

Your help is greatly appreciate.
Jim

View 4 Replies View Related

Install Sql 2005 Instance With Reporting Service 2005 On Sql 2000 With RS 2000 Server

Aug 18, 2006

Hi

We would like to install Sql 2005 Enterprise Edition (including database engine, reporting service, integration service and analysis service) as a sepearte instance on a server which already has Sql 2000 with reporting services and analysis services. We do not want to disturb the existing sql 2000 setup.

If we do that then what will happen to my earlier sql 2000 reporting service? Will it be upgraded to sql 2005 reporting service? I heard that reporting services are instance unaware application. Where will be the default reporting service database available?

Please help us.

Regards,

Sankar N

View 1 Replies View Related

Call Web Service From Sql Server 2000 Job

Mar 5, 2007

I would like to call a web service from a sql server 2000 s.proc/sql job, but if there is a better way please let me know.  I'm using Captaris Workflow to create and manipulate workflow processes.  I have a sql job that will create some pdf's.  I want to call the web service that creates a new process in a step from that sql job.  I have read about doing this with extended s.procs, but I'm trying to find any possible solutions.  Essentially, the web method I want to call will insert several records into sql so I know I can at least do that.  I would still like to know if I can make a call to the web service from the sql job. Thanks for any help. 

View 1 Replies View Related

Sql Server 2000 Service Pack 3

Feb 21, 2004

Hi,
I am trying to install the service pack 3 for sql server 2000 but cannot do it. I keep getting stuck at the screen where it asks u for the windows authentication or the sa password.

I select the sa password option and enter the password but it gives me an error saying that it was unable to connect.

Can someone tell me what to do.

Kind Regards,

Yoshi

View 1 Replies View Related

Where To Get SQL Server 2000 Reporting Service For VS.NET?

May 5, 2004

Where to get SQL server 2000 reporting service for VS.NET?

View 4 Replies View Related

SQL Server 2000 Service Pack 3a

Dec 19, 2004

Hi all,

I have msde version 8.00.534 that is sp2 I think. When I attempt to upgrade to sp3a I get: “The instance name specified is invalid� . I am working with win XP home edition that include IIS.
Have some suggestions? Thanks

View 1 Replies View Related

SQL Server 2000 Service Pack 3a

Dec 19, 2004

Hi all,

I have msde version 8.00.534 that is sp2 I think. When I attempt to upgrade to sp3a I get: “The instance name specified is invalid� . I am working with win XP home edition that include IIS.
Have some suggestions? Thanks

View 1 Replies View Related

SQL Server 2000 Service Pack 2

Apr 22, 2002

Hi all,
I want to setup the SP2,so I like to know before if the SP2 is valid and proved and with SP2 I have any problem on administring the server.

Thanks in advance
Jalal

View 1 Replies View Related

Sql Is Eating Up The Cpu

Feb 20, 2008

how can i figure out why?
it's a brand new high spec computer.

i have sp that is being run probably about 25 times a minute which checks that a records is not a duplicate and inserts... could this be tying up the cpu? how can i figure out what is doing it?

View 11 Replies View Related

Service Broker Consumes More Memory

Dec 11, 2007

Hi,

I have implememted service broker in my application.My sqlservr.exe comsumes more than 2 gb of memory which eventually cause my computer to hang.I unable to track the problem.
Can anyone help me out of this.
Looking at the SQL Server logs i found following error message logged multiple times ;


The query notification dialog on conversation handle '{09B96045-99A4-DC11-802F-0013EFF142EF}.' closed due to the following error: '<?xml version="1.0"?><Error xmlns="http://schemas.microsoft.com/SQL/ServiceBroker/Error"><Code>-8470</Code><Description>Remote service has been dropped.</Description></Error>'.
-Aravind cheziyan

View 1 Replies View Related

The Sqlservr.exe Service Could Not Release From Memory

Oct 3, 2007

Dear Friends,

I have developed my web application using ASP.Net with MS SQL SERVER Express Edition SP2 .
I have hosting it at some where which i can remote and see the service of sqlservr.exe .
The first start of this service take the memory space just only 25 MB but after this service run upto one week it increased up to 200MB .This service won't realease from the memory untill unless i restart the server or restart its service.

1.Could any one tell me why this service continue increasingly ?.
2.What can i configure in MS SQL SERVER 2005 EXPRESS Edition to let this release from the memory without restart the server or its service ?.


Best Regards,

Channarith Hun.

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved