System requirements
Minimum RAM |
1000 MB |
Minimum processor |
AMD 64, Intel (EM64T), 1.4 GHz |
Technical details
Platform |
Web Server |
Mac compatibility |
N |
Software version |
2008 R2 |
SQL Server Web 2008 R2, Single, Open License Program-No Level, 1CPU
Cost Effective, Scalable Data Platform for Websites and Web Application Solutions
Microsoft SQL Server 2008 Web Edition delivers an optimal balance of scalability, manageability, and cost for hosted Web sites and applications.
Top Features:
- Low Total Cost of Ownership (TCO);
- Effective monitoring and management of web customers;
- Maximum server utilization for low-cost operations;
- Flexible platform options for developers;
- Consistently increasing scale-out needs
- Efficient management of large groups of servers.
High Availability and Scalability for Web Solutions:
Availability
- Log shipping helps automatically back up data on separate servers or keep multiple read servers online to better handle large amounts of web traffic;
- Utilize this low-cost edition with SQL Server 2008 Enterprise instances through one-way merge and transactional replication to keep multiple nodes in sync.
Scalability
- Helps support for multi-tenancy and customers with growing data needs through unlimited memory and database size;
- Maximize utilization of resources with support for up to 4 CPUs.
Low Total Cost Of Ownership (TCO):
Automate tasks and policies
- Help ensure standards and compliance across your environment with Policy-Based Management;
- Use SQL Agent to reduce the amount of time spent on administrative tasks by scheduling and executing events like server backups.
Streamlined Administration
- Use service broker to distribute applications across your servers for easier scale out;
- Automate server administration and application development more easily through Windows PowerShell.
Built-in Business Intelligence
- Use service broker to distribute applications across your servers for easier scale out;
- SQL Server 2008 Reporting Services with unique layout and new visualization to enhancements further enrich the reports and gain insights.
Developer Productivity:
Improved Productivity
- Use .NET integration support to quickly write, extend, and publish programs for the web;
- Create desktop applications that can automatically synchronize with a central database.
FTS (full text search) offers fast and flexible indexing for keyword-based query of text stored in SQL Server.
- Database publishing tools help seamlessly move files from the desktop to the web.
Advanced Programmability
- Meet a variety of customer needs with advanced data type support;
- With LINQ (Language Integrated Queries), use native syntax language with data-driven apps for queries.
Platform Flexibility
- Increase service offerings by supporting applications in PHP, ASP, and on Windows;
- Use ADO.NET Data Services support to expose data through web services using existing tools and processes.