Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning LATCH_EX and CXPACKET waitstates are too high RE: LATCH_EX and CXPACKET waitstates are too high

  • February 27, 2015 at 6:57 am

    #1780577

    Thanks for your valuable reply,

    I googled found Parallelism in SQL Server is for Operators involved( actually its bit more but for practical purpose note this) not for the query, thats why i am seeing more sessions than specified in MAXDOP.

    I found following article that describes it in detail:

    http://blogs.msdn.com/b/sqlserverfaq/archive/2009/01/05/why-do-i-see-more-threads-per-spid-in-sysprocesses-than-maxdop.aspx

    -----------------
    Aditya Rathour
    SQL DBA

    Not Everything that is faced can be changed,
    but nothing can be changed until it is faced.