While running a trace I noticed the sp_indexes_rowset and sp_table_rowset stored procedures were running numereous times. I can't find any decent documentation that tells me what is calling these? anyone have any info?
I have an ASP application - that for just a couple SQL Statements - causes the sp_indexes_rowset and sp_primary_keys_rowset to get invoked under a separate connection.
I found a KB article 297266 that infers that something about ADO determines that extra meta-data is needed and that causes the above stored procedures to get called - but there is no explaination about the root cause. These statements are being called thousands of times a day and have been at the top of the list of high resource usage statements.
ARe you refering to the tables using the owner.tablename format or are you just using the tablename SELECT a from dbo.tablea versus SELECT a from tablea. If you are not qualifying the table with the owner, try this and see if sQL still needs to fetch Metadata