Link to home
Start Free TrialLog in
Avatar of piotrmikula108
piotrmikula108Flag for United States of America

asked on

Multiple CMD.EXE without process file on SQL server 2003

My SQL server just came to halt when users started  complaining that their application run slow, I remote to it and found hundreds of CMD.exe's Rebooted the server and it's better but in Task Manager (pic attached) I can still see blank CMD.exe and there is more and more of them. I'm running a virus scan on it right now but what else could that be if not a virus?
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image

>> I'm running a virus scan on it right now but what else could that be if not a virus?

If it is not Virus, then many users are trying to connect to your server using SQLCMD mode..
Find out the reason why they are using SQLCMD, Check the credentials involved and verify it out..
Also find out the reason why they are spanning for a longer period of time..
Avatar of piotrmikula108

ASKER

no viruses found and my "DBA" has no idea where this could be coming from.

any other ideas where to look?

Thank you so much
Just run a profiler trace so that you can find

* Which application is establishing connections to your server
* what exactly they are doing in that connection

This would help you identify the reason for the multiple connections..
ASKER CERTIFIED SOLUTION
Avatar of piotrmikula108
piotrmikula108
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial