Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
New instance of SQL Server 2017. I chose to install up to CU25 during the initial installation. Been using the database for a few months, but it seems to have a memory leak when using memory-optimized tables which causes it to crash overnight sometimes.
I have another instance with the same jobs and hardware on CU20 and it has never had this problem. Leads me to believe this is a CU25 issue.
I'd like to downgrade to CU20 to see if this fixes the issue. What is the best way of doing this?
The instructions for uninstalling CU25 can be found on the support page for that cumulative update:
How to uninstall this update on Windows
- In Control Panel, open the Programs and Features item, and then select View installed updates.
- Locate the entry that corresponds to this cumulative update package under SQL Server 2017.
- Press and hold (or right-click) the entry, and then select Uninstall.
For Linux, follow the instructions at Rollback SQL Server.
It is quite unusual to rollback a cumulative update. Be certain that is your best troubleshooting option before committing to it. You might want to do other troubleshooting or contact Microsoft Support about your issue on CU25 instead.
