What’s new in ApexSQL DBA: ApexSQL Discover – SQL Server instance search and inventory

We are proud to announce yet another application from ApexSQL DBA family, ApexSQL Discover. ApexSQL Discover is the SQL Server discovery and basic health monitoring tool. The application scans all available SQL Server instances based on the pre-set criteria and keeps track of basic health parameters and statistics for all registered SQL instances. The application will be offered free of charge.

Primary features of the application will include:

SQL Server discovery

ApexSQL Discover detects and keeps track of SQL Server instances as well as SSRS, SSIS and SSAS services located in a specific domain or IP range. The information on all discovered servers is displayed in the Home tab of the application. The columns in the main grid will contain following details:

Server

Name of the SQL Server instance, or SSAS, SSRS or SSIS service

Type

Type of the SQL service

Computer

Name of the computer where SQL Server instance is located

IP and Port

IP adress of an instance and its access port

Version

SQL Server instance or service version

Version number

Exact number of the service version

Latest update

Links the latest update avaiable for the service

FQDN

Fully qualified domain name

Status

Indicates if service is online or offline

Find method

Displays the method that was used to discover the instance

To allow an easier search, the Find panel is also available. The grid will contain information on the server instances and services that were added through the Scan wizard. The wizard is initiated by clicking on Scan button. Scan wizard is used to define scan parameters for the search. First group of options sets the domain search. Domain name, as well as user credentials for accessing servers in the domain can be specified.

Second group of options is used to speciffy IP and port range scan. Methods option group allows the method selection for the search.

Clicking on Scan button starts the search. Discovered servers are presented in scan results grid. To add discovered servers on the list in the Home tab, it is necessary to register these servers first by checking them in the grid, and provide login credentials for each server.

The options to log in automatically are also available on the form:

  • It is possible to use the Windows credentials of the current user that is running the application.
  • If the discovered server had already been registered in the past, the application may attempt to use SQL Server credentials that were used earlier.
  • If both automatic attempts fail, the credentials can be provided manually through standard ApexSQL connection form

Information on all registered servers will be available in Home tab.

Schedules tab keeps track of all scheduled scan jobs. New scan jobs can be added through the ribon, while those that are already listed can be run, edited, deleted, enabled and disabled.

Statistics tab keeps track on basic information for CPU utilization, RAM memory and disk space usage.

Configuration tab contains all necessary application options, while Resources tab contains standardized forms for registration, application version , as well as link to company’s resources.

 

May 3, 2018