Virtualizing Microsoft SQL Server on VMware

Posted on by
Reply

i stumbled over my notes file from 2010, when i started to have a closer look at VMWare Server Performance.

Here are the links:

Best Practices for SQL Server
http://communities.vmware.com/docs/DOC-8964

Best Practice for SQL 2008 High Availability
http://communities.vmware.com/thread/251791

Virtualisierung von Unternehmensanwendungen: SQL Server
http://www.vmware.com/de/technical-resources/enterprise-applications/sql-server.html

Best Practices and Considerations for Virtualizing Microsoft SQL Server on VMware
http://matthensley.wordpress.com/2010/05/16/best-practices-and-considerations-for-virtualizing-microsoft-sql-server-on-vmware/

Performance Characterization of VMFS and RDM Using a SAN
http://www.vmware.com/files/pdf/performance_char_vmfs_rdm.pdf

Performance and Scalability of Microsoft SQL Server on VMware vSphere 4
http://www.vmware.com/files/pdf/perf_vsphere_sql_scalability.pdf

MS SQL Server Best Practices (not really VMWare related, but worth reading)
http://technet.microsoft.com/en-us/sqlserver/bb671430.aspx

How to start a local moinmoin on Windows XP

Posted on by
Reply

#moinmoin
http://moinmo.in/DesktopEdition/HowToConfigure

C:\_Daten\Wiki\wiki\config -> hier liegt die Wiki Config Datei
http://localhost:8080/LanguageSetup?action=language_setup laufen lassen und danach

C:\_Daten\Wiki\wikiconfig.py ändern
Kommentar entfernen
page_front_page = u’FrontPage’ # change to some better value

C:\Python27\python.exe wikiserver.py
http://localhost:8080

Rsync Backup vom Mac zum Linux Server

Posted on by
Reply

Mounten des Linux Shares

Nicht vergessen, vorher ~/mnt/tux/joerg Verzeichnis anzulegen

mount -t smbfs //joerg@tux/joerg ~/mnt/tux/joerg

Danach mit Rsync kopieren

sync -rca -verbose -h ~/Pictures/ ~/mnt/tux/joerg/Backups/macbook/Pictures/

Wenn alles geklappt hat, noch den –delete  Befehl hinzufügen. Dieser löscht Dateien im Ziel, die es in der Quelle nicht mehr gibt.

verschlüsseltes Backup unter Windows mit 7zip

Posted on by
Reply

@echo off
break on
echo “Backup der Dateien auf USB Stick ?

set YYYY=%date:~-4%
set DD=%date:~-10,2%
set MM=%date:~-7,2%

echo %YYYY%%MM%%DD%

if exist E:\Backups\EC074284\pwhint.txt goto weiter
goto usbmissing
:weiter
set DESTINATION=E:\Backups\EC074284

“C:\Program Files\7-Zip\7z.exe” a -r %DESTINATION%\u-%YYYY%%MM%%DD%.7z u:\*.* -pMEINPASSWORT
“C:\Program Files\7-Zip\7z.exe” a -r %DESTINATION%\notes-%YYYY%%MM%%DD%.7z C:\_Daten\Notes\*.* -pMEINPASSWORT

goto ende
:usbmissing
echo “Philips USB Stick nicht gefunden in LAufwerk E:”
goto ende

:ende
echo Fertig
pause

VMWare Performance Analysis – collection of links

Posted on by
Reply

Here is the link collection, that i used to get more knowledge.

Interpreting esxtop Statistics

http://communities.vmware.com/docs/DOC-9279

Using esxtop to TroubleshootPerformance Problems

http://www.vmware.com/pdf/esx2_using_esxtop.pdf

Using the esxtop tool to identify VMware ESX memory use

http://searchvmware.techtarget.com/tip/Using-the-esxtop-tool-to-identify-VMware-ESX-memory-use

esxtop command showing high %RDY values for Virtual Machines running on NUMA enabled ESX hosts.

http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1026063

Performance Monitoring and Analysis

http://communities.vmware.com/docs/DOC-3930

Troubleshooting Performance Related Problems in vSphere 4.1 Environments

http://communities.vmware.com/docs/DOC-14905

no-ip – self made script

Posted on by
Reply

Sometimes my DSL Modem (that has a build in dyndns Client) hangs, and it stops updating
the no-ip.org Server.

I have some notes on my Atom based Linux Server at home and it bugs me if i can’t connect via
ssh from the office.

I wrote a script to mail me the new public ip address as soon as it is changing.
If you have a linux pc/server at home you can do the following by yourself:

put the following php script to your webserver – give it a fancy name like “myip.php”
<blockquote>&lt;? echo $_SERVER[‘REMOTE_ADDR’] ?&gt;</blockquote>
Start the following  script
<blockquote>crontab -l

# m h  dom mon dow   command
0   *   *   *  *    ~/bin/update_ip/update_ip.sh&gt;/dev/null 2&gt;&amp;1

&nbsp;</blockquote>
on your local linux server:
<blockquote>#!/bin/bash

cd ~/bin/update_ip

LAST_IP=`cat .last_ip`
IP=`curl -s -o – http://mywebserver/myip.php`
echo “last IP : $LAST_IP – new IP: $IP”
if [ $LAST_IP = $IP ];
then
echo `date +%d.%m.%y-%R` “ip unchanged”
else
echo “new ip: $IP”
cat .last_ip | mailx -s “New-IP $IP” MAILADR
echo “$IP” &gt; .last_ip
echo `date +%d.%m.%y-%R` “new IP :$IP” &gt;&gt;ip.log
fi

&nbsp;</blockquote>