Hi im a beginner and working as a tech suppport in a big organization to monitor the SQL server, one colleague has created an alarm system using CA spectrum which detects any errors, high cpu utilization etc so he asked me what type of services to be monitored in that alarm system , so i don't know that what are the important services in SQL server which should be monitored for smooth function of SQL 2012 in our office, when we go to services.msc what are the important services to watch out for ???

please anybody help me out with this problem i will be glad to have a support from you guyzz

Thank You

Hi,

I hope you know SQL Server configuration manager. Please go to SSCM and see what all services are listed and then you can give that services to be monitored

A "might be enough" version of this is built into Windows. Look into the "Recovery" tab of the service properties, as available via services.msc.

You can act on a service fail with:

"Restart the Service"
"Run a Progam"
"Restart the Computer"
"Run a program" could be a small script that sends a mail, for example.

If you want a bigger solution with an overview dashboard and all, there are plenty of system monitoring solutions available. For example SolarWinds IPMonitor comes to mind, or Nagios, or Cacti.

If you are interested in some .NET programming, The System.ServiceProcess namespace provides classes that allow you to implement, install, and control Windows service applications.

Simple example, checking and starting a service in C#:

var srv = new ServiceController("MyService");
Console.WriteLine("MyService Status {0}", srv.Status);
if (srv.Status != ServiceControllerStatus.Running)
    srv.Start();

Also, I want to point out the wmic tool.

wmic /node:[hostname] service list

is able to list the services of any computer

WMIC SERVICE where caption='TELNET' CALL STARTSERVICE

would restart the telnet service.

If you encapsulate wmic in a script language (able to send email), you can have the monitoring tool you are looking for

• Edited by Andrey Langovoy Friday, July 31, 2015 5:40 AM

list me the important services from services.msc in SQL server 2012 which should be in running mode all time and are very  important, I just want the names of services ???? reply soon

list me the important services from services.msc in SQL server 2012 which should be in running mode all time and are very  important, I just want the names of services ???? reply soon

Nobody is going to reply to your silly question why dont you yourself go to SQL Server configuration manager and see the services. All services listed there are important

Please avoid spoonfeeding attitude I know you are smart enough to note services from SSCM