Tuesday, October 8, 2013

UniFi 2.4.5 is released

Ubiquiti Networks released an update for their UniFi Wireless Access Points.
http://community.ubnt.com/t5/UniFi-Updates-Blog/UniFi-2-4-5-is-released/ba-p/544456

We are very pleased with these devices.  The update appears to have fixed a number of issues we were experiencing.  The biggest of which was Android Phones couldn't connect when they were in between 2 access points.  We've configured them to host two different SSID's. One for the public network and one for private network.  Best part is, you can enable isolation on the public network SSID. This prevents mobile users connected to the public network from reach resources on the private network (and each other for that matter).

The central management is a long time coming, very intuitive, and reduces the amount of time required to change the Network Password or push out Firmware Updates.  It also has the (somewhat creepy) ability to track users as they connect to different access points while walking through the office.

Our only complaint is not being able to run the Web Interface as a service.  It appears to run as a user, who has to be logged into the server.

If you're running the UniFi devices be sure to push out this update.
If you're in the market for new Access Points be sure to check these out.
http://amzn.com/B005EORRBW

Thursday, October 3, 2013

SBS 2003 MSSQL$SBSMONITORING is using too much RAM

q: We are getting alerts from a server "A large amount of memory is committed to applications and processes. Consistently high memory usage can cause performance problems." Task Manager shows the MSSQL$SBSMONITORING service is using over 500MB of RAM.  We restarted it, but after a few days it climbs back up.
a: Just like with every MSSQL server, you have to set a limit to how much memory it can use, or it will use it all.

C:\Documents and Settings\Administrator>HOSTNAME
SERVER1

C:\Documents and Settings\Administrator>OSQL -E -S SERVER1\SBSMONITORING
1> sp_configure 'show advanced options',1
2> reconfigure with override
3> go
Configuration option 'show advanced options' changed from 0 to 1. Run the
RECONFIGURE statement to install.
1> sp_configure 'max server memory',100
2> reconfigure with override
3> go
DBCC execution completed. If DBCC printed error messages, contact your system
administrator.
Configuration option 'max server memory (MB)' changed from 2147483647 to 100.
Run the RECONFIGURE statement to install.

1>