SharePoint DB contents and stricture analysts

ICT Engineer
ICT Engineer used Ask the Experts™
on
IS there a tool or command where I can see where the files on SharePoint are stored?
I'm looking too understand the structure and see where the bulk of the files are stored.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
SharePoint AED
Distinguished Expert 2018
Commented:
There are system files that keep SharePoint running, and then you have content and user data. System files are almost totally on the local files system of the servers SharePoint is installed on.  Content is almost totally in the content databases.

Configurations and settings are almost totally in databases.

As far as a tool or command? SharePoint designer is a great tool for seeing files stored in the data base, both user files and the system files that are part of the database.

PowerShell and SharePoint cmdlets are a good way to see system information. As far as files on the local files system, the usual tools will work with those.

Hope that helps...
ICT EngineerHead of ICT

Author

Commented:
The problem is that everything seems to be stored in on large DB and I'm looking to fine which site inside the main site is using the bulk of the storage or to fine which sites are using which amount of resources.
Walter CurtisSharePoint AED
Distinguished Expert 2018

Commented:
In central administration there are built-in analysis tools that should help you. Also, download a 14 day trial of Sharegate. It will also provide those reports and you should be able to get the information you need within the trial period.

Good luck...
Walter CurtisSharePoint AED
Distinguished Expert 2018

Commented:
Information provided is accurate and correct.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial