Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jstormoen
Starting Member
30 Posts |
 Posted - 2008-01-18 : 09:03:15
|
| We have an application running on a SQL cluster (Win 2003) and SQL 2005 SP2 within it's own instance - 12 total databases and about 100G of data total. The node this instance is on has 64G of RAM with 16 allocated to this instance (only 8G allocated to other instances currently).Now to the problem there is one process that when running we get the error below and we cannot figure how to correct this - the process runs 8 times a day and has been running great and then all of a sudden stopped running with the memory error. I am in search of any tips to diagnose or correct this issue[298] SQLServer Error: 701, There is insufficient system memory to run this query. [SQLSTATE 42000]Thanks in Advance |
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2008-01-18 : 17:38:13
|
| What is the query. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-19 : 21:04:10
|
| Is it 32-bit or 64-bit machine? Did you check sql instances' memory usage in perfmon. |
|
|
|
|
|
|
SQL Error 701 insufficient Memory