On one of my SQL Servers the SNMP service, ongoing for nearly 20% of the CPU. Rather than restart the service I took the opportunity to completely restart the server and apply the latest up-to-day. The launch of Windows I got an error message indicating a crash snmp.exe. At first I thought a port problem but errors in the Event Viewer did not match:

Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7034
Date: 20/10/2009
Time: 6:52:40 p.m.
User: N / A
Computer: SERVERSQL
Description:
The SNMP Service service terminated unexpectedly for the first time.

Finally I discovered that the problem was an extension of the SNMP service installed by my Adaptec RAID controller card. To disable this extension simply run Regedit, go to HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ SNMP \ Parameters \ ExtensionAgents and delete the value containing the data aussnmp SOFTWARE \ Adaptec \ RAIDController \ AAC \ CurrentVersion.

This data is apparently he recreated each time you restart the machine, it will therefore be to think of removing the value manually, or simply create a startup script to delete this value automatically.

Tags: Monitoring , RAID , SNMP

On one of my Windows 2003 server the SNMP service could no longer start up properly: each attempt to start a little informational message appears:

The SNMP Service service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, service alerts and performance logs.

In the event log, no error message but a succession of information:

Event Type: Information
Event Source: Service Control Manager
Event Category: None
Event ID: 7035
Description: A start control has been successfully sent to service SNMP Service.

Event Type: Information
Event Source: Service Control Manager
Event Category: None
Event ID: 7036
Description: The SNMP Service service entered the stopped state.

Event Type: Information
Event Source: SNMP
Event Category: None
Event ID: 1003
Description: The SNMP service successfully stopped.

Nothing very clear about the problem so ...

In my case I eventually discovered that the port 161 by default the SNMP service was used by another service. To solve the problem just go to C: \ Windows \ system32 \ drivers \ etc and edit the file services. We must then change the line:

snmp 161/udp #SNMP

by

snmp 165/udp #SNMP

for example.

Once this line changed and saved the file, the SNMP service is properly started.

Tags: Monitoring , SNMP , Windows 2003

Cacti is a monitoring system to monitor machine server and client machines through SNMP in Perl scripts or using WMI on Windows. This system allows you to create graphics on various elements of a position such as CPU usage, statistics / O on disks or the types of queries on an IIS server.

In this article we will see how to install Cacti on a Windows 2003 + IIS 6 + PHP 4.4.9 + MySQL 5.1.30 + phpMyAdmin 2.11.9.4. To learn how to implement such a system, refer to this article .

Continue reading "Installing Cacti on Windows / IIS 6"

Tags: Cacti , Monitoring , Windows 2003

To identify users that consume a SQL Server simply use the following query:

SELECT
TOP 20
SPID, Blocked,
convert(varchar(10),db_name(dbid)) as Base,
CPU,
datediff(second,login_time, getdate())/60 as Minutes,
convert(float, cpu / datediff(second,login_time, getdate())) as PScore,
convert(varchar(16), hostname) as Hôte,
convert(varchar(20), loginame) as Login,
convert(varchar(50), program_name) as Programme
FROM master..sysprocesses
WHERE datediff(second,login_time, getdate()) > 0 and SPID > 50
ORDER BY PScore desc

The higher the PScore, the higher the use of the base is intensive.

Similarly one can determine the most demanding programs by observing the column BFactor when running the following query:

SELECT
convert(varchar(50), program_name) as Programme,
count(*) as CliCount,
sum(cpu) as CPUSum,
sum(datediff(second, login_time, getdate())) as SecSum,
convert(float, sum(cpu)) / convert(float, sum(datediff(second, login_time, getdate()))) as Score,
convert(float, sum(cpu)) / convert(float, sum(datediff(second, login_time, getdate()))) / count(*) as BFactor
FROM master..sysprocesses
WHERE spid > 50
GROUP BY
convert(varchar(50), program_name)
ORDER BY score DESC

Tags: Monitoring , SQL Server