September 13, 2017 at 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?
September 13, 2017 at 4:41 pm
krypto69 - Wednesday, September 13, 2017 8:01 AMHI,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
September 14, 2017 at 1:59 am
krypto69 - Wednesday, September 13, 2017 8:01 AMHI,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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply