SNMP Enterprise Specific Trap (.3038)

NT Event ID: 1204 (Hex)0x843504b4 (cpqstmsg.dll)
Log Severity: Warning (2)
Event Title: Drive Array Accelerator Status Change.
Log Message: The array accelerator board attached to the array controller in %4 has a new status of %2.
SNMP Trap: cpqDa6AccelStatusChange – 3038 in CPQIDA.MIB
Symptom: Accelerator Board Status Change. This trap indicates that the agent has detected a change in the status of an array accelerator cache board. The current status is represented by the variable cpqDaAccelStatus.
User Action: If the accelerator board status is permDisabled(5), you may need to replace the accelerator board.
Supporting SNMP Trap Data:
• sysName
• cpqHoTrapFlags
• cpqDaCntlrHwLocation
• cpqDaCntlrModel
• cpqDaAccelCntlrIndex
• cpqDaAccelSerialNumber
• cpqDaAccelTotalMemory
• cpqDaAccelStatus
• cpqDaAccelErrCode
Supporting SNMP Trap Description: “Status is now [cpqDaAccelStatus].”

This trap may be accompanied by trap 3040:

Event ID 1206
Drive Array Accelerator Battery Failed. The array accelerator board attached to the array controller in Slot 3 is reporting a battery failure.
[SNMP TRAP: 3040 in CPQIDA.MIB]

SNMP Enterprise Specific Trap (.18013)

NT Event ID: 1292 (Hex)0x4435050C (cpqnimsg.dll)
Log Severity: Information (1)
Log Message: Redundancy has been increased by the NIC in slot %1, port %2. Number of functional NICs in the team: %3.
SNMP Trap: cpqNic3RedundancyIncreased – 18013 in CPQNIC.MIB
Symptom: This trap is sent any time a previously failed physical adapter in a connected logical adapter group returns to the OK condition. This trap is not sent when a logical adapter group has connectivity restored from a Failed condition. The cpqNicConnectivityRestored trap is sent instead. This can be caused by replacing of a faulty cable or connecting a cable that was disconnected.
User Action: None required.

Supporting SNMP Trap Data:
• sysName
• cpqHoTrapFlags
• cpqNicIfPhysAdapterSlot
• cpqNicIfPhysAdapterPort
• cpqSiServerSystemId
• cpqNicIfPhysAdapterStatus
• cpqSePciSlotBoardName
• cpqNicIfPhysAdapterPartNumber
• ipAdEntAddr
• cpqNicIfLogMapIPV6Address
• cpqNicIfLogMapAdapterOKCount
Supporting SNMP Trap Description: “Redundancy increased by adapter in slot [cpqNicIfPhysAdapterSlot], port [cpqNicIfPhysAdapterPort].”

Reference

Useful Perfmon Counters for SQL Server

I recently came across a useful poster showing Perfmon Counters for SQL Server.

You can download the PDF file here: SQLServer-Perfmonance-Poster

Setting up NTP for Server 2000 DC

Problem

You need to setup NTP on a Windows 2000 Server, then resync other servers (2000 and 2003 servers) to that one.

Solution

  1. First, query the current settings:
    net time /querysntp
  2. Set the NTP source server:
    net time /setsntp:uk.pool.ntp.org
  3. Stop and Start the Windows Time service:
    net stop w32time && net start w32time
  4. Force a resync on Win 2000 servers:
    w32tm -s
  5. Force a resync on Win 2003 servers:
    w32tm /resync

Source

Enterprise Specific Trap (.9001) Uptime: x days, [Time], .iso.3.6.1.2.1.1.5.0 = STRING: “[Server Name]”, .iso.3.6.1.4.1.232.11.2.11.1 = INTEGER: 0

This SNMP trap was being triggered every now and again. Like many SNMP messages, there’s not always anything useful within them to help explain what actually happened.
Here’s an example:
Description: [IP Address]: Enterprise Specific Trap (.9001) Uptime: x days, [Time], .iso.3.6.1.2.1.1.5.0 = STRING: “[Server Name]”, .iso.3.6.1.4.1.232.11.2.11.1 = INTEGER: 0

In my case, a scheduled reboot caused the iLO on an HP BL460c Blade to trigger the SNMP alarm, which HP call “Server Reset Detected”.

Source

Data Deduplication in Server 2012

Just read this great post on Data Deduplication in Server 2012: http://blogs.technet.com/b/keithmayer/archive/2012/12/12/step-by-step-reduce-storage-costs-with-data-deduplication-in-windows-server-2012.aspx#.UNRb3G_Zbzg

The post details that “enterprise organizations report that as much as 60% of their annual capital IT budget is related to storage hardware”, then goes on to explain data deduplication, and how to enable this feature in Server 2012.

Once the role is enabled, you can run DDPEVAL.exe, which will estimate the amount of disk space that can potentially be reclaimed by moving that data to a Windows Server 2012 NTFS volume with Data Deduplication enabled.

Here’s an excerpt:

When I’ve executed this against various shared folders on my servers, I’ve seen it compute anywhere between 30% – 80% estimated disk space reclamation, depending on the level of duplication on a volume and staleness of data.  Wouldn’t it be great to have 30% or more of your storage budget returned next year to spend on other projects?  Results may vary volume to volume, so I’d be very interested in hearing about your results!

What is Cloud Computing?

I just heard the best definition of cloud computing, on the IT Pro Podcast:

Cloud computing is a model for enabling ubiquitous, convenient, on-demand network access to a shared pool of configurable computing resources that can be rapidly provisioned and released with minimal management effort or service provider interaction.

Source: http://www.nist.gov/itl/csd/cloud-102511.cfm

Scheduled Reboot Command

To schedule a reboot, create a batch script with the following command:

:: Reboots the computer in 5 mins
shutdown -r -t 300 -c "A scheduled reboot will occur in 5 mins. Open command prompt and type 'shutdown /a' to abort." -f -d P:0:0

This will alert any logged on users that the computer will reboot in 5 mins, and can be aborted by running shutdown /a.

Lastly, create a scheduled task to run the batch script at the required time.

Events

Event ID 1074 will occur in the System log when the command is run:
shutdown-event

Event IDs 6009, 6005 and 6013 will also appear in the System log, with a Source of EventLog.

The precise stop and start time can be found in Event IDs 13 and 12, in the System log, with a Source of Kernel-General.

Related Events

If a Windows Update requires a reboot, you may get Event ID 22 with a Source of WindowsUpdateClienthttp://technet.microsoft.com/en-us/library/cc735614(v=ws.10).aspx

mRemoteNG Connections Disappear / Lost All Connections

Scenario

You use the excellent mRemoteNG software; possibly the best Remote Connections Manager in the world…and FREE!

Unfortunately, sometimes there’s a bug which resets / deletes / clears your connection file each time you close mRemoteNG, so the next time you open it, all your connections have disappeared. The only thing not lost is the root folder with a name like mR|Export (20121211 20:07:53).

Solution

Open up the connection file (eg. confCons.xml) and change the value for Export from True to False:

A simple fix, but this one stumped me for a while.

Hopefully this will help others with the same issue.

Another little tip

If you want to open a specific connection file, you can create a shortcut and use the /cons: commandline switch.

[Read more…]

Installing Citrix Receiver

Scenario

You need to access resources via Citrix XenApp, but you don’t have Citrix Receiver installed.

Solution

Install Citrix Receiver.

If Citrix Web Interface is configured with Client Detection enabled:

and the C:\inetpub\wwwroot\Citrix\XenApp\conf\WebInterface.conf file has the correct spelling for the client filenames:

ClientIcaMac=Filename:CitrixReceiver11_4_3.dmg,Directory:Mac,Mui:Yes
ClientIcaWin32=Filename:CitrixReceiver.exe,Directory:Windows,Mui:Yes,ClassID:238f6f83-b8b4-11cf-8771-00a024541ee3

NOTE: the [install source]\Citrix Receiver and Plug-ins\Windows and [install source]\Citrix Receiver and Plug-ins\Mac folders need to be copied from the install ISO to C:\Program Files (x86)\Citrix\Web Interface\5.4.0\Clients

you will be prompted to install Citrix Receiver:

[Read more…]