Post reply

DBCC

  • April 23, 2012 at 10:05 pm

    #267847

    Hi All,

    can anybody let me know how can i view what a dbcc command is running internally,

    i mean what store procs etc.

    for example dbcc inputbuffer when i fire this command internally , how do i know what all store procs it is calling. or basically the bosy of this command

    Thanks

  • April 24, 2012 at 12:30 am

    #1477921

    In general the DBCC commands are database engine direct functions, they have thousands of lines of code behind them.

    What is it you are expecting or would like to see?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • April 24, 2012 at 6:02 am

    #1478054

    I would like to see what does it call internally in dbcc pintable

  • April 24, 2012 at 6:15 am

    #1478063

    Call Microsoft and ask them to send you copy of SQL Server source code. Be nice with them and I'm sure they will help you... :hehe:

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

  • April 24, 2012 at 6:27 am

    #1478069

    Eugene Elutin (4/24/2012)

    Call Microsoft and ask them to send you copy of SQL Server source code. Be nice with them and I'm sure they will help you... :hehe:

    Helpful as always Eugene 🙂

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • April 24, 2012 at 6:31 am

    #1478072

    Always trying my best! 😀

    Actually I have a version of compiled machine code for this. It goes something like:

    010001011110100101110111100001110001101110110101011011101001

    010101011101101010101110110011101110111101111011110111111011

    110110110111101111011000110110101101110111110111011010111011

    etc. (It actually few thousand pages, but I can attach the full one on request).

    Traced using hard wiring to CPU bus.

    😉

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

  • April 24, 2012 at 6:37 am

    #1478080

    ananthbhaskar (4/24/2012)

    I would like to see what does it call internally in dbcc pintable

    PinTable in SQL 2008 is dead easy. It does nothing at all. Seriously, it's a NOP.

    Other DBCC command you might be able to view some of what they're doing by checking sys.dm_exec_requests, but anything that they run is internal and not available for users to run, so it's mostly about academic interest. They don't call stored procedures, they call internal functions directly

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 24, 2012 at 6:54 pm

    #1478649

    Thanks all for your time.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply