Posted in
Windows Server |
No Comment | 2,710 views | 04/03/2015 10:36
If you want to see SQL Server Shrink status, you can use following query:
SELECT
percent_complete,
total_elapsed_time,
start_time,
status,
estimated_completion_time
FROM
sys.dm_exec_requests
WHERE
command = 'DbccFilesCompact' |
SELECT
percent_complete,
total_elapsed_time,
start_time,
status,
estimated_completion_time
FROM
sys.dm_exec_requests
WHERE
command = 'DbccFilesCompact'
You can execute this query via SQL PowerShell cmdlet.
This is also a reminder for me :)
home
projects
about
contact
follow
feed
settings
