Tuesday, March 20, 2012

Progress from DBCC SHRINKFILE

Hello,
how can I see the progress of DBCC SHRINKFILE?If you are using SQL Server 2005, you may be able to get percent_complete
from sys.dm_exec_requests. This is often 0 for most operations, but it is
roughly accurate for some (including backup database). Not sure if it
covers DBCC.
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"Matze" <Matze@.discussions.microsoft.com> wrote in message
news:AF8ACF95-6C40-4C60-B9F0-42EA6B28661D@.microsoft.com...
> Hello,
> how can I see the progress of DBCC SHRINKFILE?
>|||Thank you Aaron,
for your reply.
"Aaron Bertrand [SQL Server MVP]" wrote:

> If you are using SQL Server 2005, you may be able to get percent_complete
> from sys.dm_exec_requests. This is often 0 for most operations, but it is
> roughly accurate for some (including backup database). Not sure if it
> covers DBCC.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
>
>
> "Matze" <Matze@.discussions.microsoft.com> wrote in message
> news:AF8ACF95-6C40-4C60-B9F0-42EA6B28661D@.microsoft.com...
>
>|||Yes, it covers DBCC SHRINKFILE and DBCC SHRINKDATABASE in SQL 2005.
Paul Randal
Principal Lead Program Manager
Microsoft SQL Server Core Storage Engine,
http://blogs.msdn.com/sqlserverstor...ne/default.aspx
"Matze" <Matze@.discussions.microsoft.com> wrote in message
news:C3C5DA45-BE31-4E70-A2EA-82CA767FECA5@.microsoft.com...[vbcol=seagreen]
> Thank you Aaron,
> for your reply.
> "Aaron Bertrand [SQL Server MVP]" wrote:
>

No comments:

Post a Comment