HP ProLiant DL585 Server
The gold winner in the Hardware category is the HP ProLiant DL585 server,a 4U rack-mounted server equipped with four dualcore AMD Opteron 880 processors.The ProLiant DL585 is one of the fastest systems we'd ever tested in our labs; the four Opteron dualcore processors ran at 2.4GHz. In its maximum configuration, the system supports 128GB of RAM.The ProLiant DL585 also offers a battery-backed, embedded Ultra3 Smart Array 5i.The server has two 64-bit 133MHz PCI-X slots, six 64-bit 100MHz PCI-X slots, a 1GB dual-port NIC, two USB 2.0 ports, an optical drive, one serial port, an Integrated Lights Out (iLO) management port, and hot-plug redundant power supplies.The ProLiant DL585 is bundled with HP's Systems Insight Manager and the iLO technology. Insight Manager lets you perform remote systems management directly over the network through a browser interface or interactively through the Insight Manager console. Insight Manager provides system monitoring, the ability to send alerts, and asset management. The iLO feature enables remote management through virtual KVM over IP. Contact HP at 800-752-0900 or http://welcome.hp.com/country/us/en/prodserv/servers.html.

See Associated Figure

High Availability
Neverfail for SQL Server
In his review of The Neverfail Group's Neverfail for SQL Server (April 2006, InstantDoc ID 49362), Michael Otey reported that this platinum winner provides the high availability that businesses are demanding. Neverfail provides server-level and site-level protection for SQL Server, as well as automatic failover capability. The product monitors your SQL Server application and looks for changes, including new database creation or data changes, and makes the appropriate updates for its replication set. In addition to monitoring your SQL Server application, Neverfail monitors your entire SQL Server environment, including your OS and network infrastructure.And Neverfail takes preemptive actions to correct problems without resorting to a full system failover. The solution runs on Windows Server 2003 Standard and Enterprise Editions and Windows 2000 Server SP4, and it supports SQL Server 2000 SP3a and later. Contact Neverfail at 512-327-5777 or http://www.neverfailgroup.com.

Stratus Technologies Active Upgrade
Stratus Technologies' gold-award winning software,Active Upgrade, works with the company's fault-tolerant ftServer W Series 4000 servers for Windows Server 2003 environments. Active Upgrade lets customers perform online software upgrades and critical OS hot fixes without having to take the server or application offline.The Active Upgrade process splits one logical server into two independently running physical servers. While one physical server runs the application, the other is updated with new software.The two sides then remerge, resynchronize, and return to fault-tolerant, lock-step operation. The Active Upgrade process reduces the planned server downtime that IT departments need to install upgrades and enhancements to OSs, service packs, applications, and system software. Active Upgrade software makes the updating process much less disruptive to business continuity.

Migration
ATERAS DB-Shuttle .NET
The platinum Migration tools winner is DB-Shuttle .NET from ATERAS (formerly Sophisticated Business Systems). DB-Shuttle .NET analyzes the mainframe environment and its applications; automates the conversion of databases, applications, and languages; and assures the integrity and completeness of the converted data. The product can then tune the new environment for optimal performance. Older applications are converted to new languages such as MicrosoftVB.NET 2005 and C# 2005.When a migration to the .NET Framework is complete, the client has the functional equivalent of the legacy application. Contact ATERAS at 800-801-9005, 972-664-9005, or http://www.ateras.com.

See Associated Figure

AdventNet SwisSQL Database Stored Procedure Migration Tools
Gold winner AdventNet SwisSQL is an automated database migration solution that offers migration of both schema and data across SQL Server, Oracle, IBM DB2, MySQL, and other databases.The tools support migration of complex proprietary stored procedures, SQL dialects, database schema,and enterprise data between database platforms.The Database Stored Procedure Migration Tool automates migration of stored procedures, tables, views, indexes, and SQL statements across all supported platforms. Oracle to SQL Server Online Migration offers accurate, automated conversion of Oracle PL/SQL to SQL Server T-SQL syntaxes without requiring you to install software binaries.And you can verify the integrity of the data and the database objects you migrate for SQL Server to Oracle migrations by using AdventNet's Database MigrationVerifier tool. Contact AdventNet at 925-924-9500 or http://www.swissql.com.

Performance and Monitoring
Idera SQL Diagnostic Manager
The platinum winner of the Editors' Choice award in the Performance and Monitoring category is Idera SQL diagnostic manager, software that's designed to ease SQL Server performance-problem diagnosis and correction. SQL diagnostic manager lets you view information for one server or multiple SQL Server systems.The product uses a dashboard-style interface to display real-time SQL Server performance information that helps you quickly access crucial database information and resolve problems. SQL diagnostic manager collects and displays real-time activity and performance information for processes, caches, alerts, memory, transactions, logs, locks, replication, reorganization status, and trace data.To access underlying system activity, you can drill down from the displayed charts. In addition, SQL diagnostic manager provides a collection of built-in database-health information that helps both experienced and novice DBAs understand and solve database-server performance problems.And the product features built-in tasks, including starting and stopping a SQL Server Agent job, stopping a blocking process, terminating a user connection, rebuilding indexes on a table, and updating statistics. Contact Idera at 877-464-3372, 713-523-4433, or http://www.idera.com.

See Associated Figure

Quest Coefficient for SQL Server
The gold winner in the Performance and Monitoring category is Quest Coefficient for SQL Server, software that provides SQL statement profiling and database analysis for SQL Server 2005, 2000, and 7.0. Coefficient is designed for use in all aspects of the softwaredevelopment life cycle from development to quality assurance and production troubleshooting. The product identifies database performance problems and generates statistical reports for all stored procedure calls and SQL statements executed against the database.The database activity that Coefficient monitors includes call frequency, CPU usage, duration, reads, writes, best-and worst-case executions, top and worst individual calls, and table and index scan analysis.The product also tracks stored procedure recompilation and caching, missing column statistics, deadlocks, timeouts and attentions, and errors and exceptions. Coefficient requires no server components; instead, it runs on a client system that's connected to the SQL Server database server. The reports the product generates can be output to a network share or Web server for internal distribution. Contact Quest at 949-754-8000 or http://www.quest.com/coefficient.

Prev. page     1 2 3 [4] 5     next page



You must log on before posting a comment.

If you don't have a username & password, please register now.

Reader Comments

Tableau's web address is wrong (extra space in the middle)

maldrich

Article Rating 5 out of 5

The review above says that Quest Coefficient supports SQL Server 2005. It does NOT support SQL Server 2005.

I don't see how it could be rated as a "gold winner" when it doesn't support the most recent SQL Server version (which had been available for almost a year before this article was written).

kgottfredsen

Article Rating 3 out of 5

Hi kgottfredsen, You're right, Quest Coefficient for SQL Server doesn't support SQL Server 2005. We apologize for this error, it was inadvertent. Because the award was given in 2006, the fact that Quest Coefficient doesn't support SQL Server 2005 doesn't affect the validity of the award. At the time, most DBAs were still using earlier versions of SQL Server. Thanks for pointing out this error. Feel free to contact me if you have any questions.

Megan Bearly Associate Editor, SQL Server Magazine mbearly@sqlmag.com

meganbearly

Article Rating 5 out of 5