Product Reviews

NetIQ SQL Management Suite

A solid overall resource and event management solution for multiple SQL Servers.

I mentioned NetIQ's new SQL Management Suite of integrated SQL Server management products last issue. This time around, I got the chance to give it a spin. Here are some impressions of the new pieces here (I didn't spend much time with AppManager, the original application on which the suite is built this time around; it remains a solid overall resource and event management solution for multiple SQL Servers.

Recovery Manager I just gave a quick spin. That's because this piece is functionally identical to Lumigent's Log Explorer - NetIQ licensed it as an OEM product. As with the original, this is a superb tool for looking at exactly what's happened in your database by translating SQL Server logs into something that a human being can use. In many circumstances, Recovery Manager lets you pinpoint transactions to roll back (it has some limitations in that SQL Server doesn't log everything) without undoing other transactions or restoring a backup. Of course, you'd better know what you're doing; mucking about with transactions on a granular level can leave you in a worse situation than when you started.

Configuration Manager for SQL Server is the automated change detection part of the suite. This is implemented as an interesting mix of MMC application and Web pages; you drill into a tree with MMC until you find what you want to look at, then open a Web page to see the details. Configuration Manager can give you lots of details about your server, both in the SQL Server configuration and in the overall machine configuration. It's easy to set up a baseline and see changes, and easy to compare servers with one another. Definitely worthwhile if you have many servers that you want to make sensibly identical.

I've saved the best for last. Diagnostic Manager makes monitoring multiple servers for trouble practically a video game. About ten seconds after installing it I had little mini-monitors on screen telling me what was up with five of my SQL Servers. Clicking around drilled into details of server, database, and beyond, and a bunch of performance graphs made it easy to see where the hot spots were. Best of all, Diagnostic Manager is fast and it doesn't require installing any agents, working just by SQL queries. Just don't tell your boss how amusing the 3D graphs are and maybe he'll still let you buy it.

A word about the "suite" aspect of SQL Management Suite: in this version, it's still clearly four disparate products bundled together, not a truly integrated suite. There are connections between the applications (particularly between Configuration Manager and AppManager) but the look and feel of them is all different. That doesn't make these less useful tools; it just makes me hope they're all getting a facelift and tighter integration in the next version.

About the Author

Mike Gunderloy, MCSE, MCSD, MCDBA, is a former MCP columnist and the author of numerous development books.

Featured

  • Microsoft Warns IT Pros on Windows Netlogon Fix Coming Next Month

    Microsoft on Thursday issued a reminder to organizations to ensure that their systems are properly patched for a "Critical"-rated Windows Netlogon vulnerability before next month's "update Tuesday" patch distribution arrives.

  • Microsoft Nudging Skype for Business Users to Teams

    Microsoft on Thursday announced some perks and prods for Skype for Business unified communications users, with the aim of moving them to the Microsoft Teams collaboration service instead.

  • How To Improve Windows 10's Sound and Video Quality

    Windows 10 comes with built-in tools that can help users get the most out of their sound and video hardware.

  • Microsoft Offers More 'Solorigate' Advice Using Microsoft 365 Defender Tools

    Microsoft issued yet another article with advice on how to use its Microsoft 365 Defender suite of tools to protect against "Solorigate" advanced persistent threat types of attacks in a Thursday announcement.

comments powered by Disqus