|
SQLAgent Memory Usage on SQL 2005
3/10/2006 2:27:33 PM
(Total replies: 1)
|
| 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 ... |
|
|
|
SQLAgent Memory Usage on SQL 2005
3/10/2006 2:32:00 PM
(Total replies: 1)
|
| 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 ... |
|