For the best web experience, please use IE11+, Chrome, Firefox, or Safari

ApexSQL Manage FAQ

General

Yes, ApexSQL Manage installs CRD (Central repository database), on the SQL Server itself. CRD database is used to store the information needed for communication between the user interface and the agent service, the info about created task schedules, the data about email configuration and data of the last executed health check run for every SQL Server. One central repository database is required for storing all information, i.e. to manage any number of servers

ApexSQL Manage Agent is a background service that provide communication between the application and the Central repository database. This allows the application to execute the scheduled tasks in background, and also to send notification, by email, to the user to notify him when the task was executed and what was its outcome: success or failure

No, SQL manage instance tool is very lite on CPU and RAM resources and running its tasks come at no expense to the performance of a local machine

ApexSQL Manage is a stand-alone application and it cannot be integrated into SQL Server Management Studio or Visual Studio

To kickstart with the tool, please check the ApexSQL Manage Screen shot tour article where all main features are briefly covered

Licensing and evaluation

As part of the ApexSQL DBA suite, ApexSQL Manage is licensed per SQL Server instance. This means that each instance requires a license. For more information on licensing, please check this link

There aren’t any restrictions when evaluating SQL manage instance tool beside time limitation of the evaluation period that is set to 14 days

Yes, if you feel that for any reason, you were unable to properly test and evaluate ApexSQL Manage during the trial period, we will be more than happy to extend it for you

Documentation

Yes, documentation can be customized to the preferred output settings in tool’s main Options window:

customize

ApexSQL Manage can create documentation in the following output formats:

  • CHM (Compiled HTML)
  • Linked HTML
  • DOC (Word document 97 - 2003)
  • DOCX (Word document 2007+)
  • PDF

Output formats

Yes, you can add all registered SQL Server instances, that are previously discovered across the network, in the same output file

Yes, there is an option to document any number of SQL Server instance snapshots under the Documentation tab:

Document

 

Rules

No, health check, or simply put high level, analysis can only be performed on SQL Server instances

Yes, as addition to the pre-defined rules, new custom-made rules can be easily created in a few simple steps

Currently, rules are written in C#, but there is a possibility to write in VB.NET

Fix SQL

No, ApexSQL rule base is having safeguards preventing its rules to have any sort of impact on a database. Nevertheless, the Fix SQL scripts can be used by user to fix some SQL Server and/or database issues discovered as a direct result of high-level analysis

Yes, through the Fix SQL scripts, rules do have an ability to remedy and entirely correct SQL Server health check issues

Server discovery

Yes, in addition to a domain scan, IP range scan is also available:

IP Scan discovery

Yes, ApexSQL Manage is fully capable of discovering SQL Server instances, as well as its services, SSIS, SSAS and SSRS, across the network:

Discover SQL Server

Yes, all previously discovered and registered SQL Server instances can be exported into a list and later easily imported from the same:

Export import list

Comparison

SQL manage instance tool lets you make comparison between SQL Server instances, between snapshots and also allow the comparison between these two, i.e. you can compare SQL Server instance with its, or any other, previously created snapshot

Yes, there is an option in a form of a filters that allows you to exactly choose what to include in the comparison. Those filters are grouped in two categories: Server and Server objects:

Choose settings

Results

Yes, Pass, Issues and Ignored are the filters that allows us to filter the results of the health check analysis shown in the grid:

Filter results

All tasks executed in SQL manage instance tool can be exported into three file formats: DOCX, PDF or XML:

Export results