SQL Server Performance Forum – Threads Archive

ERROR: SQL Server could not spawn process_loginrea

After SQL Server option change we got this error. SQL server didn’t allow any client connections and the only way to bring it to normal work was the restart. Let me provide last events from SQL server logs: Configuration option ‘nested triggers’ changed from 1 to 0. Run the RECONFIGURE statement to install. Error: 15457, Severity: 0, State: 1 Configuration option ‘show advanced options’ changed from 1 to 1. Run the RECONFIGURE statement to install.. SQL Server could not spawn process_loginread thread. this error had shown up about 10min till we restarted the server After some google I’ve found that this error tells about memory leak. Our SQL server memory configuration was set to dynamic from 0 to 4GB. Our version: Microsoft SQL Server 2000 – 8.00.2039 (Intel X86) (sp4) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
Does anyone know what causes were of this?

Error 15457 is an informational message when you change any server specific configuration.
FOr the spawn error refer to this KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;893312 and KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;316749 links. HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Thanks for reply. I’ve already checked these KBs, and I think that there is something else

http://www.sql-server-performance.com/sql_server_performance_audit5.asp for further audit. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>