issue with the size of ReportServer database

[alisoroush7]

hi guys.

i have a power bi report server. when i go to the sql server directory and data folder i see that te ReportServer data is 44GB however when i run a query in SSMS to see the table size it shows me at most 50 MG! i am wondering that what is the problem?!

[d_gosbell]

I don't think you are reading the table correctly. Your first row shows 26,124 under UsedSpaceMB which is 26GB

[lbendlin]

Do you have an actual issue or are you only curious?  Eventually SQL Server will re-use that whitespace.