Understanding ASYNC_IO_COMPLETION Wait type in SQL Server

Normally, ASYNC_IO_COMPLETION Wait type can be seen during backup and restore activities. Whenever you will see this wait type your…

How to fix BACKUPBUFFER Wait Types?

Today I was working on an issue in which backup job was showing in executing state since last 2 days.Initially…

How to Fix RESOURCE_SEMAPHORE Wait Type in SQL Server?

RESOURCE_SEMAPHORE waits occurs when a query memory request cannot be granted immediately due to other concurrent queries. High waits and…

What is SQL Server Wait Type? or How to get wait type info in sql server?

 Wait Types are awesome way to troubleshoot performance related issues. In SQL Server 2005 and later version we can get…

How to know Database Version or Build no from a Backup File?

Generally we don't need this info for user database but when you have to recover or restore master database then…

How to Recover or Repair Suspect Database in SQL Server

Suspect database in SQL Server is not very common issue but there are times we face it because of various…

Error 14258: Cannot perform this operation while SQL Server Agent is starting. Try again later

 I saw SQL Server error 14258 today while i was diagnosing my log shipping issue in which primary and standby…

How to Disable AutoCommit in SQL Server?

Autocommit mode is the default transaction management mode of the SQL Server Database Engine. Every Transact-SQL statement is committed or…

How to get Last Restore Time of your database?

Database Backup and restores are common task for any database administrator.  We generally do lot of restore operations to fulfill…