Home SQL Compliance Manager SQL SERVER – Fix – Error – Property MemoryAllocatedToMemoryOptimizedObjectsInKB is not available...

SQL SERVER – Fix – Error – Property MemoryAllocatedToMemoryOptimizedObjectsInKB is not available for Database. This property may not exist for this object, or may not be retrievable due to insufficient access rights.

20
0
SHARE


The other day when I was presenting my popular training SQL Server Performance Tuning Practical Workshop, during the demonstrations, I received following error. It was bit embarrassing for me as I was presenting in front of over 25 extremely smart DBAs and the error MemoryAllocatedToMemoryOptimizedObjectsInKB showed up on the screen.

The error is visible on the screen over when you right click in SQL Server Management Studio and click on properties.

Property MemoryAllocatedToMemoryOptimizedObjectsInKB is not available for Database ‘[YourDBName]’. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (SqlManagerUI)

Here is the image of the error as well.

SQL SERVER - Fix - Error - Property MemoryAllocatedToMemoryOptimizedObjectsInKB is not available for Database. This property may not exist for this object, or may not be retrievable due to insufficient access rights. MemoryAllocatedToMemoryOptimizedObjectsInKB

Fortunately, I knew the solution of this problem.

Solution/Workaround:

The issue is a permissions issue. You can quickly resolve this issue by running following command in your query window.

USE YourDBName
GO
sp_changedbowner 'sa'
GO

As soon as you run above command the error will disappear and you will be able to check properties again for your database. I suggest that afterward, you change your database access to your preferred user.

If you are based out of European country, GDPR is very important for your database. You can read this article where I have discussed GDPR and SQL Server. SQL SERVER – How to Make SQL Server GDPR Compliance?

Reference: Pinal Dave (https://blog.sqlauthority.com

Solarwinds





Source link

LEAVE A REPLY

Please enter your comment!
Please enter your name here