Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

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



Group: General Forum Members
Last Login: Today @ 6:14 AM
Points: 44,003, Visits: 41,398
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, MVP, M.Sc (Comp Sci)
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: 2 days ago @ 8:51 AM
Points: 927, Visits: 2,013

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



Group: General Forum Members
Last Login: Today @ 6:00 AM
Points: 7,978, Visits: 16,012
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