HI, Our main internal application has been dying for last month at the same day on the same day. Looking at everything, We noticed SQl Server Agent was restarting at that time for no apparent reason. This is what we get:
Does anyone know why it's restarting automatically or point me to the link where i can learn more. I would appreciate any help i get. Thanks for your time.
Note: i read somehwere to check if SQl Server is running on "light weight pooling mode". Could someone please tell me how to check that.
Jay [ April 21, 2006: Message edited by: jay donald ]
Joined: Feb 09, 2006
I didn't want to edit the post again! I have checked and it's running on thread mode processing. Could this be it?