Each month we report on the most common waits that we see reported by our daily monitoring customers. All the data is sanitized, so there is no private client information to expose here. For this month, here are the details.
- PREEMPTIVE_OS_PIPEOPS
- SP_SERVER_DIAGNOSTICS_SLEEP
- MEMORY_ALLOCATION_EXT
- CXSYNC_PORT
- CXPACKET
- ASYNC_NETWORK_IO
- LCK_M_SCH_S
- LCK_M_S
- PREEMPTIVE_OS_GETPROCADDRESS
- CXCONSUMER
Our daily monitoring product scans your SQL Server hourly and send you email alerts on the status of the server. Also check out our consulting services.
Related Links:
More from Stedman Solutions:
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!