Arsh - Monday, August 14, 2017 9:05 AM
No. Because what's normal for your server may indicate a severe problem on mine.
For the CXPACKETS , parallelism reduction is also under consideration for some SPs
Excessive parallelism is usually due to inefficient queries or poor indexing. Focus on that first. Especially since a common cause of PageIOLatch waits is inefficient queries that access too much data and hence churn the buffer pool.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability