question

GGradev avatar image
0 Votes"
GGradev asked ErlandSommarskog commented

Permanent loss of disk space after using SQL Server Management Studio

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-general
· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

HI @GGradev,
I facing the same issue, if you fixed the issue please share the solutions thank you.

0 Votes 0 ·

Please post the output from "SELECT @@version". And next time you have a problem, start a new thread instead of piggybacking on an old thread.

0 Votes 0 ·

Hi @GGradev,
Hi, I am facing the same issue, due to SQL server(SSMS) I am loosing 4-5GB of space in C drive every day.
I have already lost around 30GB of space.
How to stop this and recover the lost space.
Please Help.

0 Votes 0 ·

It's not a very good idea to piggyback on old thread. Rather start a new thread and describe your problem from start to end, and don't forget to include "SELECT @@version" and which version of SSMS you have.

(Although, I willing to bet some money that if you download and install Cumulative Update 12 for SQL 2019, that will resolve the issue.)

0 Votes 0 ·
Cathyji-msft avatar image
1 Vote"
Cathyji-msft answered GGradev commented

Hi @GGradev,

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.


· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Dear Cathyji-msft,

Thank you very much for recommending WinDirStat. After installing it I found out that SQL is creating dump files with a size of aprox. 450 MB every 30 to 60 min.
How can I avoid this happening or at least reduce the size of these files? Are they important for the proper functioning of SQL Server and can they be deleted?



54080-dumpfiles.jpg


0 Votes 0 ·
dumpfiles.jpg (245.7 KiB)

First, make sure you have the current patches installed.
https://support.microsoft.com/en-us/help/4518398/kb4518398-sql-server-2019-build-versions

if that does not resolve the issue, look at the errorlog to determine why SQL Server is crashing.

1 Vote 1 ·
GGradev avatar image GGradev TomPhillips-1744 ·

Dear Tom Phillips,
Thank you for your assistance.
Below you will find a screenshot from the errorlog file of the process of creating of a dump file.
Hope it will help you to see the problem.
54109-dumpfiles02.jpg


0 Votes 0 ·
dumpfiles02.jpg (541.3 KiB)
cooldadtx avatar image
1 Vote"
cooldadtx answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TomPhillips-1744 avatar image
1 Vote"
TomPhillips-1744 answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
1 Vote"
ErlandSommarskog answered GGradev edited

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Yes, my version is:
Microsoft SQL Server 2019 (RTM-GDR) (KB4517790) - 15.0.2070.41 (X64) Oct 28 2019 19:56:59

Thank you for your suggestion to install the latest Cumulative Update, CU8, for SQL Server 2019. I did it and got the following message: "The patch installer has failed to update the following instance: MSSQLSERVER. "
Will have to investigate the errrorlog file.

0 Votes 0 ·
AbdulhakimMElrhumi-5836 avatar image
1 Vote"
AbdulhakimMElrhumi-5836 answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.