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 |
|
dejjan
Yak Posting Veteran
99 Posts |
 Posted - 2007-08-31 : 03:35:14
|
| This is first time I've got this kind of message:Server: Msg 701, Level 19, State 1, Line 1 There is insufficient system memory to run this query.With restart everything works fine. But still, I would like to know what cause this problem. Does anybody knows ? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-31 : 16:16:03
|
| How much memory does the server have and how much used by sql? What's total db size? |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-09-04 : 15:35:06
|
your query must be a monster  too nested/deep, lots of parallel thingie... check the execution plan... divide and conquer is the keyHTH--------------------keeping it simple... |
|
|
|
|
|
|
Server: Msg 701, Level 19, State 1, Line 1 There i