Can't open pages "Database Locks", "Database Missing Indexes" and "Database Wait Statistics"

(1) Share

Report

Posted on by Community member

We are running BC22 on prem, and we have issues opening thae pages Database Locks, Database Missing Indexes and Database Wait Statistics.

I am guessing it is because the BC system/service user does not have the appropriate rights on the SQL server. Does anyone know where I can find the documentation on which SQL rights are needed in order to open these pages - or any other hints?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Gerardo Rentería Ga... 25,230 Most Valuable Professional on at

Like (0)

Report

Hi

You can check the event viewer and see what more information it gives you when you open these pages.

best regards

Gerardo

Was this reply helpful? Yes No
Community member 13 on at

Like (1)

Report

We were missing the VIEW SERVER STATE permission.

1 people found this reply helpful.

Was this reply helpful? Yes No