SQLSolutions and SSIS

Wednesday, October 23, 2013

How to check Shrink Process Progress

SELECT
 percent_complete,
 start_time,
 status,
 command,
 estimated_completion_time,
 cpu_time,
 total_elapsed_time
FROM
 sys.dm_exec_requests
WHERE
 command = 'DbccFilesCompact'
Posted by MySql at 10:58 PM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2016 (3)
    • ►  July (3)
  • ►  2014 (24)
    • ►  December (2)
    • ►  November (2)
    • ►  September (1)
    • ►  August (1)
    • ►  April (1)
    • ►  March (8)
    • ►  February (1)
    • ►  January (8)
  • ▼  2013 (123)
    • ►  December (20)
    • ►  November (1)
    • ▼  October (8)
      • SSIS Useful Links
      • SSIS - How to configure a Foreach Loop Container: ...
      • How to check Shrink Process Progress
      • SQL SERVER – Find First Non-Numeric Character from...
      • TSQL INTERVIEW QUESTIONS [Database Interview Quest...
      • SSIS Interview Questions
      • Converting multiple rows into a single comma separ...
      • PIVOT Example
    • ►  September (48)
    • ►  July (7)
    • ►  June (10)
    • ►  May (11)
    • ►  April (16)
    • ►  January (2)
  • ►  2012 (1)
    • ►  December (1)

About Me

MySql
View my complete profile
Awesome Inc. theme. Powered by Blogger.