question

RusselLoski-0634 avatar image
0 Votes"
RusselLoski-0634 asked RusselLoski-0634 commented

SSMS and Visual Studio Pro disk space issue

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-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.

Process Monitor to see where SSMS is actually trying to write?

1 Vote 1 ·

I will check on Monday when I am back at work.

0 Votes 0 ·

I am asking permission to install Process Monitor on the desktop.

0 Votes 0 ·
Show more comments
RusselLoski-0634 avatar image
0 Votes"
RusselLoski-0634 answered

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.

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.

Cathyji-msft avatar image
1 Vote"
Cathyji-msft answered RusselLoski-0634 commented

Hi @RusselLoski-0634

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
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.

When I ran dir %TEMP% I show multiple GB free. Also, in the File Explorer window, I put %TEMP% in the address. Then I right-clicked and clicked New and created a new Text file in that folder. I copied a 25 MB file into the %TEMP% folder without any problems.

0 Votes 0 ·
RusselLoski-0634 avatar image
0 Votes"
RusselLoski-0634 answered

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.

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.