Update both the OS and the SQL Server instances to the latest patch level, run diagnostics on the hardware and configure the max memory for the SQL Server instances to leave breathing space for the OS.
* Access Violation occurred reading address 0000000000000010
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION SqlDumpExceptionHandler: Process 129 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. ***Stack Dump being sent to C:\MSSQL\MSSQL11.MSSQLSERVER\MSSQL\LOG\SQLDump0039.txt In this folder C:\MSSQL\MSSQL11.MSSQLSERVER\MSSQL\Log we started to see a lot of SQLDump files (each of them = 400MB aprox, every 2 minutes). However, the SQL dumps were still occurring. It took more than an hour for that blocking process to go away. a SQLText "NULL" process executed on master was blocking SQL dependency processes and some Stored Procedures too. We started to have blocking issues (seen by sp_whoisactive) in our primary database server. You need to limit memory on both and you should also install SP3 on both.ĭo you have anymore details on the error you are getting besides "Access violation when reading address"? If you have any feedback I'd appreciate it.So, do you suggest us to limit memory, and redirect traffic back to the primary database instance (currently we are running on the secondary instance) and see if it doesn't happen again?
- I've considered creating a second copy of the MySQL database and dropping any unnecessary tables/columns before uploading.
- Would it be better for me to setup my own server to make sure I control the data?.
-
How secure would MySQL be with both high-level encryption and SSL certificates?.I'm planning on making sure the host is encrypted, but I really want to make sure I don't accidentally allow any personal information get accessed. I still need to learn the language a little bit, but I'm wondering if I could get some feedback.
I'd like to do it web-based with a couple javascript plugins and (I'm guessing) PHP programming. I'm looking into setting up some automated reports for my office. At least that is what the ONC has as their requirement for EHR softwares and they better be HIPAA compliant otherwise I've got a bone to pick with them. Jsalmon wrote:To my knowledge, as long as the SSL connection is FIPS compliant (uses TLS 1.2) then it's secure enough for HIPAA.