SQL Server Standard Edition

"Delivers a complete data management and business intelligence platform."

SQL Server 2008 R2 Standard delivers a complete data management and business intelligence platform for departments and small organizations to run their applications, helping enable effective database management with minimal IT resources. The following capabilities are new to Standard:
Backup Compression to reduce data backups by up to 60% and help reduce time spent on backups*
Can be managed instance for application and multi-server management capabilities
High-scale complex event processing with SQL Server StreamInsight
Built on the strong foundation of SQL Server 2008, SQL Server 2008 R2 delivers several breakthrough capabilities that will enable your organization to scale database operations with confidence, improve IT and developer efficiency, and enable highly scalable and well-managed business intelligence on a self-service basis for your users.

Features and benefits of SQL Server 2008 R2:
• Supports data consistency across heterogeneous systems through SQL Server Master Data Services
• Enables high-scale, complex event-stream processing through SQL Server StreamInsight
• Allows administrators to centrally monitor and manage multiple database applications, instances, or servers
• Accelerates the development and deployment of applications and provides improved support for virtualization through Hyper-V with Live Migration in Windows Server 2008 R2
• Empowers business users to build and share powerful business intelligence solutions with little or no IT support, while still enabling IT to monitor and manage user-generated business intelligence solutions
• Expands powerful business intelligence tools to all users with SQL Server PowerPivot for Excel

SYSTEM REQUIREMENTS
SQL Server 2008 R2 is supported in virtual machine environments running on the Hyper-V role in Windows Server 2008 SP2 Standard, Enterprise and Datacenter editions. The virtual machine must run an operating system supported for the specific SQL Server 2008 R2 edition listed later in this topic.
In addition to resources required by the parent partition, each virtual machine (child partition) must be provided with sufficient processor resources, memory, and disk resources for its SQL Server 2008 R2 instance. Requirements are listed later in this topic.3
Within the Hyper-V role on Windows Server 2008 SP2, a maximum of four virtual processors can be allocated to virtual machines running Windows Server 2008 SP2 32-bit or 64-bit editions. A maximum of 2 virtual processors can be allocated to virtual computers that are running Windows Server 2003 32-bit editions. For virtual computers that host other operating systems, a maximum of one virtual processor can be allocated to virtual computers.