SSMS and Visual Studio Pro disk space issue

Russel Loski 421 Reputation points
2021-11-05T18:56:17.053+00:00

I don't know where to put this question. At first I thought it was an SSMS issue, but I get the same message with Visual Studio Pro.

Let's start with SSMS. I am running SSMS 18 on an Azure Virtual Machine. Side note in case it is important, I have access to two different Azure Virtual Machines, my documents folder is the same on both machines. I am in a corporate network and I think that I am sharing the VM, but I don't know for sure.

I launch SSMS and connect to a server just fine. When I click on "New Query" I get an error "There is not enough space on the disk." I get a similar message by trying to create a Project: "The location specified cannot be created. Check that the location is not a reserved system name, and that the dis is writeable and that there is enough room on the disk."

C drive show 32 GB free.
A shared drive which seems to be associated with my profile shows 18 GB free.

Visual Studio 2019 Pro. I tried to create a SQL Database project. I got the "There is not enough space on the disk" Error. Interestingly, I found that the solution file was created and the project file was created, but the project didn't show in the solution explorer.

We are stumped. Has anyone ever encountered this before?

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,654 questions
Accepted answer
  1. Russel Loski 421 Reputation points
    2021-11-09T17:08:36.98+00:00

    I fixed the problem and found more problems related to this. I haven't confirmed yet, but I'm pretty sure that the administrators have placed a quota on how much disk space my profile can take. I had filled it up.

    I went through my profile and found that in the AppData\Local\Microsoft\Power BI Desktop\ folder there are several cache folders. I tried to clear the cache following instructions here https://community.powerbi.com/t5/Desktop/How-to-clear-cache-in-Power-BI-Desktop/m-p/853321. However, Power BI Desktop wouldn't start, because the drive was full. So I first found the cache folder had a lot of data and cleared all but the most recent files. Then I opened Power BI Desktop and went to settings and clicked clear and set the size of the cache to a much smaller number.

    At this point I have one of the desktops working. I believe that once I exit the one desktop that is working and log in to the other desktop, the change will be applied.

    Thank you for all your help.

    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 21,081 Reputation points Microsoft Vendor
    2021-11-08T06:53:29.79+00:00

    Hi @Russel Loski ，

    Did you find which folder that SQL server written, when you check the process monitor result?

    By the way, did your %temp% folder point to a disk that have enough space? When we’re running a query in SSMS, and SSMS caches resultsets to your %TEMP% directory.

    1 person found this answer helpful.
  2. Russel Loski 421 Reputation points
    2021-11-08T15:39:34.687+00:00

    We are not finished with this issue just yet, though we are making "progress". I am not sure, but it appears that a new profile was created for me. Now, I can click the New Query button on one desktop but not the other.

    Our help desk is going to examine the %TEMP% space.

    Could there be a quota on the drive that %TEMP% is put on that is not reflected in the Free space? When I run "Dir %TEMP%" in the command prompt window, I show 35 GB free on the computer where I am still getting the error.

    0 comments