Archives of the TeradataForum
Message Posted: Wed, 25 Aug 2004 @ 13:12:31 GMT
| Subj: || || Re: Useful Stats for Management |
| From: || || Hassinger, Bill |
I agree with Chris. The value in the warehouse is through the users. Getting physical stats means little in a DSS environment like ours.
Query counts or statistics are inflated by report development and some applications count an insert for each row of a batch. High CPU use can be
more a function of poor query design then actual resource need.
The value must be derived by the accuracy and timeliness of the data. We survey users periodically to see their perception of the value of the
warehouse. In many cases our usefulness has filtered up from line staff responsible for producing the reports to managers. I would admit that it
would be nice if the data could be presented directly on the manager's desktop in a meaningful format, but on the other hand this can limit the
versatility of the warehouse. A standard report can't be created for every question a manager may have.