While installing Notification Server or solutions, I receive SQL storeng errors or SQL tempdb 'bad page id' errors:The errors are not always the same, but are similar to the following:
Process: AeXConfig.exe (3340)
Thread ID: 2540
Description: Unable to set the security descriptor for the specified entity (Guid:<some guid here>). Inner:
Expression: m_SizeRec > 0 && m_SizeRec <= MAXDATAROW
Process ID: 1984.
Process: AeXConfig.exe (3392)
Thread ID: 3160
Description: Unable to set the security descriptor for the specified entity (Guid:<some guid here>). Inner:I/O error (bad page ID) detected during read at offset 0x00000001cea000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL\data\tempdb.mdf'
Unable to set the security descriptor for the specified entity (Guid:59e3f939-0ace-4fd5-b680-02e3bd30c68b). Inner:A possible database consistency problem has been detected on database 'Altiris'. DBCC CHECKDB and DBCC CHECKCATALOG should be run on database 'Altiris'.
Testing appears to show that the issue only occurs on virtual machines using the LSI Logic SCSI controller included in VMware products, with the Altiris database hosted on SQL Server 2000 or SQL Server 2005 within the Virtual machine. I/O load testing indicates this problem would also occur on the older Bus Logic SCSI virtual drives.The likelihood of the problem occurring appears to be directly related to lower disk I/O capacity of the physical storage device. For example, laptop 5,200 RPM drives are much slower than server class RAIDed drives and thus have a much higher failure rate. It's also worth noting that the actual data is never corrupted, but intensive SQL operations appear to expose a flaw in the virtual drive's write caching. The problem appears to be the same as discussed in VMware's forum:
After extracting the utility, use the default configuration file, change the number of intervals to 25, and start the simulation. Virtual machines observed with the problem reported an error similar to the following: "Error 0x80070467", "While accessing the hard disk, a disk operation failed even after retries", "Buffer validation failed on c:\sqliosim.mdx Page: 47806, offset 0x8"