DBCC SHOWCONTIG (No Lock)

Is there away to execute the DBCC SHOWCONTIG without this program creating a
table lock?
Thank You,
I think that the FAST option will take a light-weight lock (if any). And it is a lot faster.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Joe K." <JoeK@.discussions.microsoft.com> wrote in message
news:C763E461-B833-4DBF-B8E9-E7222F73DB4F@.microsoft.com...
> Is there away to execute the DBCC SHOWCONTIG without this program creating a
> table lock?
> Thank You,
|||The FAST option will only take a table IS lock rather than a table S lock.
That's as non-blocking as it can do.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:unLlLucvEHA.3640@.TK2MSFTNGP10.phx.gbl...
> I think that the FAST option will take a light-weight lock (if any). And
it is a lot faster.[vbcol=seagreen]
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Joe K." <JoeK@.discussions.microsoft.com> wrote in message
> news:C763E461-B833-4DBF-B8E9-E7222F73DB4F@.microsoft.com...
creating a
>

DBCC SHOWCONTIG (No Lock)

Is there away to execute the DBCC SHOWCONTIG without this program creating a
table lock?
Thank You,I think that the FAST option will take a light-weight lock (if any). And it
is a lot faster.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Joe K." <JoeK@.discussions.microsoft.com> wrote in message
news:C763E461-B833-4DBF-B8E9-E7222F73DB4F@.microsoft.com...
> Is there away to execute the DBCC SHOWCONTIG without this program creating
a
> table lock?
> Thank You,|||The FAST option will only take a table IS lock rather than a table S lock.
That's as non-blocking as it can do.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:unLlLucvEHA.3640@.TK2MSFTNGP10.phx.gbl...
> I think that the FAST option will take a light-weight lock (if any). And
it is a lot faster.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Joe K." <JoeK@.discussions.microsoft.com> wrote in message
> news:C763E461-B833-4DBF-B8E9-E7222F73DB4F@.microsoft.com...
creating a[vbcol=seagreen]
>