Here's a neat query that can help with that:
Select * from sys.dm_exec_requestsThis query returns information about every request that the SQL Server is executing.
One of the columns returned is Percent_Complete. However, this column is only populated for the following commands:
ALTER INDEX REORGANIZEI have four large databases that I have to shrink when they are copied to the development. These can take quite a while, so I use this query to monitor status.
AUTO_SHRINK option with ALTER DATABASE
Check out the documentation for more details!
Post a Comment