This is unusual. Yes, SQL Server may well be a good solution. How many users are in this project?
If more than one or two, that would be a good way to go.
AutoCAD Plant 3D Projects: SQLite versus SQL Server
How to configure Microsoft SQL Server for AutoCAD Plant 3D project
It sounds like you already seen this article: AutoCAD Plant 3D and P&ID: Another user is updating the project. warning message
The project likely needs some maintenance, especially if there's been crashing.
- With all other users out of the project, do a full project audit.
- Open each 3D model drawing and do a PLANTAUDIT and save each drawing.
- Be sure to do the same for all external references used by your model drawings.
- Then another project audit.
- Compress the database.
- Purge the local cache again.
Additionally,
- I’d power down the computers each night and restart fresh each day.
- Do a local data cache purge daily, first thing.
- Audit the project routinely, daily.
- Be sure to have a regular backup routine in place.
- Make sure you have plenty of harddrive disk space on each machine (avoid being in the red).
- Don't have other applications on and running in the background, including Autodesk programs. Close out if not using to save system resources.
- If you experience crashing and have opportunity to send in error report, please do so, including your email address in the report.
If my reply post was helpful, please give a "Kudos" or mark the "Accept as Solution" button below (or both).
Martin Stewart
AEC Support Specialist