Join our webinar on Friday, April 28th: Make Routine Tasks Quick and Easy for HR and Employees  REGISTER NOW
Questions? Call us: 713.300.0523
Questions? Call us: 713.300.0523

FIM service database usage report

The following script could be helpful in determining the current usage of the database for FIM 2010. It does gives provide a good indication whether the database needs to be shrinked. 


SQL Query to determine the amount on free space on FIM Service SQL instance

After aggressively deleting the expired system objects like Request, Workflow Instance and Approval, it did leave a significant amount of space as free space. Shrinking the database will help free up that unused space.

Here is a script for your easy reference:

Use FIMService Go Select a.FILEID, CONVERT(decimal(12,2),ROUND(a.size/128.000,2)) as [FILE_SIZE_IN_MB], CONVERT(decimal(12,2),ROUND(fileproperty(a.name,'SpaceUsed')/128.000,2)) as [SPACE_USED_IN_MB], CONVERT(decimal(12,2),ROUND((a.size-fileproperty(a.name,'SpaceUsed'))/128.000,2)) as [FREE_SPACE_IN_MB], a.name AS [DATABASE_NAME], a.FILENAME as [FILE_NAME] FROM dbo.sysfiles a

Topics: Applications & Infrastructure

Subscribe

You might like these too

FIM service database usag...

The following script could be helpful in determining the current usage of the database for...

Installation of AD FS 2.0...

Federation Proxy is required to service federated authentication requests when the user is...

Simplify federated extern...

The following steps highlight how to enable ADFS & Service-Now integration to support the ...