Give some points about Teradata Viewpoint ?
Answers were Sorted based on User's Feedback
Answer / tdguy
TD viewpoint is a framework where applications are
displayed. This web based framework can be used to manage
and monitor the teradata systems using a browser.
| Is This Answer Correct ? | 18 Yes | 1 No |
Answer / uli
ViewPoint is a separate Server, which collects usage/performance data and presents it via a collection of apps for a general overview, down to a single process.
QueryMonitor, one application in ViewPoint, shows System resource usage like CPU/Spool space/.. -usage, Blocks and blocking process, explain plan ...
QueryMonitor has Rewind capability, to show not only current processes, but is able to go back in time for whatever period the server is configured to hold the data.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / reddy
Teradata viewpoint shows the session ID, user ID,runtime,
expected row count,spool space occupied, approximate
completion time of the query.
Viewpoint shows the details of active sessions only.
| Is This Answer Correct ? | 5 Yes | 8 No |
Why do Hash joins usually perform better than Merge Joins?
Explain the parallel data extension in teradata?
Hi frnds...can any one help me regarding this que.. We have column in a table name it as C1 WHICH CONTAIN ALPHANUMERIC AND NUMERIC VALUES. C1 2A 2B 2V 2H 1 2 3 4 5 i want to retrive numeric values like 1,2,3,4,5 How we can get Plz let me know.Thanks in advance
What is a three-tier data warehouse?
What are the various etl tools in the market?
write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?
How to Skip or Get first and Last Record from Flat File through MultiLoad and TPUMP Utility?
What are the available join types in teradata?
What is the command in bteq to check for session settings ?
if collect stats but it show low confidence why?
I want to load 1000 rcds using. FL for every 100 records there is a check point.But script failed at 120 records, when we are restarting the script, it starts from last ckpt, but Target table contains populated data but FL doesnt support existing data in target table. How can we load data in FL?
how can we analyze the locks ?