ayjay
Azure Elastic Pool has a huge allocated space compared to used space
Not really C# related, but maybe someone can help me.
I have multiple databases in an Azure SQL Elastic Pool. The total used space is around 100GB, but the allocated space across the databases is about 300GB. I'm wondering what the best way to handle this excess allocated space is. Should I use DBCC SHRINKDATABASE, DBCC SHRINKFILE, or another method? Also, how frequently (if at all) should these commands be run in an elastic pool scenario?
2 replies
Designing a Scalable Booking .Net API – Best Practices & Input Needed
Hey everyone,
I’m working on designing a mock booking hotels/flights API, and I want to know your go-to best practices, design patterns, and scalable architecture.
This API will allow users to search, book and check status.
The system should support different search types
No external database – all data should be stored in-memory for now.
Bookings take time to process, so users need to wait 30-60s for a booking to be completed. They can check for status updates.
What architecture and design patterns would you use?
14 replies