Return
-
Title
1IM performing regular checks on the SQL server partitioned tables -
Description
One Identity Manager (D1IM) is performing regular SQL queries to check on the SQL server partitioned tables. These SQL queries are unusual since 1IM did not deployed any partitioned tables. What would be the purpose of these SQL queries?
-
Resolution
The SQL queries are coming from the SQL "QBM_FGITableCountAll" function. The purpose of this function is to determine the row count for a given table. It is much more efficient to use this function which determines the row count by looking in the sys.tables and sys.partitions. This function is used in a lot of codes, i.e. DBQueueProcessor, Database Maintenance task.