Requests Panel
The Studio Manager Requests panel displays:
• Summary information about requests activity at top of the panel.
• Details about the status of each request at the bottom of the panel.
• Status—Aggregated status of all requests can be OK, Warning, Error, or Unknown. A single warning or error supersedes display of a status of OK. When failed requests or waiting requests are present, a count of those warnings or errors will be shown.
• Server Requests (Total and Active)—The total number of requests made to the server since the server was started and the number of currently active requests.
• Data Source Requests (Total and Active)—The total number of requests made to the data sources since the server was started and the number of currently active requests.
• Internal Requests (Total and Active)—The total number of internal requests made to the server since the server was started and the number of currently active requests.
• Total Bytes From Data Source (Estimated)—An estimate of the total number of bytes of data sent to the data sources since the server started.
• Total Bytes Into Data Source (Estimated)—An estimate of the total number of bytes of data received from all data sources since the server started.
• Waiting Requests—Current number of requests waiting in the queue due to memory constraints.
• Waiting Requests Threshold—An event trigger threshold that causes an event. The event can be used for notification.
• Memory Utilization—Amount of memory currently in use by TDV.
• Clear Plan Caches button—Clears all query plan caches, in the event that current statistics gathering can have significantly changed information sufficient to change the query execution plan. Forces recalculation of all query plans at next time of execution which will be an initial performance hit.
• Purge Completed Requests button—Immediately removes all completed and failed requests. This is useful to reset the view prior to testing a set of requests.
Request Details in Studio Manager
In the Request Details pane, you can select the row and then perform these actions:
• Cancel button—Clears the request.
• Show Query Plan button—View the query plan for a request. This action displays the full query plan of the request with statistics. You can use the plan to diagnose any type of query.
• Click the Info button to view the row details.
By default, the requests in the
Details table are sorted in the order they are received (oldest first). See
Request Details in Studio Manager for more information.
You can also monitor requests in Manager. See
REQUESTS page for more information.