c******j
发帖数: 87 | 1 请问有没有什么工具能够查到Teradata server所接受的Query呢？类似于SQL Server
Profiler的咚咚？
Thanks | w*r
发帖数: 2421 | 2 turn on DBQL Logging or use TASM to log deatail for the workload you are
targetig to log, then check the content of dbc.qrylogtbl table or dbc.
querylog view.
Be careful when you turn on logging for high-concurrent workload with detail
steps logging, it do have performance complication(not quite visible for
low activity OLAP systems).
【在 c******j 的大作中提到】
: 请问有没有什么工具能够查到Teradata server所接受的Query呢？类似于SQL Server
: Profiler的咚咚？
: Thanks
| c******j
发帖数: 87 | 3 Thanks, could you please kindly give some details? I am totally new to this
server. | w*r
发帖数: 2421 | 4 for DBQL Logging
Begin query logging [with ,*] [LIMIT [AND <
limit option>}*} ON
[username ,] | ACCOUNT= (account string,*)>;
check the SQL Reference Database Definition Statements manual.
For TASM , check the Teradata document broucher and search Teradata Dynamic
Workload
Management
Both methods write the results into a set of DBQL Tables plus a couple of
TASM summary tables. Details
can be found in the SQL Reference DDL reference.
detail
【在 w*r 的大作中提到】
: turn on DBQL Logging or use TASM to log deatail for the workload you are
: targetig to log, then check the content of dbc.qrylogtbl table or dbc.
: querylog view.
: Be careful when you turn on logging for high-concurrent workload with detail
: steps logging, it do have performance complication(not quite visible for
: low activity OLAP systems).
| c******j
发帖数: 87 | |
|
