Virtualizing Microsoft SQL Server on VMware

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

Best Practice for SQL 2008 High Availability

Virtualisierung von Unternehmensanwendungen: SQL Server

Best Practices and Considerations for Virtualizing Microsoft SQL Server on VMware

Performance Characterization of VMFS and RDM Using a SAN

Performance and Scalability of Microsoft SQL Server on VMware vSphere 4

MS SQL Server Best Practices (not really VMWare related, but worth reading)

How to start a local moinmoin on Windows XP


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\ ändern
Kommentar entfernen
page_front_page = u’FrontPage’ # change to some better value


Rsync Backup vom Mac zum Linux Server

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

@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
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
echo “Philips USB Stick nicht gefunden in LAufwerk E:”
goto ende

echo Fertig

VMWare Performance Analysis – collection of links

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

Interpreting esxtop Statistics

Using esxtop to TroubleshootPerformance Problems

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.

Performance Monitoring and Analysis

Troubleshooting Performance Related Problems in vSphere 4.1 Environments

no-ip – self made script

Sometimes my DSL Modem (that has a build in dyndns Client) hangs, and it stops updating
the 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/;/dev/null 2&gt;&amp;1

on your local linux server:

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 ];
echo `date +%d.%m.%y-%R` “ip unchanged”
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