Dear Friends,
i dindt find any rows stored in the table DBC.DBQLStepTbl. might be it is required some enable at database level.
Could you please suggest.
Thanks in advance!
Like all DBQL tables it must be enabled using BEGIN QUERY LOGGING: WITH STEPINFO
Thanks dnoeth. kindly let me know, is it required for every dbc tables we should enable one by one.
i can there number of tables are empty. few are below
SyntaxEditor Code Snippet
SEL TOP 10 * FROM DBC.QUERYSTATSV; SEL TOP 10 * FROM DBC.QUERYSTATUSECOUNTV; SEL TOP 10 * FROM DBC.UPDATEUSECOUNTV ; SEL TOP 10 * FROM DBC.STATUSECOUNTV SEL TOP 10 * FROM DBC.VIEWSTATSV; SEL TOP 10 * FROM DBC.QRYLOGSTEPSV; SEL TOP 10 * FROM DBC.QRYLOGSQLV;
Please read the chapter Tracking Query Behavior with Database Query Logging: Operational DBAs in the Database Administration manual for your TD release.