Thanks Pradeep,

Iam facing the below error after changing the Max Worker Threads Setting from 500 to 0.

In Event viewer and SQLServerLog

Error: 18456, Severity: 14, State: 27.Login failed for user 'xxxxxx'. [CLIENT: 192.168.30.180]

Error: 18056, Severity: 20, State: 27.The client was unable to reuse a session with SPID 187, which had been reset for connection pooling. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.

-------------------------------------------------------------------------

in SQLServer Agent Error log

"2010-11-29 10:05:44 -

! [382] Logon to server '(local)' failed (ConnUpdateJobActivity_NextScheduledRunDate) 2010-11-29 18:08:29

! [298] SQLServer Error: 258, Shared Memory Provider: Timeout error [258]. [SQLSTATE 08001] 2010-11-29 18:08:29

! [165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00] 2010-11-29 18:08:29

! [298] SQLServer Error: 258, Unable to complete login process due to delay in prelogin response [SQLSTATE 08001] "

Can you please advise whether this issue is related to Max Worker Threads Setting and

also I can see CPU usage is 100 %.

Your quick response is much appreciated.

Thanks and Regards,

Ravichandra.