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