SQL to check Cylinder Migration
/* SQL to check Cylinder Migration */
/* make sure the collectintervals value is set correct */
SELECT TheDate,
CAST((CAST((TheTime (FORMAT '99:99:99')) AS CHAR(8))) AS TIME(0)) AS TheTime,
SUM(FileCylAllocs),
SUM(FileCylMigrs),
SUM(FileMCylPacks),
SUM(FileCylDefrags),
(AVG(FileCylMigrs) / MAX(FileCylMigrs)) * 100 AS VprocCylMigrsParallelEff
FROM dbc.resusagesvpr
WHERE collectintervals = '2' AND
vprtype = 'AMP'
GROUP BY 1,2
ORDER BY 1,2
;
/* make sure the collectintervals value is set correct */
SELECT TheDate,
CAST((CAST((TheTime (FORMAT '99:99:99')) AS CHAR(8))) AS TIME(0)) AS TheTime,
SUM(FileCylAllocs),
SUM(FileCylMigrs),
SUM(FileMCylPacks),
SUM(FileCylDefrags),
(AVG(FileCylMigrs) / MAX(FileCylMigrs)) * 100 AS VprocCylMigrsParallelEff
FROM dbc.resusagesvpr
WHERE collectintervals = '2' AND
vprtype = 'AMP'
GROUP BY 1,2
ORDER BY 1,2
;
Labels: cylinder, migration, optimisation, performance, teradata
posted by Ranjith at
11:03 am
2 Comments:
Hi Ranjith, Is there a way to save all the DBQL history in some tables o na regular basis to check particualr events? If so would there be any documentation that i can follow to setup.
PDCR is answer for your question. It will move DBQL as well as other data from DBC to PDCR. Check and install complate PDCR package. You will find very useful views and reporting macro's.
If you don't have any details about PDCR then contact to your CSR.
Post a Comment
Subscribe to Post Comments [Atom]
<< Home