July 7, 2004 at 4:36 pm
I have a stored procedure that is being executed constantly on the server , but is not being called from any of the asp code. I looked up this proc and found it is and undocumentated sp that will return detail information on the indexes of a table.
Trace information: ( the trace shows hundreds of lines like these, but only with these two tables)
266 6680 250 exec [RBPROD]..sp_indexes_rowset N'PS_X_VEND', NULL, NULL WBQuSvr
343 7451 329 exec [RBPROD]..sp_indexes_rowset N'PS_VEND, NULL, NULL WBQuSvr
Following shows the number of executions:
Stored Procedure: sp_indexes_rowset
Number of executions 207114
Duration 005:29:57.2
Average statement duration 000:00:00.1
Samples per second 10.53
Any Ideas??
thank you very much,
BrianText
July 12, 2004 at 8:00 am
This was removed by the editor as SPAM
August 13, 2004 at 8:22 am
I think this sp is called from ADO or other MDAc type components.
August 13, 2004 at 8:26 am
I think this sp is called from ADO or other MDAc type components.
October 1, 2004 at 8:34 am
I have been experiencing the same problem. I posted this question on a different sight and the comments I revieved were that it might be coming from ADO and that if the table wasn't fully qualified (ie dbname.dbo.tablename) that this might be causong ado to fetch the meta data. So far I haven't been able to track down the culprit in our app.
August 3, 2005 at 8:06 pm
Hi All, I am getting the same thing. Has anyone managed to find a solution to this yet?
It definitly has something to do with ADO.
January 5, 2006 at 6:58 am
It appears to be executed also when remote queries are run (ie using linked servers).
I am having issues with queries 'hanging' while DBReindex is running on ANY table in a DB. Depending on the code it will also timeout. I'm still trying to figure out if it is doing any kind of schema lock at the same time. The queries get blocks and appear to be waiting on sp_indexes_rowset completion when these hangs occur. In general, I'm also having trouble with some applications not working properly while optimizations jobs are running while others do not have issues. There are a couple other SPs I have found that get executed immediately before the one in questions for a linked query: sp_tables_info_rowset and sp_columns_rowset .
If anyone has moe information on just when these SP get executed it would help tremendously in my figuring out what is going on during certain index reubild operations.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply