One of my SQL 2008 SP1 servers is experiencing periodic failures of a database maintenance plan that includes integrity checks.
Failed:(0) Alter failed for Server 'ssomsitrack1v'.
I've seen other postings from people who have had this issue with SQL 2005 and fixed it by either applying a service pack, enabling the "automatically set processor affinity mask" and/or I/O affinity mask settings, or by executing a sp_configure 'allow updates',0.
This server already has both affinity mask checkboxes set, and allow updates is already set to 0. The maintenance plan fails with this message about 1 in 4 times. The server is on a VMWare VM w/2GB RAM and two vCPU's. There's only one user
database and it's tiny (~200MB).
View Complete Post