How to install the SNMP service on Microsoft Hyper-V R2

Another quick post/reminder to myself. I’ve been experimenting with the idea of using Cacti to monitor the performance of my Hyper-V servers, so i needed SNMP on my HyperV machines. However there is no UI to add that feature into the core installs. So, to install SNMP on HyperV R2, use the following command line

start /w ocsetup SNMP-SC

That’s it!

Enabling xp_cmdshell

A quick post on how to enable xp_cmdshell on Sql 2005/2008/2008R2

EXEC sp_configure ‘show advanced options’, 1
GO
RECONFIGURE
GO
EXEC sp_configure ‘xp_cmdshell’, 1
GO
RECONFIGURE
GO
EXEC sp_configure ‘show advanced options’, 0
GO
RECONFIGURE
GO

Done.