Going out on a limb here but wondering if anyone has some insight into a problem we are having.
Our environment is Server 2012, SCCM 2012 R2, with SQL 2012 SP1 CU7, on VMWare ESXi 5.1, with Dell Equalogic storage. We are not in production yet. A couple months back, when we attempted the R2 upgrade, it failed because of SQL corruption. The message at the time was: "CHECKDB found 0 allocation errors and 4 consistency errors in table 'LU_SoftwareCode' (object ID 1886629764)." It said that the only way to repair it was with data loss. We did so at the time and it was fine until the end of December when I happened to run another DBCC CHECKDB on the Db, and it came up with yet a very similar error message, just in a different table. At this point, I contacted PSS, who tried a few things but the end result was another repair with data loss. They said that in the majority of the instances where they see this, it is due to disk drivers or the storage system. Since then, the corruption happened twice more. Again, the same sort of message, consistency errors. Different tables, but it would appear to be the tables from Asset Intelligence (LU_SoftwareCode and LUSoftwareList). It's possible there was one other table that was not AI related, but I know for sure that 3 out of the 4 times it was an AI table. Now, there are other Db's on this server that have not had any corruption. And we have another server for SCSM setup the same (Server 2012, SQL 2012, VMWare, Dell Equalogic), and it has had no Db corruption either. We've looked at the storage logs when this occurs and don't see anything out of sorts. Also, the SCCM site seems to function 100% normal. I've looked at the Site and Component Status sections and they are all 100% in the green. Obviously this is a strange issue, but I am wondering if anyone has any thoughts or wisdom on what else to check/change, etc. Should I remove the AI point and see how things go for the next few weeks? I don't think I will get any further with PSS. Thanks! Mark Kent (MCP) Sr. Desktop Systems Engineer Computing & Technology Services - SUNY Buffalo State
