SQL Server Blog

CXPacket Wait Type Count Investigation

January 10th, 2012

High CXPacket Wait counts in an OLTP environment can be used as an indication towards performance issues relating to Query Parallelism in your environment due to having multiple cores available. 

Tweet
Pin
Share
0 Shares
Read More
Blog

Hi, I'm Warwick Rudd, I am a Microsoft Data Platform MVP as well as a Microsoft Certified Master working as the Principal Consultant here at SQL Masters Consulting.
In my blog I will look at all things SQL Server as well as some things outside of the SQL Server relm but hopefully you will find them helpful and interesting.

Search
Recent Posts
Data Saturday Event CreationEnabling SQL Agent Service after Upgrading from ExpressSSMS Tips and TricksArc Enabled Data Services – 12Arc Enabled Data Services – 11
Categories
AlwaysOn Availability Groups Arc Data Services Availability Groups Azure Azure Data Studio CosmosDB Data Database DevOPs Database Lifecycle Management DevOPs Disaster Recovery DLM General High Availability JSON Kerberos Performance Power BI Presentations Reporting Services Security Service Broker Service Packs SMC SQL SQL Server 2005 SQL Server 2008 SQL Server 2008 R2 SQL Server 2012 SQL Server 2014 SQL Server 2016 SQL Server 2017 SQL Server 2019 SQL Server 2022 SQLServer SQLServerCentral T-SQL T-SQL Tuesday TSQL Uncategorized
Archive
  • 2024
  • 2023
  • 2022
  • 2021
  • 2020
  • 2019
  • 2018
  • 2017
  • 2016
  • 2015
  • 2014
  • 2013
  • 2012
  • 2011
  • 2010