Home » 2019
Yearly Archives: 2019
Error : DBCC could not obtain a lock on this object because the lock request timeout period was exceeded
DBCC CheckDB failed with error “DBCC could not obtain a lock on this object because the lock request timeout period was exceeded” Error: Today, My DBCC checkdb job failed with below error. Executed as user: USERNAME. Object ID 451805713 (object ‘dbo.AEETBL’): DBCC could not obtain a lock on this object because the lock request timeout … Continue reading
BIOS and OS Power Settings to enhance SQL Server Performance
Performance is always a most prioritized task for any DBA and every DBA always prefer to go for a proactive approach and keep your system’s performance on top rather than reactive when it comes to addressing user complaints. SQL Server is a complex system and due to the continuous increasing size of data and multiple … Continue reading