Server recommendation for a small office

June 17th, 2010

Occasionally an office with maybe 5 people will need a server type product usually to host a vertical market database.  A recent example is a local eyecare office running OfficeMate.   OfficeMate uses a Microsoft SQL database server engine and can run on Windows XP or newer.  My discussions with the owner focused on several factors:

1. The ideal server would consist of major manufacturer server hardware running Windows Server (set aside arguments for Novell, Linux, NAS boxes, etc. for now).

2. The next best idea is a new PC dedicated to the task of hosting OfficeMate.   That means no users running applications.  Servers are reliable in good part because they don’t have users running apps, using up memory, possibly causing conflicts and interactions leading to crashes and lockup.

3. Note the several problems and limitations of running a workstation operating system as a “server”.  In a small environment the problems are minor such as:  a) a 10 user connection limitation b) no centralized management of login scripts c) router must provide DHCP d) for the most part, functionality is limited to fileserving only

MicroCenter PowerExec workstation

June 17th, 2010

In may and June two clients purchased batches of new PowerExec computers from MicroCenter.  The first batch of 4 quad core workstations was setup using Windows XP.  The installation went smoothly.  A few weeks later a second identical batch of 3 PowerExec’s was acquired and installed at another company.  One of the computers gave no trouble. Intermittent network connectivity problems began arising on the other two.  Troubleshooting ensued and replacment drivers were tried out on the built-in network adapter.  Eventually a set of drivers was found that worked well.  What’s interesting is that early on an add-in network adapter was tried and exhibited similar problems!  Sometimes malfunctioning hardware/software symptoms do not make sense.  When the add-in network adapter had problems that was very misleading and lead to wasted time troubleshooting wiring and switches.

MicroCenter PowerExec Server (thumbs down)

June 16th, 2010

The server was priced right and came equipped with a quad core processor and Windows Server 2008 (Foundation version).   Ultimately some severe problems were resolved but it took some doing.  The server would shutdown frequently and especially when the network adapter was accessed. Performance was dismal – transferring files hundreds of times too slowly.   Often vertical stripes appeared on the screen and Windows would lock.  The built-in network adapter cannot be disabled in the bios and when a PCI type network card was inserted the bios lost it’s settings and the 3 drive RAID 5 array would not boot. Ultimately, stability was restored by setting the bios to RAID again and disabling both the video adapter and the built-in network adapter in Device Manager. Video works fine now as “Standard VGA Adapter” even at high resolution. The add-in network adapter is also working well and the lockups and crashes have stopped.  The underlying problem is lack of cohesive driver and firmware support.  MicroCenter pieced the computer together but has no plan for long term support.  The user is on his own in finding updates. Intel makes a good product but they have so many variations and generations of products (in this case the mainboard) that updating firmware and drivers is next to impossible.  In this case drivers and utilities found on the Intel website actually exacerbated the problems.

Other problems you wouldn’t expect from a server vendor:  1) no manual  2) MicroCenter’s driver disk is very poorly organized; there is no RAID monitoring software 3) the mainboard is listed by Intel as a workstation board not a server board

Backup

June 14th, 2010

There are many options for backup that did not exist or were expensive  just a few years ago.   Modern hardware and technologies such as flash drives, external hard drives, copying (ghosting) of hard drives, Internet backup and  syncing files to another computer are now readily accessible even to home users. At minimum, whether your important files were generated for home or office, you should have at least one copy of anything that is important and that copy should be updated frequently.  In a business environment I’ll often have five different backup techniques protecting data.  We’ll mirror server data to 2 or more hard drives, periodically create images of the server’s configuration, setup rotating nightly data file backups to internal drives, external drives or both, sync important files to offsite commercial services or the customers own website, sync files to other workstations at the site .  The goal is to quickly recover from any disaster ranging from a simple hard drive failure to the site being flooded or destroyed by a tornado!  More frequently, a file is inadvertently deleted or an older version of a file needs to be retrieved.

Viruses

June 14th, 2010

Viruses are getting more sophisticated and difficult to remove  every year.   About a year or so ago I began to see viruses programmed to destroy System Restore points and damage the Windows registry – in some cases so severely that rebuilding the configuration was faster than repairing the damage.  That’s why my current practice is to install an automatic registry backup program.   As long as I have a current backup of the registry I’m able to restore the computer to normal operation without resorting to a rebuild.   To remove viruses I often use process explorers, utilities to remove files and folders on reboot, direct registry editing, the manually deletion of files and folders from the command line, booting XP from a special CD, booting in Safe Mode, etc.   The old technique of scanning takes too long and modern viruses once installed are typically not removeable by antivirus progams anyway.

Computer Tuneup

June 14th, 2010

Computers often arrive cluttered with many unnecessary programs that load every time you startup. There are a number of benefits to disabling and/or uninstalling these programs but you’ll notice faster startup and operation first.  Over time you’ll experience fewer pauses, lockups and crashes.   A tuneup is not complete unless the latest Service Packs and security patches have been applied to the operating system.   Most people are not aware of what security patches do or that you can get a virus just from your computer being on!   Hackers (usually automated processes) are clever enough to find ways into your computer whether you’re running a program or not.  Known weaknesses in Windows and other common programs are the target.  It works like this:  1)  an automatic process systematically scans remote computers until it finds a known weakness/entry point.  2) The exploit is implemented by an automatic process  3)  You are hacked and your data is potentially harvested.   The best defense is a combination of techniques such as applying security patches as they are released, using a good firewall, using a fully updated web browser, leaving User Account Control on or for XP installing a program to monitor installation processes.