The SQL Safe Agents tab allows you view all servers that host instances in your environment.

For each server you can see the following information:

  • Status - it displays the status of the SQL Safe Backup Agent which could be:
    • Ok (green) - the SQL Safe Backup Agent is available and configured correctly.
    • Warning (yellow) - SQL Safe connected to the SQL Safe Backup Agent but the Backup Agent is not the most current version or is not configured for the same management service.
    • Error (orange) - SQL Safe cannot connect to the Backup Agent on the server.
  • Computer name - the name of the computer where the SQL Safe Backup Agent is running.
  • Version - the version of the SQL Safe Backup Agent.
  • Management Server - the name of the management server that the SQL Safe Backup Agent is configured for.
  • Max Load - the maximum number of concurrent operations that can be executed by the SQL Safe Backup Agent.
  • Priority - displays the Windows thread priority at which the Backup Agent threads run.
  • Send Status - displays the frequency with which the agent is configured to communicate with the Management Server.
  • SQL Timeout - displays the SQL DMO timeout value, which determines how long the Backup Agent will wait for a response from SQL Server before timing out.
  • VDI Trans Limit, bytes - displays the maximum size of a transfer block for the VDI operation.
  • VDI Buffers, bytes - displays the number of buffers used for the VDI operation.
  • VDI Block Size, bytes - displays the size of a VDI device block. All data transfers are integer multiples of this value.
  • VDI Timeout, seconds - displays the timeout for configuring the VDI.
  • Actions - allows to access the options for editing server properties, installing/upgrading SQL Safe Backup Agent, and Enabling/Disabling Instant Restore. 

Keep in mind:

  • You can sort the information available on this tab by clicking the column header by which you want to order your instances.
  • You can set the number of items you want to view per page by going to the lower section of the list grid, type a number in the box, and the page will be updated according to your requirements.

How can you filter your information?

You can filter the information of the SQL Safe Agents tab to access your data quickly.

Filter your information by:

  • Status - it displays the status of the SQL Safe Backup Agent which could be:
    •  Ok - the SQL Safe Backup Agent is available and configured correctly.
    •  Warning - SQL Safe connected to the SQL Safe Backup Agent but the Backup Agent is not the most current version or is not configured for the same management service.
    •  Error - SQL Safe cannot connect to the Backup Agent on the server.
  • Computer Name - type the computer name.
  • Version - type the Backup Agent version.
  • Management Server - type the Management Server configured for the Backup Agent.
  • Max Load - set a range using the From and To options. 
  • Priority - type the priority.
  • Send Status - select from the On and Off options.
  • VDI Trans Limit, bytes - set a range using the From and To options. 
  • VDI Buffers, bytes - set a range using the From and To options. 
  • VDI Blocksize, bytes - set a range using the From and To options. 
  • VDI Timeout, seconds - set a range using the From and To options. 

When using filters take into account:

  • You can save your filtering options by selecting your filters, typing a name in the By Custom Filter field, and clicking Add Filter. To retrieve your saved filters, click the drop-down option in the By Custom Filter section and select your filter name.
  • If you want to select filters first and apply the changes later, deselect the Apply filter as it changes option.
  • To remove filters, use the specific Remove Filter option in each filter. For example, if you want to remove your Status filters, click Remove Status Filter under the same filter section.
  • Under APPLIED FILTERS on the top section or your SQL Safe Agents tab, you can see the filters you have selected. Click the X icon next to the ones you want to remove.
  • Use the option Clear on the top section of the Filtering section to remove all filters. 

What other options are available on the  SQL Safe Agents tab?

You can also find the following options in the upper section of the SQL Safe Agents tab:

  • Export - use this option to export the information displayed on the SQL Safe Agents tab. You can select your preferred format: PDF, XLS, or XLM. 
  • Refresh  - use this option to get the latest status of your SQL Safe Agents.

What options can you edit in the properties window?

Click the  gear icon at the end of the row and select properties. On the Agent Properties window, you can edit the following settings:

  • On the General tab, you can edit by:
    • Status 
      • Management Server - the name of the server hosting the SQL Safe Management Service that the Agent is configured to communicate with.
      • Send Status every X seconds - select this option to have the SQL Safe Backup Agent communicate with the SQL Safe Management Service. Also, define the frequency of the communicate.
    • Performance
      • Max Load - the maximum number of concurrent operations that the backup agent can perform.
      • Priority - use this option to define the thread priority at which backup agent threads run.
    • Troubleshooting
      • Enable Debug Mode - select this option to enable debug logging on the Agent.
      • The Advanced button provides access to define the following options: More detailed messages, Backup Service Engine, Backup Service I/O, Map Generation, Filter Service Engine, and Filter Service Driver. Additionally, you can set Log Files options and define if you want to roll logs.
  • On the SQL Server tab, you can edit by:
    • SQL Server Connectivity
      • Timeout - set the timeout in seconds.
    • Virtual Device Interface (VDI) Defaults
      • Timeout - set the timeout in seconds, which determines how long the Backup Agent will wait for a response from SQL Server before timing out.
      • Buffers - define the number of buffers used for the VDI operation.
      • Transfer Limit - set the maximum size of a transfer block for the VDI operation.
      • Block Size - set the size of a VDI device block. All data transfers are integer multiples of this value.
  • On the SQL Virtual Database tab, you can edit by:
    • Default Database File Location - use this option to specify which folder SQL VDB uses to stores data files when creating a virtual database. Click Browse to change the Database File location.
    • Cleanup Unused Files - use this option to remove the temporary files used for a VDB that are left behind after the database is deleted. Click Clean Up to remove these files and free up space.

When you finish configuring your Agent Properties, click Save or Cancel the configuration.



IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal
  • No labels