![]() |
Hi,
18 Feb 2016
,
|
![]() |
Hi guys,
18 Nov 2015
| 1 comment
,
|
![]() |
This session will discuss Application Query Tuning on the Teradata platform.
04 May 2015
,
|
![]() |
Are any conversion scripts needed for upgrading from TD 14.00 to 14.10?
31 Mar 2015
,
|
![]() |
Have you ever wished for a magic wand that could quickly point out the missing, stale, and unused statistics for you?
11 Feb 2015
,
|
![]() |
This presentation reviews the benefits of collecting performance data on the Teradata platform.
15 Dec 2014
,
|
![]() |
Hi all,
05 Dec 2014
| 1 comment
,
|
![]() |
Hi,
20 Nov 2014
| 2 comments
,
|
![]() |
Hi all. We use PDCR to archive our DBQL tables - the primary index on the tables is (logdate,procid,queryid) and they are partitioned by logdate.
22 Aug 2014
,
|
![]() |
Hi all. I have a requirement to generate reports based on our operating windows via DBQL. As the operating windows are subject to change, I would like to use the OpEnvName field that is populated via the PDCR process.
05 Aug 2014
| 2 comments
,
|
![]() |
Is there a field in DBQL that returns the name of the script in which a command is executed?
16 Apr 2014
| 1 comment
,
|
![]() |
Hello Everyone,
I have read that DBQL and ResUsageS tables, views and macros are important for system capacity planning. For example ResUsageSpma and ResNode. But what about the other tables and views. Are they also monitored for capacity planning ?
31 Mar 2014
,
|
![]() |
The DBQL setup and maintenance documents provides scripts, as well as information on how to perform DBQL logging, maintenance, and upgrade, now including Teradata 14.0.
28 Jan 2014
,
|
![]() |
Hi, I have put together a dashboard showing all the AMPCPUTime consumed by our various workloads based on the data from the DBQL LOG table column, AMPCPUTime. I want to add the Idle time into this so that management get an accurate picture of what is going on the system.
01 Jan 2014
| 1 comment
,
|
![]() |
Hi All,
17 May 2013
,
|
![]() |
Hello,
05 May 2013
| 1 comment
,
|
![]() |
Have you ever struggled over whether, or how, to use a new database feature? In this presentation, we’ll demonstrate how database query log (DBQL) data can help when it comes to determining candidates for MLPPI (Multi-Level Partitioned Primary Index) as well as the new Columnar Partitioning feature of Teradata 14.
03 Apr 2013
,
|
![]() |
I am considering the impementation of algorithmic compression within our 13.10 system's DBQL History tables. We have quite a long retention requirement for this data and the daily maintenance and nightly backups are starting to become an issue because of the large sizes.
20 Mar 2013
| 2 comments
,
|
![]() |
Hello,
17 Dec 2012
,
|
![]() |
I have noticed in the DBQL logs that there has been a number of records in the dbqlsqltbl.SQLTEXTINFO table and column that contain the value of "SELECT ?". It appears that this is due to a columns that is being CAST as CLOB. My first question : Is this expected? The second question: Can DBQL be modified so that these rows are not logged into the
27 Nov 2012
| 1 comment
,
|
![]() |
Hello,
20 Oct 2012
| 2 comments
,
|
![]() |
Hi, In release 13.10, is it possible that ProcID and QueryID exists in QryLogObjects but not in QryLog? In my client site, I found this issue happened. As a result, I'm not able to get column access by user for some mismatch ProcID and QueryID. We have turned on DBQL logging with object.
03 Sep 2012
,
|
![]() |
Hi , 1 = Found in the resolver • 2 = Accessed during query processing • 4 = Found in a conditional context • 8 = Found in inner join condition • 16 = Found in outer join condition
30 Aug 2012
| 5 comments
,
|
![]() |
Starting in Teradata 13.10, there is a single delay queue for all throttles. This means that queries delayed by system throttles will reside in the same queue as queries delayed by workload throttles. In earlier releases, delay queues were set up independently by type of throttle, and each workload throttle had its own dedicated queue. Bringing together all delayed objects into a single queue streamlines the entire throttling experience and makes it easier and more accurate to manage internally. However, as a side-effect, the DelayTime field in DBQL needs a second look. DelayTime takes requires slightly different interpretation in 13.10 than you gave it in earlier releases.
16 Jul 2012
| 38 comments
,
|
![]() |
|
![]() |
|
![]() |
One of the more difficult challenges in database management and administration is determining where and how to implement a new RDBMS feature or function. In this presentation we’ll look at the DBQL data available for evaluation of tables and columns used within a workload and how this data can be leveraged for determining candidates for MLPPI (Multi-Level Partitioned Primary Index).
24 Aug 2011
,
|
![]() |
Hi All, Is there a way to track users who access a particular database in the data warehouse? Would this be done thru the DBQL? Are there any "standard" sql reports that exist for this kind of reporting? This is needed for security reporting requirments. Thanks! Paul
25 Jan 2011
| 1 comment
,
|
![]() |
This presentation will provide recommendations and guidelines for using leading practices to enable system and performance tuning. You will learn the benefits of using Teradata's most recent set of recommendations to manage workloads on a Teradata system. For example, by using Teradata's data collection guidelines, recommendations for Account Management and Logging, a user will be able to identify, analyze and tune problem queries for better performance. This presentation will also focus on how to use the tools provided in the Teradata Analyst Pak.
01 Nov 2010
,
|
![]() |
My batch is completing late, the tactical queries show inconsistent response times, some applications show extreme variability in resource consumption, the canaries are hoarse!
19 Aug 2010
,
|
![]() |
According to my understanding, the value returned by subtracting StartTime from FirstRespTime should be equal to AMPCpuTime. But this doesnt seem to work. Can anyone please help me understand how are all these values related/calculated?
08 Jun 2010
| 4 comments
,
|
![]() |
Under Construction.
28 Oct 2009
| 11 comments
,
|
![]() |
26 Aug 2008
| 1 comment
,
|
![]() |
16 Aug 2007
| 2 comments
,
|
![]() |