Wednesday, 28 June 2017
     
AUSQLUG Forums Home   Search   Login   Register   Member List  
SQL Server 2005 Forums  > CLR Programming  > SQLAgent Memory Usage on SQL 2005  
 
Display using:  
Previous Thread :: Next Thread 
 Author Thread: SQLAgent Memory Usage on SQL 2005
Pammyy is not online. Last active: 3/10/2006 7:26:13 PM Pammyy
Top 100 Poster
Joined: 29 Mar 2005
Total Posts: 2
 
SQLAgent Memory Usage on SQL 2005
Posted: 03 Oct 2006 02:27 PM
Hi there,

We are planning to upgrade from SQL2000 to SQL2005 in a week time. But we are getting whole bunch of error messages: "There is insufficient system memory to run this query". There are a few schedule tasks that need to be run on the server.

Our SQL2005 server is using Windows 2003 as OS, 4G RAM, SQL 2005 Standard Edition. We found that the SQLAgent90.exe took 600M-700M memory (at usual time). There's one time that it even goes up to 1.2G. Our DBA never implement SQL2005 into production so we cannot tell that if this is normal for SQL2005.

Can anyone who'd implement SQL2005 to production please advise? Thanks in advance.

Cheers

Pammy
ace is not online. Last active: 27/11/2011 11:16:50 PM ace
Top 25 Poster
Joined: 24 Jun 2004
Total Posts: 200
 
Re: SQLAgent Memory Usage on SQL 2005
Posted: 21 Oct 2006 06:16 AM
Hi Pammy,

This is definitely "not normal", I think ;oP Certainly I have not seen

First thing I would check / ensure is whether you are running Service Pack 1.

Otherwise, without more information it's hard to know what's causing the problem.

A potential solution is to restart the SQL Agent every so often, which can be easily scripted.

You really need to investigate what is causing the problem. I would suspect some job that performs a query directly. You might be better off moving such a job into SSIS...

I would monitor (capture a log through perfmon) your SQL Server to see when the SQL Server Agnet process starts to consume RAM, and then try to work out what causes this.

HTIR,

Victor
prepnerds is not online. Last active: 27/05/2016 7:54:12 PM prepnerds
www.prepnerds.com
Joined: 27 May 2016
Total Posts: 1
 
Re: SQLAgent Memory Usage on SQL 2005
Posted: 27 May 2016 07:54 PM
I like your post and all that you impart to us is present and extremely enlightening. continue sharing such sort of post here.

1Z0-459 Exam Answers & Questions PDF 400-101 Exam Answers & Questions Pdf Citrix 1Y0-253
Previous Thread :: Next Thread 
Page 1 of 1
 
AUSQLUG Forums  > SQL Server 2005 Forums  > CLR Programming  > SQLAgent Memory Usage on SQL 2005