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]
>

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...
> >
> > Is there away to execute the DBCC SHOWCONTIG without this program
creating a
> > table lock?
> >
> > Thank You,
>

dbcc completed messages

How do you avoid them (from Qa and/or a VB program)?
Thanks in advance!
KOni.
Generally you can specify with no_infomsgs to avoid the "DBCC execution
completed. If DBCC printed error messages, contact your system
administrator." message e.g.
dbcc memorystatus with no_infomsgs
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Koni Kogan" <kkogan@.haiint.com> wrote in message
news:%23fJ2rQnVFHA.3636@.TK2MSFTNGP14.phx.gbl...
> How do you avoid them (from Qa and/or a VB program)?
> Thanks in advance!
> KOni.

dbcc completed messages

How do you avoid them (from Qa and/or a VB program)?
Thanks in advance!
KOni.Generally you can specify with no_infomsgs to avoid the "DBCC execution
completed. If DBCC printed error messages, contact your system
administrator." message e.g.
dbcc memorystatus with no_infomsgs
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Koni Kogan" <kkogan@.haiint.com> wrote in message
news:%23fJ2rQnVFHA.3636@.TK2MSFTNGP14.phx.gbl...
> How do you avoid them (from Qa and/or a VB program)?
> Thanks in advance!
> KOni.

dbcc completed messages

How do you avoid them (from Qa and/or a VB program)?
Thanks in advance!
KOni.Generally you can specify with no_infomsgs to avoid the "DBCC execution
completed. If DBCC printed error messages, contact your system
administrator." message e.g.
dbcc memorystatus with no_infomsgs
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Koni Kogan" <kkogan@.haiint.com> wrote in message
news:%23fJ2rQnVFHA.3636@.TK2MSFTNGP14.phx.gbl...
> How do you avoid them (from Qa and/or a VB program)?
> Thanks in advance!
> KOni.