February 04, 2009, 11:20 AM<SJJustin89>
Resource Analyzer: What specifies a 'request'
I've currently been put in charge of researching, and learning about Resource Analyzer here at our office.
One of the big questions is, what specifies the term 'request'. We have a user that has a incredibly larger amount of requests among all of the others.
I can assume what a request is, but to understand what is going on I need to know what it is physically. Is it once whenever a report is ran? Or is it whenever a table is used? Resulting in numerous user 'requests' every time a report is ran.
Any help is appreciated!
February 26, 2009, 10:06 AMKerry
I passed this one around and here is what I heard from the internal: A request also referred to as procedure, could be a simple TABLE FILE or SQL Passthru to a data source, or multiple TABLE FILE, MATCH FILE, and SQL Passthru in a procedure against data sources. The data sources have to have monitoring enabled or Global monitoring can be enabled which will monitor requests against all data sources including temporary HOLD and SAVE files. Resource Analyzer also monitors the procedure that was submitted and all requests with in it.
Hope this helps.