Identity Manager database utilization

Products

• CA Identity Manager
• CA Identity Suite

Issue/Introduction

Confirming DB usage.

Resolution

Check the size of the DB tables:

TP should be under 100,000 rows for best performance. 

select count(*) from lock12_5
select count(*) from object12_5
select count(*) from tasksession12_5
select count(*) from runtimestatusdetail12

-----

use "<DBNAME>"

EXEC sp_spaceused 'tasksession12_5'

 

use "<DBNAME>"

EXEC sp_spaceused 'event12_5'

 

use "<DBNAME>"

EXEC sp_spaceused 'object12_5'

 

Run above to make sure DB is not full and autoincrement enabled.