请问有没有什么工具能够查到Teradata server所接受的Query呢?类似于SQL Server Profiler的咚咚? Thanks
w*r
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).
Thanks, could you please kindly give some details? I am totally new to this server.
w*r
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).