Lucky Luke's questions

Despite researching this topic quite a bit online (to be fair I'm not a full time sysadmin) I'm unable to figure this out.

We have a bunch of VMWare ESXi 5.5 servers, some of which are integrated into vSphere, some of which are not (for cost reasons).

All of them run the standard ESXi image, with the exception of one machine which is actually running the DELL VMWare ESXi image.

What I would like to accomplish seems simple: Configure the system so that it can be queried via SNMP from a remote host, whether it's snmpwalk, Nagios, PRTG etc. I'd like to see information from temperature sensors, installed disks and their status, fan speed, PSU status etc.

I was under the impression that installing the VMWare version from DELL would automagically enable the necessary modules (OpenManage most importantly), but it seems like that is not the case.

I have conflicting information whether this is even possible at all, some documents say that you cannot query a DELL VMWare ESXi server via SNMP and you need to use a CIM client. Then there is the OMSA VIBs one can install, etc.

I imagine this being a fairly common requirement, yet the docs available pull one in all different directions.

Is what I am trying to do possible (without a complete vSphere environment) even possible?

I have a table with a clustered index, which shows ~70% fragmentation on a SQL Server 2008 database. I'm trying to rebuild this index:

ALTER INDEX PK_Table1Index ON Table1 REBUILD

The statement returns immediately with success, however the fragmentation is not changing. If I review the fragmentation in the SSMS, it remains the same.

I'm suspicious that it returns immediately, so it seems as if it's not doing anything. Since a clustered index determines the table layout on disk, I'd assume that this would have to be an offline task?

I guess I'm missing something and was hoping somebody could shed some light.