 Pammyy
|
 |
| Joined: 29 Mar 2005 |
| Total Posts: 2 |
| |
|
SQLAgent Memory Usage on SQL 2005
Posted: 03 Oct 2006 02:32 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
|
 |
| Joined: 24 Jun 2004 |
| Total Posts: 200 |
| |
|
Re: SQLAgent Memory Usage on SQL 2005
Posted: 21 Oct 2006 06:15 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
|
|
|
|
|