With databases sometimes you need to run tasks that take a while in order to complete. In the past I have found it hard to judge the status of a request. For example, we do backups and restores of a 40 GB database.
Normally this doesn’t take very long to accomplish (30-40 minutes) but there is no sort of progress bar on the query to judge complete a specific task is. Luckily after hunting through Google for a while I found a query that you are able to run to find how complete system tasks are. The query is as follows:
SELECT session_id, command, percent_complete FROM sys.dm_exec_requests
This query will return a list of the commands currently running as well as the percentage complete.
Status of Long Running Tasks