C
CSMcFadden
Guest
First post here - help me improve if I state something wrong.
I want to know which tables are being read by a query.
for each Customer where CustomerID = 12345.
Eventually this customer will be found in the following example, but progress must 'read' many tables before getting to customer 12345.
How do I know exactly which tables are read (By CustomerID), prior to getting to customer 12345?
*NOTE: I do not have access to modify the code being run for this selection. Ideally I would run a separate set of code that is executed at the same time as the customer query above to track the reads.
I am familiar with VSTs for _IndexStats and _TableStats but those just seem to keep a tally of 'how many' tables were read, not 'which ones' were read.
I also thumbed around in Promon but did not see an option that fit the bill. Is this possible?
Continue reading...
I want to know which tables are being read by a query.
for each Customer where CustomerID = 12345.
Eventually this customer will be found in the following example, but progress must 'read' many tables before getting to customer 12345.
How do I know exactly which tables are read (By CustomerID), prior to getting to customer 12345?
*NOTE: I do not have access to modify the code being run for this selection. Ideally I would run a separate set of code that is executed at the same time as the customer query above to track the reads.
I am familiar with VSTs for _IndexStats and _TableStats but those just seem to keep a tally of 'how many' tables were read, not 'which ones' were read.
I also thumbed around in Promon but did not see an option that fit the bill. Is this possible?
Continue reading...