Join our webinar on Friday, April 28th: Make Routine Tasks Quick and Easy for HR and Employees  REGISTER NOW
partner2

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

Customer Story: Kelly Roo...

Watch Kelly Roofing weather even the toughest business challenges using the efficient and ...

Customer story: Providenc...

Providence St. Joseph Health is moving beyond the typical call center to provide more pers...

Dynamics 365 better toget...

Learn how Dynamics 365 Business Central can help small businesses eliminate redundancy, in...