MS SQL Server - SqlServer.exe Thread suspension

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

SqlServer.exe Thread suspension

Amol Surati

2006-03-27, 3:23 am

Hi,

I have a problem with the sqlserver.exe and sqlagent.exe threads and
my file system filter driver. I have been trying to solve the problem,
taking help from NTFSD group on OSROnline, but have not yet been successful
in doing so.

I am using sql server 2000 + SP3.

The problem is regarding the behaviour of SQL server threads on starting up
the SQLSERVER and SQLAgent services. On starting up those services, the
system hangs and a symptom I see during the hang is that the sql server
threads are suspended.

Do some threads of sqlserver.exe and sqlagent.exe suspend themselves when
sql server services are started? If that is the case, why do they do so and
is there any way I can change the behaviour (through some config settings)?

Thanks in advance,
Amol

Sponsored Links