Thread using 50-100% CPU usage: MSVCR80.dll! Endthreadex
I have sql 2005 sp1 and you have noticed a lot of MSVCR80.dll! endthreadex threads using Process Explorer taking all the cpu on the server and they never go away until you kill it or restart the sql server? Does anyone know any work around like how to end or stop this because it happens every day.
source to share
MSVCR80.dll! endthreadex doesn't mean anything. The MSVCR80 DLL is used to execute C ++ code compiled with Visual Studio 2005 (and I assume SQLServer 2005 was compiled with Visual Studio 2005). You can check that you have the latest C ++ Redistributable installed .
SQLServer starts worker threads on startup. This is normal. If you see that these threads are taking up the CPU, it means that your database is running. Users are querying the database, or the database is trying to resolve internal work that it cannot complete because you keep reloading it.
Using Process Explorer to diagnose SQLServer performance problems won't get you very far. You must use the SQL Server Profiler to determine what work is being done on the database.
source to share