anybody know what this view is? sys.spt_sproc_columns_odbc_view

  • HI,

    I am looking into a CX packet wait issue - so I ran sp_blitz.

    The results showed that this view sys.spt_sproc_columns_odbc_view - is executed 600 times a minute?!?

    Does anyone know what this does - and is this the normal number of executions?

  • krypto69 - Wednesday, September 13, 2017 8:01 AM

    HI,

    I am looking into a CX packet wait issue - so I ran sp_blitz.

    The results showed that this view sys.spt_sproc_columns_odbc_view - is executed 600 times a minute?!?

    Does anyone know what this does - and is this the normal number of executions?

    A little bit from something similar to what you're seeing. It's called by sp_columns but could be called by other things as well. It's used to get the columns, parameters of a stored procedure. I usually have seen the issue you're seeing but with sp_columns. And the times I've seen them be bad is with jTDS. I don't think I've seen it 600 times a minute though - that seems way out of whack. Maybe try a trace or extended events to see what is calling it all the time.

    Sue

  • krypto69 - Wednesday, September 13, 2017 8:01 AM

    HI,

    I am looking into a CX packet wait issue - so I ran sp_blitz.

    The results showed that this view sys.spt_sproc_columns_odbc_view - is executed 600 times a minute?!?

    Does anyone know what this does - and is this the normal number of executions?

    Its sort of gives you some extensive info on SP's - like how many parameters it takes , column references etc ... Some info on this link

    https://stackoverflow.com/questions/17051941/programmatically-determine-how-many-parameters-in-a-stored-procedure

Viewing 3 posts - 1 through 2 (of 2 total)

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