Hi,
Today I noticed one service that was hanged in Starting state. Through GUI I could not stop it or start it.
Since I got PID (process ID) from my query, I can kill the process
Now the process has been killed, we can start it once again with
net start <ServiceName>
Good Luck