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
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

#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

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
: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

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

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>