What is Ssms.exe

OB1Canobie
OB1Canobie used Ask the Experts™
on
I have a process that beginning to lug down my processor by taking more 50% of the CPU resources. I am running MS SQL Server 2008 and want to make sure that the file is not related.  Looking in Task Manager, the file is Ssms.exe.  I would have thought MS SQL Server would be loading under a "System" user name. Some sites have this listed as a virus and remove, but I want to make sure before I do so. Please assist.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Infrastructure Engineer
Commented:
ssms.exe is SQL Server Management Studio. Do you have this running?

Lee

Author

Commented:
Yes, I'm wondering why all of a sudden it is hogging 50% of the cpu.  Never has done this before.
This is a virus, Try to clean it by an Antivirus like Bitdefender.
How to Generate Services Revenue the Easiest Way

This Tuesday! Learn key insights about modern cyber protection services & gain practical strategies to skyrocket business:

- What it takes to build a cloud service portfolio
- How to determine which services will help your unique business grow
- Various use-cases and examples

Author

Commented:
Well, I shut it down and SQL Server shut down.  Which is it??
Lee OsborneSenior Infrastructure Engineer

Commented:
I'm not sure why this would use so much CPU either. I'll see if I can find anything else out for you.

Lee
Adam MenkesC# ASP.NET Developer
Top Expert 2010

Commented:
It may not be a virus. It could just be hogging resources, depending on what is running.  Low memory, low disk space, lots of activity (reads / writes).

To change the process to a system account, go into Configuration Tools, SQL Server configuration manager. Change the drop down to a system account. Restart the service.

Service.png
Top Expert 2012

Commented:
babakneza,

Please post a message in Community Support to have your comment here http:#a33110369 deleted as you have violated the EE Guidelines on copyrights see here:
About copyrights
Copying and pasting a web page or other document is considered copyright infringement in most cases. If you want to refer to someone else's work the preferred method is to post the link with a brief description of it. Posts that consist entirely of work copied and pasted from other sites will generally be deleted unless it's from your own work.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial