Performance Monitoring


Optimize SQL Server Performance


SQL Sentry has announced the availability of its new performance monitoring and optimization tool, SQL Sentry Performance Advisor. Performance Advisor features include a performance dashboard, real-time and historical analysis of performance metrics, graphical monitoring of disk activity, blocking and deadlock analysis, and automated tracing. According to the company, these features “simplify the process of optimizing SQL Server performance.” Licenses are available for $1,495 per SQL Server instance plus an annual maintenance fee of $299. For more information, contact SQL Sentry at sales@sqlsentry.net or go to www.sqlsentry.net.

See associated figure

Database Profiling


Cost-Effective Database Profiling


AMB Dataminers has announced AMB-InfoPublish, with support for IBM DataStage/Information Server extraction, transformation, and loading (ETL) tools. The company says that AMB-InfoPublish provides a cost-effective way for administrators to profile entire SQL Server databases. The product also profiles Oracle, Teradata, flat-file, and DB2 (UDB, DB/400, zOS) databases. AMB-InfoPublish support integrates with Microsoft SQL Server Integration Services (SSIS) and IBM DataStage. According to Steven Meister, president of AMB, “AMB-InfoPublish profiling … allows users to independently profile new sources of information and drop it into DataStage projects when needed. ETL developers will have profiling information right in each stage.” For more information, contact AMB at 800-928-0365 or visit www.payasyougodataquality.com.

Database Security
Patch Databases Rapidly


Hedgehog vPatch, Sentrigo’s new virtual patching software, protects databases against vulnerabilities as soon as they’re discovered. Hedgehog vPatch fortifies corporate databases against recently discovered security problems without incurring database downtime or affecting related applications. Sentrigo typically patches newly discovered vulnerabilities within days and automatically delivers updates to Hedgehog vPatch. Companies can configure Hedgehog vPatch to prevent intrusions by terminating or quarantining sessions or to generate alerts. The product currently supports Oracle and Microsoft databases. Pricing begins at $750 per CPU for an annual subscription. For more information, contact Sentrigo at 781-935- 2879 or visit www.sentrigo.com.

See associated figure

Change Monitoring and Capacity Planning
Manage Growth and Change in Your SQL Server Environment


Quest Software has released the latest version of two of its SQL Server management products, Capacity Manager for SQL Server 2.5 and Change Director for SQL Server 2.0. Capacity Manager helps you manage the growth of your SQL Server environment by providing capacity planning for all your SQL Server databases and related applications, such as SharePoint. Capacity Manager also includes intelligent index maintenance and partition management. With Change Director, you can automate the deployment and migration of database schema changes. In addition, Change Director now offers middle-tier processing, which lets you offload schema comparisons, script generation, and job scheduling to a persistent processing tier for better performance. For more information, contact Quest Software at 800-306-9329 or visit www.quest.com.