June 23, 2015 at 8:26 pm
Hi,
I am working one of the issue happening in production server
We are getting so many dump files mainly with access violations.
My server is Sql server 2008r2 standard edition with sp2.
The problem is happening recently.
The database changes happend are below
Removing the two columns from one table
Adding 2 indexes to two different tables
Disabling(dropped later) 1 index in one table.
Immediately second day My sql server service crashed suddenly. It automatically restarted.
Again 3rd day we added back the dropped columns to the table
4th day on wards we getting dump files so many with access violations and some times it is restarting.
One of the database is configured for transnational replication.
Is there any relation with the columns drop and reading those columns to the table and these access viloations
June 24, 2015 at 2:43 am
Shouldn't be. Access violations are related to illegal memory reads.
Make sure your patches are up to date and if the problem continues consider calling Microsoft Customer Support, though since 2008 R2 is out of support that may not be an option.
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
June 24, 2015 at 8:41 am
clean dbcc checkdb?
June 24, 2015 at 10:40 am
Some of them are clean but didn't run against 2 dbs
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply