![]() For example, the executing of a SELECT query, ADS might wait 3 seconds for the query to execute on the server (CPU Server Cycles), then another 5 seconds retrieving results (Network Transfer Cycles). Server wait time: Server wait time: This is the amount of time ADS spends waiting on the server during server-side methods calls to execute and retrieve results. #Aqua data studio direct output to a file plus#This is the Script Execution time plus the UI time to process the results and display them.Ĭlient Processing: This is the Total Processing time minus the server wait time. Total Processing: This is the amount of time it takes from the second you click Execute until ADS finishes displaying all of the results on the screen. ![]() ![]() Grid Results are the preferred method of viewing query results in the Query Analyzer.Ĭlient Statistics - Displays detailed statistics on the execution of the statement or script. When there are multiple statements separated by GO or /, the SQL Preview icon at the top left of each Grid Result assists in identifying what statement generated each Grid Result.Įnabling ONLY Grid Results BEFORE querying a large results sets (100,000 rows or more) vastly increases Aqua Data Studio's speed, and dramatically lowers its memory footprint. The Quickfilter at the top right of the grid rapidly filters what results are currently displayed. Aggregate Functions display statistics on selected data from the grid. The column headers in the grid can be rearranged by dragging them, and sorted by CTRL + Click for multiple columns. The Grid Results offers an expansive set of features for sorting, searching, saving, printing and other functionality. ![]() Grid Results -Results are displayed in a grid which can be sorted by clicking on column headings. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |