undocumented DBCC comand 
Author Message
 undocumented DBCC comand

has anyone tested this command

        dbcc capture_tds pid

for System 11 running on Solaris 2.5.x

thanks
Rashed
(it is only a development system)



Sat, 09 Oct 1999 03:00:00 GMT
 undocumented DBCC comand

Quote:

> has anyone tested this command

>    dbcc capture_tds pid

> for System 11 running on Solaris 2.5.x

How about an example?  I was trying it out on my test SQL
Server.... but wasn't sure if PID was the PID of the dataserver,
connection or really the spid.  Thx!
--

--------------+-----------------+--------------------------------------------



Sun, 10 Oct 1999 03:00:00 GMT
 undocumented DBCC comand

Quote:


>> has anyone tested this command

>>        dbcc capture_tds pid

>> for System 11 running on Solaris 2.5.x

>How about an example?  I was trying it out on my test SQL
>Server.... but wasn't sure if PID was the PID of the dataserver,
>connection or really the spid.  Thx!
>--

>--------------+-----------------+--------------------------------------------


the pid I understand is the process id whose tds output is being
captured. However this can be for the entire server process.  The
other flavor that I know of is

        dbccinfo capture_tds pid

I am not sure for the difference between dbcc and dbccinfo.
There is also another command that runs fine .i.e.

        dbcc pss {all | susername} {all | spid} {all | header}

this command seems to work fine.  If you execute
dbcc pss(0,0,1)  
you will get all kinds of info. Don't forget the trace flag 3604

Rashed



Sun, 10 Oct 1999 03:00:00 GMT
 undocumented DBCC comand

Quote:

>      dbcc capture_tds pid

> for System 11 running on Solaris 2.5.x

The capture_tds dbcc command stopped working, or at least I was never able to
get anything out of it at _least_ with System 11, and possibly earlier.

Quote:
>other flavor that I know of is

>        dbccinfo capture_tds pid
>I am not sure for the difference between dbcc and dbccinfo.

The dbccinfo is the name of a UNIX sh script that I wrote way back when
(dataserver 4.x), that simply executed all of the undocumented dbcc commands,
and made them easier to run.  Follow the URL in the sig if interested, but be
careful.

Quote:
>There is also another command

that runs fine .i.e.

Quote:
>        dbcc pss {all | susername} {all | spid} {all | header}
>this command seems to work fine.  If you execute
>dbcc pss(0,0,1)  
>you will get all kinds of info. Don't forget the trace flag 3604

Note with the 11.0.2.2, SWR6886 release on Solaris the pss output includes the
last T-SQL command executed by the pid.  Something lots of people have been
wanting to get at for a long time.

Al

Al Huntley                     423 576-7170
Lockheed Martin Energy Systems FAX: 423 574-8149


              http://members.aol.com/huntleyad/index.htm      



Fri, 15 Oct 1999 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. DBCC undocumented procedures

2. documented undocumented dbcc?????

3. Undocumented Stored Procedures / DBCC

4. Undocumented DBCC markdirty command ???

5. Undocumented DBCC and TRACE FLAGS

6. DBCC ExtentCheck + DBCC RebuildExtents

7. DBCC SHRINKDATABASE ... DBCC SHRINKFILE

8. DBCC INDEXDEFRAG and DBCC DBREINDEX - on SQL Server 2000

9. DBCC INDEXDEFRAG and DBCC DBREINDEX

10. DBCC CHECKCATALOG part of DBCC CHECKDB?

11. dbcc sqlperf (logspace) vs dbcc checktable (syslogs)

12. DBCC CHECKCATALOG part of DBCC CHECKDB?


 
Powered by phpBB® Forum Software