NetIQ Eases Management Of SQL Server

By Lisa Vaas  |  Posted 2003-02-24 Print this article Print

Company updates three core apps in SQL Management Suite 2.

NetIQ Corp. aims to make defragmenting tables in and general management of Microsoft Corp.s SQL Server database easier with an update to its SQL Management Suite of tools.

SQL Management Suite 2, which NetIQ will release this week, includes updates of three of its core applications: DiagnosticManager, ConfigurationManager and RecoveryManager. A fourth application, AppManager, was not upgraded.

The update overhauls DiagnosticManagers user interface, adding a to-do list that provides quick access to diagnostic data. With the update, database administrators can double-click on a diagnostics screen that displays tables suffering from reorganization problems, according to NetIQ officials, in Houston. The tool indicates how badly a table needs defragging and enables DBAs to defrag it immediately with a single click.

Tom Thurston, database administration manager for American Fidelity Assurance Co., a group insurance provider in Oklahoma City, has been using an earlier version of SQL Management Suite for about seven months. Thurston said the ability to defrag with a single click will save lots of time.

"[Previously,] it would have been a manual process to write queries and find out what data was there," Thurston said. "Its the difference between pointing and clicking [versus] having to go out and research for a few days about how to find this information, then hitting each ... table and window and finding how bad the [need to] defrag is."

The DiagnosticManager update also adds a "Today" screen that lists the days priorities and a feature called DBACollaboration, which lets DBAs cover for one another by enabling them to view data available in local copies of DiagnosticManager. NetIQ officials said this will come in handy for customers that assign DBAs to certain sets of servers, such as those that run a Web site or those that power a customer relationship management application.

In response to customer requests, NetIQ has taken historical information available in DiagnosticManager and broken it down into 10-minute increments, as opposed to its original 1-hour buckets.

The enhanced ConfigurationManager doubles the number of configuration data points to about 400—including, for example, machine memory statistics or which processors in a multiprocessor server SQL Server is allowed to use. The tool includes new reports that address server properties, replication settings and database security.

RecoveryManager now launches in context, enabling DBAs to call on the tool from within DiagnosticManager in their efforts to back users out of data changes. AppManager provides automatic management of distributed SQL Server instances from a central console. ´

DiagnosticManager: To-do list gives one-click access to diagnostic data

ConfigurationManager: New reports address server properties, replication settings and database security

RecoveryManager: Upgrade provides faster routine monitoring

AppManager: Central console enables automatic management of distributed SQL Server instances

Lisa Vaas is News Editor/Operations for and also serves as editor of the Database topic center. Since 1995, she has also been a Webcast news show anchorperson and a reporter covering the IT industry. She has focused on customer relationship management technology, IT salaries and careers, effects of the H1-B visa on the technology workforce, wireless technology, security, and, most recently, databases and the technologies that touch upon them. Her articles have appeared in eWEEK's print edition, on, and in the startup IT magazine PC Connection. Prior to becoming a journalist, Vaas experienced an array of eye-opening careers, including driving a cab in Boston, photographing cranky babies in shopping malls, selling cameras, typography and computer training. She stopped a hair short of finishing an M.A. in English at the University of Massachusetts in Boston. She earned a B.S. in Communications from Emerson College. She runs two open-mic reading series in Boston and currently keeps bees in her home in Mashpee, Mass.

Submit a Comment

Loading Comments...
Manage your Newsletters: Login   Register My Newsletters

Rocket Fuel