Introduction Threadpool is a poison wait. Yes, I mean it. Its poison for SQL Server, its poison for the Business and of course, the end-users! The most devastating thing about threadpool is you hardly recognize it because it comes in disguise, meaning you see no memory or cpu pressure in the system, yet you cannot run any query, it seems like your SQL Server is frozen solid. That scary, isn't it?
Your SQL Server might be facing some performance issues. Let's find out what your SQL Server is going through by thinking like the SQL Server Engine and digging the root cause of the problem.
Comments
Post a Comment