SQLSERVERDUMP.EXE
SQLSERVERDUMP.EXE (Keeps popping up every time Revit is open)
Causes:
- SQL Server is unable to start due to the unsupported file system. SQL Server currently supports sector storage sizes of 512 bytes and 4 KB.
Note: An update to Windows 11 might trigger this issue for systems that have SSD/NVMe Drives with sector sizes bigger than 4KB. The issue was not present on previous versions of Windows as the sector size value was capped by the built-in drivers.
- Microsoft SQL Server 2014 is not correctly installed.
- A more recent version than Microsoft SQL Server 2014 is installed.
- Permissions of Advance Steel or RVT folder in ProgramData\Autodesk is restricted.
Here's what you need to do:
- Start Command Prompt as Administrator and run the following command: fsutil fsinfo sectorinfo C:
- Look for the values of PhysicalBytesPerSectorForAtomicity and PhysicalBytesPerSectorForPerformance (shown in bytes). If any of these values is bigger than 4096 (like in the attached picture), proceed with the next step.
- Run REGISTRY EDITOR and Navigate to
Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device. - On the Edit menu, point to New and select Multi-String value. Name it
ForcedPhysicalSectorSizeInBytes. - Modify the new value, type in
* 4095. Select OK and close the Registry editor. - Run CMD as administrator and copy paste REG ADD "HKLM\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" /v "ForcedPhysicalSectorSizeInBytes" /t REG_MULTI_SZ /d "* 4095" /f
- REG QUERY "HKLM\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" /v "ForcedPhysicalSectorSizeInBytes"
- Run PowerShell as Administrator and add the key New-ItemProperty -Path "HKLM:\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" -Name "ForcedPhysicalSectorSizeInBytes" -PropertyType MultiString -Force -Value "* 4095"
- Get-ItemProperty -Path "HKLM:\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" -Name "ForcedPhysicalSectorSizeInBytes"
- Restart Computer and all set.