Network Computing is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them. Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

Sneak Preview: Quest's Central 5.5: Page 4 of 6

But SQL Scanner, which the company gained as part of a recent acquisition, is not integrated into Quest Central, and its user interface seemed less intuitive than other parts of the product. After you select the objects to search, for example, they move into a Job Manager. From there, you must again select which of these statements should be scanned. Quest says it plans to integrate this piece more fully in future versions.

The Snapshots feature in the Database Analysis tool is more robust in this version, according to Quest. You can take snapshots of your database server and then run an analysis on those snapshots, and Quest says snapshots continue even if its underlying collection fails.

I ran a snapshot on SQL Server and Oracle servers that contained several databases and then performed the analysis, which runs predefined checks in areas such as performance and best practices.

The action plan items returned included information such as where wide-clustered indexes existed, a notice that there was no password for the system administrator account, and reports on several other standard database best practices that were not being followed. For each check there is a recommended action along with background information. It ranks each item as a low-, medium- or high-priority effort, as determined by the software.

Performance Checks