Category Archives: SQL-Server

T-SQL: Check progress of DBCC checkdb

bschelst/ May 10, 2019/ SQL-Server/ 0 comments

Doing a dbcc checkdb can take a lot of time, and in case of corruption you really want to see the progress. You can use the t-sql statement below to find the progress. Keep in mind to replace the YOUR_DB_ID to the id of your database. (find out in sys.databases)

T-SQL: List transactions & log used

bschelst/ February 11, 2019/ SQL-Server/ 0 comments

The code below will list the transactions on the instance, and it will also include the size of the log which is used for that transaction.The output is ordered by log size. You can also use the below to find more info regarding a transaction

T-SQL: Check progress of backup/restore

bschelst/ February 11, 2019/ SQL-Server/ 0 comments

Backups/restores can take a lot of time, but when it’s running, you want so see the progress.By executing the handy T-SQL code below, you can see the progress of the backups/restores on your system.