GIS/CMMS/EAM storage
Should CMMS data be stored in the GIS database
No.
I was tempted to leave the answer there. But really, the answer is just a simple no. GIS databases (including MS SQL with GIS) are either optimized for GIS data or 'standard' rows and columns data.
We have doc that discusses several types of data and where we think they should be stored. How we store different types of data