In our TD system the ObjectUseCountCollectRate values is set to 10(default value in 14.10), but the DBC.Objectusage table is not updated. the table is empty.
The lastaccesstimestamp and access counts has only NULL vaules in DBC.tables.
Please help me to resolve the issue. The lastaccesstimestamp would help me to a great extent.
And also please explain the disadvantage for enabling the ObjectUseCountCollectRate in DBS control utility.
Thanks in advance.
you need to enable it for specific databases using BEGIN QUERY LOGGING WITH USECOUNT
Thanks for the reply. Is it one time statement or do we have to execute everytime we run a query?.
This is enabled once on a database level, usually only the DBA has rights to do that.
Do we have to enable BEGIN QUERY LOGGING WITH USECOUNT on all databases or
BEGIN QUERY LOGGING WITH USECOUNT on ALL would work?
ON ALL will work, but do you really need it for each and every table in all databases and users?
E.g. staging tables are usually fully deleted and reloaded.
There is another good post with details about usecount in case you need it -