Date initiale ale problemei : Windows Server 2003 R2 Standard SP2 pe 64 biti, 4 GB RAM , un Sql Server 2005 (9.00.3077.00 )pe 64 biti si un soft proprietar de ERP - daca fac upgrade la Sql Server sau Windows nu mai asigura suport etc...
Simptome : In ultima luna s-a blocat de 2 ori aplicatia de ERP, precum si o aplicatie proprie a dat erori de conectare.
In event log de Application ERP scrie : "Unable to log event." - asta inseamna la el ca nu a putut scrie in BD.
Event log de System / Security este fara mesaje deosebite la ora respectiva.
In Sql Server log , in jurul orei respective , sunt mesaje de genul :
Resource Monitor (0x718) Worker 0x000000008000C1C0 appears to be non-yielding on Node 0. Memory freed: 13528 KB. Approx CPU Used: kernel 125 ms, user 15 ms, Interval: 64998.
In sfirsit aplicatia proprie imi trimite erori de genul :
"System.Data.EntityException: The underlying provider failed on Open. ---> System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
"
System.Data.EntityException: The underlying provider failed on Open. ---> System.Data.SqlClient.SqlException: A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
Pare sa fie blocare de conexiune ... dar nu am mai intilnit pina acum. Softul este utilizat intern - sa zicem ca sunt 100 de oameni ? Oricum, ERP + aplicatia mea folosesc autentificare Sql Server - un singur cont pentru toti oamenii ...
Am gasit ceva legat de mutarea paginilor in memorie, dar nu cred ca e asta - si, pe deasupra, implica mutarea contului sub care ruleaza serviciul de Sql Server).
Astept pareri/idei/sugestii, de ex. cum as putea monitoriza? Si la ce ar fi buna monitorizarea?
Multumesc,
Andrei
Ignat Andrei
http://serviciipeweb.ro/iafblog