thread count

  • We are getting scom alerts SQL server xxxx thread count is too high MSSQLserver .

    I am not sure how to trouble shoot and solve this type of alert , can any one provide the steps to trouble shoot and fix the issue ?

  • It may be many single threaded requests are running concurrently, or some requests are running with parallelism.

    A table scan will most likely cause parallelism.

    Check you CXPacket waits stats.

    You may be in need of either an index, or a change to the code so that it can use an index or at least let you know that it needs an index.

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply