Allocated vs. Used Memory in SQL Server Elastic Pool

S

SinaraM

Hello!I’m seeking help regarding the reduction of allocated space in databases within an SQL Server elastic pool. The allocated space in the elastic pool I'm using is significantly larger than the actual used space (due to recent deletions of deprecated data, which reduced the size of the databases). As a result, my pool is much larger than what should theoretically be necessary.Is there a way to adjust the allocated space so it recalculates according to the new, reduced sizes of my databases? Is there an alternative approach to SHRINK that could be used in this case, or would SHRINK be the be

Continue reading...
 
Back
Top Bottom