Performance

LOGMGR_QUEUE wait types are often seen but little understood in the field of SQL server performance optimization. To demystify LOGMGR_QUEUE wait types by giving you a thorough understanding of what they involve, why they matter, and how to handle them in your SQL server setup. Introduction It’s typical for database administrators and developers to run … Read more

Understanding and controlling wait kinds is essential for improving SQL server performance. LCK_M_IS, or Lock Manager Intent Shared, is a wait type that appears when several SQL Server transactions or processes simultaneously seek shared locks on a resource. These joint locks signify a desire to read data without changing it. Introduction A typical need in … Read more