Permanent loss of disk space after using SQL Server Management Studio

Gradev 21 Reputation points
2021-01-05T21:01:11.163+00:00

I have a weird problem. Since I installed SQL Server 2019 and SQL Server Management Studio I found out that after every usage I loose around 5 GB of free disk space.
I use SQL only for studying and my databases are really small and simple.
Please advise how to resolve this issue.
Thank you in advance.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,758 questions
Accepted answer
  1. CathyJi-MSFT 21,096 Reputation points Microsoft Vendor
    2021-01-06T05:26:16.81+00:00

    Hi @Gradev ,

    Suggest you using WinDirStat tool. WinDirStat is a disk usage statistics viewer and cleanup tool for various versions of Microsoft Windows. Find files that top used the disk space, and fix the issue.

    Best regards,
    Cathy

    If the response is helpful, please click "Accept Answer" and upvote it, thank you.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Michael Taylor 48,576 Reputation points
    2021-01-05T21:24:14.03+00:00

    Where is the disk space being consumed from? Most likely it is temp files in your local user directory although 5GB is entirely too much. It could also be in the AppData folders for your user account where the app is storing data. Once you've identified what files are being generated it will probably become clearer what the problem is.

    1 person found this answer helpful.
    0 comments
  2. Tom Phillips 17,716 Reputation points
    2021-01-05T22:18:37.95+00:00

    Most likely what is happening is you are getting a Windows or SQL memory dump. You need to determine what is actually using the space and then fix the issue.

    1 person found this answer helpful.
    0 comments
  3. Erland Sommarskog 101.4K Reputation points MVP
    2021-01-06T22:03:31.96+00:00

    Apply the latest Cumulative Update, CU8, for SQL Server 2019. You did not post the output from "SELECT @@version", but I am quite sure that you are the RTM version. This is an issue I have run into myself, and it has been fixed.

    1 person found this answer helpful.
  4. Abdulhakim M. Elrhumi 351 Reputation points
    2021-01-07T00:21:00.48+00:00

    Hi
    To display data and log space information for a database by querying sys.database_files
    Connect to the Database Engine.

    From the Standard bar, click New Query.

    Copy and paste the following example into the query window and click Execute. This example queries the sys.database_files catalog view to return specific information about the data and log files in the AdventureWorks2012 database.

    USE AdventureWorks2012;
    GO
    SELECT file_id, name, type_desc, physical_name, size, max_size
    FROM sys.database_files ;
    GO
    display-data-and-log-space-information-for-a-database

    Best Regards.

    Please click the Mark as answer button and vote as helpful if this reply solves your problem.

    1 person found this answer helpful.
    0 comments