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
2 comments
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 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.

