Thanks for sharing the details, @Nasir Siddiqui
We looked at the databases and their history.
- qa-xxx-database
- DB was on Basic tier and renamed as qa-xxx-database-backup on 2025-04-03
- New database qa-tcf-database was created with vcore model on same logical server.
- SLO changed of new database to Basic on 2025-04-07 (around 06:55 UTC).
- Currently both databases exist on same logical server.
- dev-xxx-database:
- Created on 2025-02-13 as Basic
- Recreated on 2025-02-25 as SQLDB_GP_GEN5_2
- SLO changed on 2025-03-03 to Basic
- Recreated on 2025-03-25 as SQLDB_GP_GEN5_2
- Recreated on 2025-03-28 as SQLDB_GP_GEN5_2
- SLO changed on 2025-04-07 to Basic
(note I have masked the database name as they might be sensitive names)
So, it doesn't look like system is changing SLO automatically. The database was actually created with the vCore SLO. You have to check with your team about which process is dropping and creating database.