Administration Guide > System Monitoring with Studio Manager > Studio Manager UI Reference > Requests Panel
 
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 buttonClears 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 buttonImmediately 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 buttonClears the request.
Show Query Plan buttonView 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.