query, stored procedure, parallelism - SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)

Browse by Tags

TSQL to obtain a list of current execution of Parallel Plans (MAXDOP) Published 4 September 7 9:32 AM | SSQA.net: PARALLELISM is a close friend of DBA where you get to see it as a common occurence in the multi-processor server environment and during such performance issues you can also investigate whether a parallel plan is in use. For instance If a particular query...

Filed under: sql server, stats, performance, blocking, tuning, query, stored procedure, statistics, parallelism, contribution