Through below Query we can find out CPU Pressure in SQL Server If Signal wait shows 15-18 % then it’s
Continue readingTag: SQL Server performance Issue
How to Find all waiting tasks currently active or blocked in SQL Server?
We can find out all the waiting tasks or blocked session in SQL server through below script. SELECT blocking.session_id
Continue reading