STAR data collection failing while updating the status
One answer
1. First check if the Database is scheduled for the maintenance or backup activities
2. Is the DB or the transaction log running out of space?
3. The DB server is scheduled for any maintenance or backup procedure
4. Could firewall be causing the DB connections to drop?
5. Check the DB logs. In one case I saw that the SQL Server log had the error like
Attempt to fetch logical page (5:83640) in database 7 failed. It belongs to allocation unit 72057594178306048 not to 72057594182434816.
This means database corruption. The DBA should be able to fix these kind of problem.
If nothing works, open a support ticket :)
2. Is the DB or the transaction log running out of space?
3. The DB server is scheduled for any maintenance or backup procedure
4. Could firewall be causing the DB connections to drop?
5. Check the DB logs. In one case I saw that the SQL Server log had the error like
Attempt to fetch logical page (5:83640) in database 7 failed. It belongs to allocation unit 72057594178306048 not to 72057594182434816.
This means database corruption. The DBA should be able to fix these kind of problem.
If nothing works, open a support ticket :)