How we tested Microsoft SQL Server 2012
- 16 July, 2012 04:40
Virtually all our testing took place across 512Kbps frame relay, T-1 and T-3 WAN links. The test bed network consisted of six Fast Ethernet subnet domains linked by Cisco routers. Our lab's 50 clients consisted of computing platforms that included Windows 2000/2003/XP/Vista/Win7, Macintosh 10.x and Red Hat Linux (both server and workstation editions).
The network contained two Web servers (Microsoft IIS and Apache), three e-mail servers (Exchange, Notes and Sendmail) and several file servers (Windows 2003 and Windows 2008).
Our virtual computing environments consisted of VMware, XenServer and Microsoft Hyper-V.
A Compaq ProLiant ML570 computer, with four 900-MHz CPUs, 4GB RAM and 1.3 terabytes of disk storage, running Windows 2008 Server was our test platform for SQL Server 2012. A Dell PowerEdge server simulated our remote backup site for disaster recovery.
We exercised most of SQL Server 2012s new features, focusing primarily on Business Intelligence, AlwaysOn, Contained Databases and ColumnStore Index.
Read more about software in Network World's Software section.