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

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