June 13, 2017 at 12:00 am
Hi there,
We have received several alerts from SCOM with regards to the Thread count of one of our server being too high. The article below give an indication the max threads on your SQL instance.
Our result was 512 threads on our SQL instance. The Cost threshold for Parallelism is 50 and MAXDOP is set to 4.
How do I go about troubleshooting what is causing the high thread count? We have checked SCOM to see whether it could be the CPU running high but this is not the case.
Your advice would be grately appreciated.
Regards
IC
June 13, 2017 at 1:40 am
How does SCOM decide that the thread count is high? High thread count doesn't always equal high CPU. What is a high thread count is going to depend on your system. How many cores has the server got, are you using AGs, replication, mirroring? What sort of throughput is going through SQL server?
Is a lack of threads really a problem? Check your wait stats, if you're seeing high THREADPOOL waits then you could have issues, if not then I don't think I'd be worrying about it.
https://sqlundercover.wordpress.com/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply