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...
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
Tue, Sep 4 2007
Filed under: Filed under: sql server, stats, performance, blocking, tuning, query, stored procedure, statistics, parallelism, contribution