How to Check Database Health Maintenance System in SwilERP Pharmacy Software

Database Health Maintenance System

Database Health Maintenance System in SwilERP


What is a Database Health Maintenance System?

Database Health option is generally used when users face speed issues in the software. So with the help of this option, the user can reset the software configuration for a smooth run. Data is a significant asset of any organization. Most industries rely on data, especially pharmacy. Achieving the most incredible efficiency and error-free management is essential for these marketplaces. Thus, data scrubbing and data cleaning become necessary. It helps to free up the contiguous data blocks and make spaces for newly created files.

This feature enables you to free up space that is unnecessarily occupied by files already deleted from the system. With just a tick mark, you can do it yourself. Earlier, this was done by the developer through the back-end. But now, the user can do it themselves. This saves your time to call the query desk and wait till developers resolve.

In the SwilERP software there is an option called Database Health.

Log-in SwilERP Software:
  1. You can easily navigate to the option by using the following steps: 
  1. Select the System System Maintenance > Database Health.
SwilERP Dashboard Window
Note:- (As soon as you click on the Database Health option the given below window will open and ask you for a password. The password will be like this H*****H. To know the complete password, the user can raise a ticket on http://www.swindia or contact the customer support team.)

Password Verification Window
 Note:-  Once you insert the password, the Database Health window will open:

  1. Here you will see how Database Health window will work:-

1-) Check and Process:- In this option, you can check some key points. Check Queries for Last/ Check Database Integration/ Recompile Stored Procedure/ Indexing and Update Statistics/ Shrink Database and other options will be there.

2-) Change Settings :- You can check and reset the software with the options of Database Auto-Growth Size/ Database Auto close/ Memory Configuration/ Path of Temp Database, etc.

3-) Logs :- You can clear your logs history in this option. 
In the above mentioned options, you need to mark that particular option which you want and click on the Process and Re-check button. It will start with a success message, as shown in the image.

Database Health Window

      • Related Articles

      • DataBase Health

        DataBase Health This option is now available in the latest version of RetailGraph. To upgrade the software please make ticket on Swildesk.com or contact your local service provider.  DataBase Health option is generally used in those cases where user ...
      • How to delete unused lots from System Maintenance

        How to delete unused lots from System Maintenance This option is generally used in that case where you have made lots of multiple or single products in the software. Now those lots are useless and you don’t want their details to rectify to the ...
      • How to delete unused lots from System Maintenance

        How to delete unused lots from System Maintenance This option is generally used in that case where you have made lots of multiple or single products in the software. Now those lots are useless and you don’t want their details to rectify to the ...
      • Shrink Database Feature has been Introduced to Free Up Additional Space

        Data is a major asset of any organization. Most industries rely on data, especially retail/wholesale markets such as pharmacy stores, grocery stores, supermarkets, restaurants, etc. Achieving the greatest efficiency and error-free management is ...
      • Merge Products

        Merge Products in RetailGraph Software This process is very useful in those cases where a customer by-mistake makes one product with 2 different names. It can be in a branch or a single database that doesn't matter.  To execute the following process ...