Forum Discussion

alisoroush7's avatar
alisoroush7
Icon for Helper I rankHelper I
3 years ago

issue with the size of ReportServer database

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?!

 

SQL

2 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

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

  • d_gosbell's avatar
    d_gosbell
    Icon for Super User rankSuper User
    3 years ago

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