llo, we have problems when we DROP a DATABASE on a server with many databases.
Our client has more than 600 databases on 1 server.
This problem does not occur on servers with a limited number of databases.

ElevateDB VCL 2.38 Build 2 - Delphi 12

We take the following steps:
- we select all users for a role:
 select GrantedTo from Configuration.UserRoles WHERE Name=' + EDBQuoteStrEql(roleName);
- we revoke the role from all found users found in previous query
 REVOKE rolename FROM username
- we drop the role
 DROP ROLE rolename
- we drop the database:
 DROP DATABASE sDBName

Can we specify parameters in the server's ini file, or in our server source code?

Accowin


I don't think that that is an ElevateDB error message, it looks like a Windows one. My best guess as to why its occurring would be memory fragmentation, but just what is causing that is anyone's guess. One example could be a lot of dead sessions still lying around, big enough chunks of memory to be used for some things but not for this operation, memory leaks could be another one.

Roy Lambert

Roy Lambert wrote:

Accowin


I don't think that that is an ElevateDB error message, it looks like a Windows one. My best guess as to why its occurring would be memory fragmentation, but just what is causing that is anyone's guess. One example could be a lot of dead sessions still lying around, big enough chunks of memory to be used for some things but not for this operation, memory leaks could be another one.

Roy Lambert


This error does not occur when there are a little number of databases or users.
It looks like the server is using a lot of memory when there are many users or databases.
Could it be the number of UserRoles?

select * from userroles => 14701 rows

Accowin

<<Could it be the number of UserRoles?>>

Absolutely no idea. Sorry

Roy Lambert