SSPService.exe is bringing numerous windows 10 pro machines to a crawl in my department where the memory usage is 99-100% as seen under Processes in the task manager. This appears to be 100% of the time.
Hello Matt,
For those affected systems may we know what's the current version of the endpoint installed on it. I would like to ask your help if you can perform the basic troubleshooting on one affected device. Once you identify which component triggers SSP to have such a high Utilization, re-create the issue and Collect SDU logs and Procmon so that we can take a peek at the logs and found out what's going on.
Got an active case going however have not received anything from Sophos support they seem to not be aware of a general issue. Will let you know if we are able to pickup anything, they have us currently doing basic troubleshooting steps which is going slow.
The other problem we encountered is that one some of these endpoint once they are rebooted, multiple installed application are no longer working, google chrome, adobe, office all need to be reinstalled and in some cases file explorer also is not working, for these workstations we reloaded in order to save time as we make use of autopilot/intune.
As for our case, we are following what I assume is a standard troubleshooting guide of disabling services one by one and restarting the endpoint, this then takes a lot of time for the issue to reappear as the reboot sorts out the high memory usage and we have to wait for it to return to the problematic state before continue on to the next step.
Following that, just run Process Monitor with a filter for process sspservice.exe, it might be apparent straight away where all the time is spent. A couple of minutes when you have the issue should be quite revealing I would think. Might hint at possible exclusions for example.
Support should be able to work out what's going on with the C:\genp.etl ETL trace given they have the symbols. If you load it in Windows Performance Analyzer it should be possible to work out roughly what's going on without the Sophos symbols loaded but with the Microsoft ones.
The only thing we keep in the C drive are the program files for the various SQL Server applications (so our only SQL Server content is in Program Files\Microsoft SQL Server\...etc). All of our data files and instances are installed in other paths. Is there any impact to SQL Server if the C drive runs out of space? We're at 0 free space right now on C and SQL Server is up and running fine, however we occassionally see issues with other Windows applications like RDP. Would SQL Server hit any issues? My biggest concern right now is if the instance goes down and needed to restart. Thanks.
Too true you'll have problems. Sadly I can understand this situation - check for what's using the space - the rubbish bin sometimes hold files even after the bin has been emtied - usual suspects are also IIS logs and tmp files, not foretting overblown page file and vsp files left by backup routines, make sure you show hifdden and o/s files when you examine the drive. Youi need to fix this now before your server dies.
Thanks for the replies. I think the root cause of the issue is that our C drive was 9 GB to begin with when we started with SQL 2000 and we did not anticipate the signifcant space requirements for the 2005 upgrade.
aha - been there too. I'd sometimes like to shoot the sytem folks who set silly o/s partitions - unless you fix your environment variables you'll find a profiler trace will quickly run your C: drive out of disk space too.
Sounds like your hands are tied a little here. However, Windows Operating Systems absolutely hate running out of hard-drive space, especially on the system drive. You will have continuous, unexpected problems unless you free up a lot of space.
Note that you won't be able to defrag the system drive until you have at least 1GB of free space (preferably at least 20% free, so really you want 2GB free). When a drive gets 100% full, bits of files are stored all over the place (to cram them in) so general performance plummets.
I suggest you carefully clean out/move all the files you can. There is loads of advice on the web to help. Have you, for example, moved the Swap Files to another partition? Deleted all the $NTUninstall folders (note, you won't be able to uninstall a Microsoft patch once you have done this)? Searched for DMP files? As mentioned above, look for TXT and LOG files, and TMP files. How about CHM files?
I just want to check that when you say all your data files are stored on other disks, that you are including system databases, such as TempDb. These are stored in the SQL Server Program Files folders by default (this also can apply to .BAK files as well). If you haven't done so already, these files can be moved off of C: to clear up some space.
Also, if your ReCycler folder is large (you have to show Hidden and Protected Files to see it) that indicates that some user(s) on that box has a large Recylce Bin that has not been emptied; you can try to delete the contents of this folder (note: user will not be able to recover any of the current contents of their Recylce Bin once you do this):
As a previous poster briefly mentioned, check the Windows Environment Variables. By default it's set to the docs and settings folder. If anyone logs on to run a query from management studio on the system or temp space is needed during an install, it will use the TEMP and TMP paths to store those files.
Right click my computer > Properties > Advanced > Environment Variables, and change the paths of those two variables, TEMP and TMP to D:\TEMP and D:\TMP provided your D:\ drive is one of your large drives on the system.
You might also want to check out one of the more useful but less well-known Microsoft utilities called LinkD, which is part of the Windows Server resource kit downloads. Basically, it's a utility for doing on a Windows file system the same as linking directories within UNIX, so you could find a few large, fairly static folders on your C:\ drive, move them to another drive where there's an excess of space and then link the new directory back to its original location so the OS sees no difference except for more space. Obvious candidates might be log directories (c:\windows\system32\logfiles for instance) and directories containing binaries of applications you can turn off whilst you're doing this work.
This is obviously not a preferred solution, since in the long term it's difficult to make sure the server admins don't forget this amendment was done. However, I'd say you're past the point of preferred solutions and this one'll get you out of the mire fairly easily.
One specific we found on more than one of our servers was Trend Antivirus using incredible amounts of disc space for masses of pattern updates, and I've little doubt several other AV products'll have the same issue. If you find this is the case, these might easily be candidates for "linkd'ing" too....
Even if your server cannot connect to the internet, the internet cache may get large. I once had a problem with an internal-only server running Crystal Reports that had accumulated many GB in the internet cache as it built reports.
I know you have said that the data files are on other partitions, however if any of your databases use Full Text Searching then the catalogues are stored in \Program Files\Microsoft SQL Server\MSSQL\FTDATA by default.
cleanmgr.exe ist die ausfhrbare Datei. Du kannst einfach in der Suchleiste "Datentrgerbereinigung" eingeben, oder halt Win+r und "cleanmgr" eingeben, ist egal. Genauere einstellungen was du lschst kannst du dann dort angeben.
Moin, ich verstehe nicht warum auf der Festplatte wo ich Windows 10 drauf installiert habe von 120GB nur 62GB freien Speicherplatz habe obwohl ich alle Ordner auf der Festplatte mit der Funktion Eigenschaften auf den belegten Speicherplatz berprft habe. Der Windows 10 Ordner zieht etwas ber 20 GB und alle Ordner zusammen auf der Platte 36,9 GB. Wie kann das also sein das mir nur 62GB freier Speicherplatz zu Verfgung stehen?
Und wie kann ich viel Speicher frei machen? temp Ordner ist leer und, wenn ich Windows Datentrgerbereinigung nutze wird mir angezeigt, dass ich 2 GB frei mache wenn ich jetzt das Windows Update bereinige. Bei Windows cleaner und CCleaner wird der Speicherplatz (manchmal) mit jeder Reinigung weniger.
Hallo auf meinem pc erstellt sich jedes mal eine etwa 70gb groe windows image backup datei bzw ein ordner. Kann man das irgendwie abstellen das windows 10 das nicht immer erstellt das nervt mich. Habe selber nicht viel speicherplatz und dann sowas.... :(
Wollte Windows eigentlich schon eher auf einer schnellen Festplatte haben, aber auch nicht auf einer mit zu viel Speicher, da ich diese nicht mit anderen Sachen zumllen wollen wrde und nicht unntig viel Speicherplatz ungenutzt wre. Wrde es z.B. reichen auf einer Schnellen eine Partition zu erstellen?
seit einigen Stunden habe ich das Problem, dass mein Speicherplatz (1TB + 2 externe festplatten je 1TB) unaufhrlich schrumpft! Ich lade nichts herunter, Avast findet keine Viren o.. ... erst eben habe ich meinen Laptop von unntigen Dateien bereinigt (Spiele & Programme deinstalliert, Videos gelscht etc. )und 200 GB dazugewonnen. Eine Stunde spter liegt mein Speicherplatz wieder bei 0 k.
ich hab gestern bemerkt das mein Speicherplatz auf meinem Laptop (Windows) sehr voll ist und wollte einige Spiele lschen(hab sie im Explorer gelscht). Ich hab sie dann gelscht aber als ich nachgeschaut habe waren trotzdem noch der ganze Speicherplatz voll (auch nach Neustart). Woran knnte es liegen?
P.s Ich hab die Spiele auf Steam runtergeladen
hab nichts runtergeladen nur online dinge nachgeschaut und mal ne pdf runterladen die zusammen weniger als 10 mb ausmachen trotzdem habe ich 4 gb weniger als gestern von 400 auf 396 GB. Wie weit geht das noch hab ich irgendwann gar kein speicherplatz mehr obwohl ich nichts groes runterlade?
Ich habe mittlerweile schon lnger Speicher Probleme an meinem Pc und ich kann nicht noch weitere Dateien lschen. Ich benutze Windows und ich wollte fragen ob ich einfach eine Weitere Festplatte hinzufgen kann oder einfach den Speicherplatz auf Windows(C:) erweitern und wenn ja wie?
d3342ee215