Develop & execute an actionable plan with defined work streams that can guide your organization’s path to cloud adoption. Evaluate your on-premise infrastructure & applications for a cloud readiness, disaster recovery and governance with either single or multi-cloud objectives.
Founded in 2009, Credexo is a Cloud Managed Services Provider that provides strategic consulting & managed services to our customers with a Cloud First, Mobile First mindset.
What do we do?
We have delivered purposeful technology to many of your peers that has totally transformed their businesses and accelerated their growth.
How will you benefit?
Our solutions will help you create new revenue streams so you can disrupt your competition with tools that enable you to achieve faster time to market your new business transformational ideas
You will find our solutions will empower your employees and enables them to adapt to the changing mindset as they adopt your favorite Cloud Platform with automation and protection of digital assets are the key drivers for sustained growth.
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.
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