Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Identifying what caused Corruption Expand / Collapse
Author
Message
Posted Wednesday, May 7, 2014 12:17 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 11:19 AM
Points: 42,806, Visits: 35,927
TheSQLGuru (5/7/2014)
Also note that you stated that 9,999 times out of 10,000 that the IO subsystem was responsible for corruptions. Same type of probabilistic statement - just with a higher level of certainty.


Well that's from Paul, who has a hell of a lot more experience and knowledge in this area, and was based on his time with the dev team and corruptions he's worked on since. I'll take his probabilistic statement as fact. I certainly have no grounds to disagree with his statement.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1568640
Posted Monday, May 12, 2014 7:12 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 9:43 AM
Points: 902, Visits: 1,857
Update:

There was windows patching of the VM occurring at the time of the issue. The Virtual Disk Service was flickering between stopped and started. I "guess" this could cause an issue if it was flicking between started and stopped when sql was trying to write to the tran log on a LUN controlled by the Virtual Disk Service.

Scans of the disks within the VM VHD's and physical storage have shown no issues. No corruption since the issue also.

Im inclined to think patching caused this issue, but am still looking for hard evidence.
Post #1569835
Posted Monday, May 12, 2014 9:28 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:29 PM
Points: 6,300, Visits: 13,579
Ah so its a virtual machine, this wasnt made known before. Are these virtual hard disks or raw device mappings?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1569917
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse