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 |
|
harrycaul
Starting Member
1 Post |
 Posted - 2003-05-25 : 14:59:37
|
| We are seeing the errors described in this knowledge base item:http://support.microsoft.com/default.aspx?scid=kb;en-us;282229More specifically, stuff like:2000-11-27 11:22:59.87 server SQL Server could not spawn process_loginread thread.2000-11-27 11:55:06.09 spid431 WARNING: Failed to reserve contiguous memory of Size= 65536.The knowledge base indicates that this is an issue with the sp_OA stored procedures, and that it is fixed in Sql Server Service Pack 1. However, we have Service Pack 3 installed and are still seeing it.I'd like to know:1) what's going on, and how do I fix it? Other than this KB item, MS is sparse on details2) how can I monitor my sp_OA* stored procedures, so I can determine what applications are calling them?Thanks,Monsur |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-05-25 : 16:40:46
|
| Hi!You can monitor what application calls the procedures by using SQL Profiler and setting up a trace. |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-05-25 : 19:03:19
|
| I think it's just saying that it has run out of memory which could be due to anything.Theres another one at 299466 also fixed in sp1.Do you use a lot of sp_oa sps?Might be worth whiile setting up a system to loop through a call and see if it crashes.Other than that monitor your memory usage.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Was this fixed in SP1?