SQL [sqlservr.exe] Memory Consumption on Small Business Server July 7, 2009
Posted by Gomez in IT, Microsoft, Performance & Alerts.Tags: allocated memory for sql, SBS, sql memory, sql server, sqlservr.exe
1 comment so far
I started receiving alarms that pages/sec on my client’s SBS Server was 6952.92 pages/sec. Please note that Microsoft Best Practices recommends no more than 20 pages/sec.
I found that sqlservr.exe was consuming in excess of 1.5GB of memory. This is been a known issues for Servers running Small Business Server, I will walk you through the process of reducing usage for this memory thirsty process.
1. Open Task Manager > Processes Tab, View Menu > Columns, select PID check box.
2. In the list of processes locate the sqlservr.exe process that is consuming the most memory (there might be multiple instances of sqlservr.exe) take note of the PID number next to the memory thirsty process.
3. Open a command prompt and issue the following command without the quotes,
“tasklist /svc” (this is used to display running processes (PIDs) and applications)
next to the PID number previously identified in taskmanager take note of the service name.
The service would be MSSQL$SBSMONITORING.
4. At the command prompt issue the following commands, after each command press enter;
Command 1: osql -E -S SERVERNAME\sbsmonitoring
(replace SERVERNAME with the hostname of your server, sbsmonitoring is the service name )
Command 2: sp_configure ‘show advanced options’,1
Command 3: reconfigure with override
Command 4: go
Command 1: sp_configure ‘max server memory’, 200
(200 represent memory size in MB, replace 200 with any memory size you wish, default is 2147483648)
Command 2: reconfigure with override
Command 3: go
Guyana Linux Users Group Snort installation July 7, 2009
Posted by daakeung in IT, Linux, Uncategorized.Tags: centos snort, glug, ids, intrusion detection, intrusion preventation, ips, snort
add a comment
Every month now, GLUG meets up to discuss and share ideas. Last GLUG meeting I volunteered to do an installation of SNORT on CENTOS and live demonstration. It was a privilege to contribute to such a growing community in Guyana. Also Mike Harrison of Utiliflex took part to offer us his valuable experience and motivation.
Download: snort_installation_presentation
Quick guide how to Setup a linux dhcp server (Centos 5.2) July 3, 2009
Posted by daakeung in Uncategorized.Tags: centos dhcp server, dhcp server, linux dhcp
2 comments
Quick guide to setup a linux DHCP server on a 10.0.0.0/24 network, you can modify this to work with your own design.
[root@dhcp ~]# yum install dhcp
[root@dhcp ~]cp /usr/share/doc/dhcp-3.0.5/dhcpd.conf.sample /etc/dhcpd.conf
cp: overwrite `/etc/dhcpd.conf’? y
[root@dhcp ~]vi /etc/dhcpd.conf
ddns-update-style interim;
ignore client-updates;
subnet 10.0.0.0 netmask 255.255.255.0 {
# — default gateway
option routers 10.0.0.1;
option subnet-mask 255.255.255.0;
#option nis-domain “akeung.com”;
option domain-name “akeung.com”;
option domain-name-servers 10.0.0.25;
option time-offset -18000; # Eastern Standard Time
# option ntp-servers 192.168.1.1;
# option netbios-name-servers 192.168.1.1;
# — Selects point-to-point node (default is hybrid). Don’t change this unless
# — you understand Netbios very well
# option netbios-node-type 2;
range dynamic-bootp 10.0.0.2 10.0.0.254;
default-lease-time 21600;
max-lease-time 43200;
# we want the nameserver to appear at a fixed address
# host ns {
# next-server marvin.redhat.com;
# hardware ethernet 12:34:56:78:AB:CD;
# fixed-address 207.175.42.254;
# }
}
Then esc, press
:wq
To start the service :
service dhcpd start
To enable it at bootup :
chkconfig dhcpd on
You can locate the leases at :
/var/lib/dhcpd/dhcpd.leases
Also, if a reservation is needed. Simply add the following to /etc/dhcpd.conf
host daakeung {
option host-name “daakeung.akeung.com”;
hardware ethernet 00:00:00:00:00:00; #<—-Replace with Client’s MAC address
fixed-address 10.0.0.7;
}
Cisco Dual Wan Fail-Over using SLA Tracking July 3, 2009
Posted by daakeung in Cisco, IT.Tags: cisco dual wan, cisco ios, fail over cisco, fail over using ip, route tracking, sla tracking
5 comments
- Physical : the router would detect one of its interface not connected, invalidated any next hop routes through it. In turn move to another valid route with a higher metric.
- Logical : the router has it’s interface online, but somewhere along the path it has to take to reach the destination is unavailable.
Cisco Dual WAN
Cisco IOS used: c181x-adventerprisek9-mz.124-24.T
! Identify the SLA.
ip sla 10
! Set up the IP address to ping, in this case yahoo.com ip.
icmp-echo 69.147.114.224
! Set how long in milliseconds to wait for a reply.
timeout 1000
! Repeat Rate.
frequency 3
! Start SLA 10 from now to forever.
ip sla schedule 10 life forever start-time now
! Setup track 10 to sla 10 for reachabilty.
track 10 ip sla 10 reachability
! Setup route for testing reach ability to the internet.
ip route 69.147.114.224 255.255.255.255 10.0.0.1
! Setup primary link with track 10 parameter.
ip route 0.0.0.0 0.0.0.0 10.0.0.1 track 10
! Setup fail-over link with higher metric.
ip route 0.0.0.0 0.0.0.0 192.168.0.1 20
Depending on your configuration, you will need to setup NAT on both interfaces.
How Save Outlook Auto Complete List June 18, 2009
Posted by Gomez in E-Mail, IT, Microsoft.Tags: Auto Complete List, Microsoft Office, Outlook 2003, Outlook 2007, Outlook Cache
add a comment
Outlook 2003 and Outlook 2007 have a feature called Email Address Auto Complete. As you type in an email address into the TO:, BCC or CC: field outlook will display a list of matching email addresses from the outlook auto-complete cache.
Ok now we know what auto complete is, let located the file;
Close Outlook.
Open Windows Explorer and enter the following address in the Address bar: %appdata%\Microsoft\Outlook (this is the same as drive:\Documents and Settings\username\Application Data\Microsoft\Outlook) Windows Explorer will update to the appropriate Outlook folder. In this folder you would see the .nk2 file(s). Now to explain every Microsoft Outlook profile will have its own .nk2 file e.g. the default profile name is outlook so you will see the outlook.nk2 file. Just make a copy backup of this file, that’s all to it, you are done!
If you are not too sure what your current profile(s) are you can open mail icon in control panel and on the Mail Setup – Outlook dialog box, client on Show profile, here you can see all your default profiles.
Now let’s say that on the computer you want to restore/replace the outlook.nk2 file has a different profile name e.g. exchangepro is the name of the profile on the target computer, all you need to do is navigate to: %appdata%\Microsoft\Outlook, paste the outlook.nk2 file then rename it to profilename.nk2 (in this example exchangepro.nk2). Open Microsoft outlook and enjoy.
ITunes has detected an iPod in recovery mode on Windows PC June 13, 2009
Posted by Gomez in Apple.Tags: Apple IPod, IPod, IPod Recovery, ITunes
11 comments
FIRST: This minor issue could give someone with love for music headaches so I am sharing my experience/ solution with you.
Now if you follow ITunes recommendation to restore your IPod, that’s ok, but it will never stop asking to restore your IPod. Remember a restore is a factory default, so all of your files would be wiped!
SOLUTION: This iPod error message is caused when you have a removable device other than your iPod plugged into a USB port and occupying the drive letter the IPod previously used. All you need to do is unplug all removable USB devices, Open Computer Management > Disk Management, look for your IPOD device ,right click on your iPod device and click change drive letter, assign a new drive letter to your IPOD device, after successful change, unplug IPOD data cable, and reconnect the cable. Your IPod would display as normal.
Where are my CALS? June 13, 2009
Posted by Gomez in IT, Network Services, Microsoft.Tags: Small Business Server, Client Access Licenses, SBS License Store, SBS 2003
add a comment
For all my fellow Small Business Server users, this week I was greeted with an issue with one of my client’s informing me that they are not able to access the mapped network drives “Connection to resource has exceeded maximum connections” After extensive searching in Event Viewer > System logs, I came across the following entry;
Event Type: Error
Event Source: SBCore
Event Category: None
Event ID: 1023
Date: 6/11/2009
Time: 7:08:27 PM
User: N/A
Computer: XXXXXX
Description:
The license store for the client access licenses is not valid. Only the minimum number of client access licenses will be available until a valid license store is restored. For more information, see Help in the Licensing snap-in.
Open Server Management > Licenses, found that installed CALs (50 Client access licenses) disappeared leaving only the default “5”.
There are three main methods for restoring the License Store.
Method 1: If you had previously exported the license store after entering the CALS and activating them, you can simply restore that file.
Method 2: If you have the actual CAL codes you can re-enter and activate the CALS.
Method 3: If you have a backup of your system drive you can locate the file licstr.cpa which is located in %systemroot%/system32 folder. Simply replace this file on your affected system with the previously backed up licstr.cpa. (This method was the one that worked in my situation)
Now after you have restored the licstr.cpa file in its original location, be sure to restart the license logging service.
Word of caution for those who have not experience this issue, take a backup of your license store!
Seizing all FSMO roles (FLEXIBLE SINGLE MASTER OPERATIONS) June 13, 2009
Posted by daakeung in Uncategorized.Tags: active directory roles, domain naming master, flexible single master operations, fsmo, infrastructure master, pdc, rid master, seize roles
add a comment
If you need to seize roles from a failed server, you can do so by :
Opening run, type cmd then ntdsutil.
ntdsutil: roles
fsmo maintenance: connections
server connections: connect to dc1.akeung.com
Binding to dc1.akeung.com … Connected to dc1.akeung.com using credentials of locally logged on user.
server connections: q
fsmo maintenance: help
Seize domain naming master - Overwrite domain role on connected server
Seize infrastructure master – Overwrite infrastructure role on connected server
Seize PDC – Overwrite PDC role on connected server
Seize RID master - Overwrite RID role on connected server
Seize schema master – Overwrite schema role on connected server
Select operation target – Select sites, servers, domains, roles and naming contexts
Transfer domain naming master – Make connected server the domain naming master
Transfer infrastructure master – Make connected server the infrastructure master
Transfer PDC - Make connected server the PDC
Transfer RID master – Make connected server the RID master
Transfer schema master - Make connected server the schema master
—————————————————————————————————————————
This is the interesting part, to seize the roles to the connected server, issue the commands as follows:
fsmo maintenance: seize schema master
fsmo maintenance: Seize PDC
fsmo maintenance: Seize RID master
fsmo maintenance: Seize domain naming master
fsmo maintenance: Seize infrastructure master
A prompt will confirm the change you will be making to active directory. Please only use role seizure as a last resort when you cannot “TRANFER” a role.
Cisco OSPF and Windows RRAS OSPF May 24, 2009
Posted by daakeung in Cisco, IT, Microsoft.Tags: cisco and windows ospf neighbours, cisco ios ospf, ISA OSPF, windows rras ospf
1 comment so far
I’ve been battling with getting Windows RRAS ospf and Cisco ios ospf to become neighbours for the past few days.
If you turn on ospf debug in windows and the following shows up :
Rejected an OSPF packet from x.x.x.x to 224.0.0.5 because the OSPF data length in the OSPF header was 48 but the length calculated from the IP Header fields was 60.
You should disable the following on the cisco ios:
router ospf 100
no capability lls
Also, if you are running ISA with RRAS you should disable ”block fragmentation”
For more information:
http://technet.microsoft.com/en-us/library/cc302678.aspx#NetworkAndRoutingIssues
http://www.cisco.com/en/US/docs/ios/12_3/iproute/command/reference/ip2_c1g.html#wp1036468
Using CISCO IOS AUX port to access the console port on another device (reverse telnet) May 16, 2009
Posted by daakeung in Uncategorized.Tags: aux console, Cisco, ios, reverse telnet
1 comment so far
Setup a loopback interface:
int lo 1
ip address 10.1.1.1 255.255.255.255
line aux 0
transport input telnet
speed 9600
To access the aux interface, you telnet to the loopback address on port 2000+line#
for example:
sh line
Tty Typ Tx/Rx A Modem Roty AccO AccI Uses Noise Overruns Int
0 CTY - - - - - 0 0 0/0 -
I 1 TTY – inout - - - 0 0 0/0 -
5 AUX 9600/9600 – inout - - - 0 0 0/0 -
* 6 VTY - - - - - 78 0 0/0 -
7 VTY - - - - - 2 0 0/0 -
8 VTY - - - - - 0 0 0/0 -
9 VTY - - - - - 0 0 0/0 -
10 VTY - - - - - 0 0 0/0 -
telnet 10.1.1.1 2005
***UPDATED***
