Question : Running our corporate ERP (Dynamics AX 2012), I noticed our production environment seemed much slower than our development […]
Tag: wait-types
Large Sleep counts causing THREADPOOL wait?
Question : When I run sp_whoisactive throughout the day, I usually see we have around 500-700 connections on our server. […]
Can WAITFOR increase CXPACKET waits?
Question : If I have some T-SQL code like this: While @done<1 Begin WAITFOR DELAY ’00:00:30′; Set @done=<some select statement> […]
Why is sql server waiting for acknowledgment?
Question : I have an application that often request a big set of rows [about 20K] from a sql view, […]
Troubleshooting SOS_SCHEDULER_YIELD wait
Question : Running our corporate ERP (Dynamics AX 2012), I noticed our production environment seemed much slower than our development […]
What is the difference between ASYNC_IO_COMPLETION and IO_COMPLETION wait types?
Question : Could someone explain what is the main difference between these two wait types? Answer : I think you […]
Sp_BlitzWho can get blocked…?
Question : I was playing around with sp_BlitzWho and got blocked by another session. The session was from the DB […]
Is this an excessively large ‘Lock’ time and is it indicative of a problem?
Question : Given: Production environment Application Servers using Hibernate SQL Server Studio Manager v17.5 SQL Server 2016 in a clustered […]
Job waiting on CXCONSUMER
Question : We have got a procedure on SQL Server agent jobs and this job started to hang on transaction […]
Excessive CPU use in vendor SQL Server DB
Question : Background: I’ve got a SQL Server 2012 DB provided by a vendor so modification of queries and tables […]