thaxor

We’re having a custom app developed for us that was having some speed problems after the server had been up for a while. I downloaded Sysinternals Process Explorer http://technet.microsoft.com/en-us/sysinternals/bb896653.aspx and started digging around for problems. (haven’t mastered performance monitor yet) Tip: if you hover over the sqlservr.exe in Process Explorer it will give you the instance name in a hover balloon so you know which one is eating up memory.

I found the SBSMonitoring instance of SQL using 1.2 GB ram. For an application that looks relatively simple that amount of ram consumption seemed too high. To fix the problem I did some digging and found these pages:

http://msdn.microsoft.com/en-us/library/ms178067.aspx
Use Performance Monitor to set the “correct” ram usage on the SQL Server instance by using  the SQLServer:Buffer Manager object. Or just guess randomly like me.

http://dogriley.blogspot.com/2005/08/sqlservrexe-high-memory-usage-for.html
Set the maximum ram though CMD prompt

If you’ve got SQLServer Management Studio installed you can do it though GUI instead of CMD.

Connect to the instance of SQL, in this case “ServerName\SBSMONITORING”
Right click the Database instance and select properties
Then click the Memory section and put in your “Maximum Server Memory” (I set mine to 100MB)

Since our staff uses sharepoint VERY little I decided to limit that instance to 500MB. Connecting to that with SSMS wasn’t as easy as the SBSMonitoring instance. If you type in “ServerName\MICROSOFT##SSEE” it doesn’t connect. However this text does work “\\.\pipe\mssql$microsoft##ssee\sql\query”

Had problems connecting OSX 10.4.11 to our new 2008 Small Business Server. Lots of stuff on Google but no one place seemed to have the silver bullet so I turned to old reliable, the [H]Forums. Turns out you need to adjust some settings on the domain controller having to do with encryption.

Problem: Macs couldn’t access shares over SMB
Solution:

Group Policy Management > +Domains > +Domain.Name > +Domain Controllers > Right click Edit Default Domain Controllers Policy

+Policies > +Windows Settings > +Security Settings > +Local Policies > Click User Security Options

Microsoft network client: Digitally sign communications (if server agrees) : ENABLED
Microsoft network server: Digitally sign communications (always) : DISABLED
Microsoft network server: Digitally sign communications (if client agrees) : ENABLED

Start > Run > gpupdate /force (not sure if this step is needed)

I was trying to access the internal SharePoint site at work and kept getting authentication requests while in FireFox. Some googling turned up the following fix.

In the Firefox address bar type “about:config”
Locate the key called “network.automatic-ntlm-auth.trusted-uris”

Double click and put in a comma seperated list of all your internal sites. In this case I needed to add “companyweb” Didn’t even need a restart and FF no longer asks me for authentication to the SharePoint site

Working on my OpenAudit view.  Trying to get down to 1 report that I can use to prioritize software/hardware upgrade paths for all staff.

This test is just to pull out Office and Windows verision/keys. Not interested in extra stuff like Visio or Project right now since they’re special cases.

Had to do some hacking because even though only Outlook from SBS 2003 is installed on a few computers OpenAudit reads it as full Office 2003 messing up the reporting. To fix this on machines that had OEM Office 2000 installs that don’t register I added the search for ‘Microsoft Office Outlo’

SELECT s.net_user_name, s.system_name, m1.ms_keys_uuid,
if( left( m1.ms_keys_name, 22 ) = ‘Microsoft Office Outlo’, ‘n/a’, m1.ms_keys_name ) AS OfficeVersion,
if( left( m1.ms_keys_name, 22 ) = ‘Microsoft Office Outlo’, ‘n/a’, m1.ms_keys_cd_key ) AS OfficeKey,
m2.ms_keys_name as WindowsVersion, m2.ms_keys_cd_key as WindowsKey
FROM `system` AS s
INNER JOIN `ms_keys` AS m1 ON s.system_uuid = m1.ms_keys_uuid
LEFT JOIN `ms_keys` AS m2 ON m1.ms_keys_uuid = m2.ms_keys_uuid
WHERE left( m2.ms_keys_key_type, 6 ) = ‘window’
AND (left( m1.ms_keys_name, 22 ) = ‘Microsoft Office Profe’
OR left( m1.ms_keys_name, 22 ) = ‘Microsoft Office Small’
OR left( m1.ms_keys_name, 22 ) = ‘Microsoft Office Outlo’)
GROUP BY m1.ms_keys_uuid