Microsoft SQL Server on VMware vSphere Availability and Recovery Options

VMware
Running Microsoft SQL Server on VMware vSphere offers many options for database availability and disaster recovery utilizing the best features from both VMware and Microsoft. For example, VMware vSphere vMotion and VMware vSphere Distributed Resource Scheduler (DRS) can help to reduce planned downtime and balance workloads dynamically, and VMware vSphere High Availability (HA) can help to recover SQL Server databases in the case of host failure. At the application level, all SQL Server features and techniques are supported on vSphere, including AlwaysOn Availability Groups, AlwaysOn Failover Cluster Instances, database mirroring, and log shipping. SQL Server availability features can be used inside of a virtual machine just as you would on a physical server, and combined with vSphere features to support flexible availability and recovery scenarios, applying the most efficient and appropriate tools for different use cases.   AlwaysOn is a…
Read More

SQL Server Performance

Microsoft
It is pretty important to make sure you set the Max Server memory setting for SQL Server 2005/2008 to something besides the default setting (which allows SQL Server to use as much memory as it wants, subject to signals from the operating system that it is under memory pressure). This is especially important with larger, busier systems that may be under memory pressure. This setting controls how much memory can be used by the SQL Server Buffer Pool.  If you don’t set an upper limit for this value, other parts of SQL Server, and the operating system can be starved for memory, which can cause instability and performance problems. It is even more important to set this correctly if you have “Lock Pages in Memory” enabled for the SQL Server…
Read More

Supported Databases for Citrix Products

Citrix
Citrix supplies best efforts to ensure compatibility with upcoming database releases. New versions of supported databases (SQL, Oracle, or DB2) released after our products have been released, must work. However, Citrix recommends creating a test environment to ensure there are no unforeseen issues related to changes made to the new version or update of the third-party product.  Individuals wishing to use the new release with current Citrix products must perform their own testing before using the platform. Citrix does not support any BETA versions of third-party products. You can find the database chart HERE this document will be updated periodically as new information becomes available.
Read More