I have a really good team of MSSQL admins, and they regularly run the DBCC feature to be proactive in finding database problems and correcting them before they become bigger issues impacting the applications. Over the past year or so, there has been three times they found a corrupt table (MapStudioFiles) in the NPM database. We tell them to go ahead and "fix" the corruption using DBCC and it usually screws up some of our maps. It's happened again and they are wondering if we can get some feedback from the vendor (Solarwinds) on the regular corruption. Yes, our MSSQL server is clustered for HA, and Solarwinds is the only application using the instance. The database files are split across multiple SAN LUNS for performance, and the LUNS for the Solarwinds DB have already been moved onto SSD for performance.
For reference, here are the current versions of our Solarwinds build:
- NPM 10.7
- NCM 7.3
- IPAM 4.1
- SAM 6.1
- VNQM 4.1
Has anyone else had any common experiences like this?
