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

SQL
No Comments

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 MemoryAllocatedToMemory OptimizedObjectsInKB 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)

Solarwinds

Here is the image of the error as well.

SQL SERVER - Fix - Error - Property MemoryAllocatedToMemory OptimizedObjectsInKB 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
, , , , ,
Previous Post
SQL SERVER – Create Catalog Error 911: Database ‘SSISDB’ Does Not Exist. Make Sure That he name is entered correctly
Next Post
SQL SERVER – Installation Error: The Cluster Resource is Not Available. (Exception from HRESULT: 0x8007138E)

Related Posts

Leave a Reply

Menu