You must Sign In to post a response.
  • Category: Software

    Can anyone share SQL server database performance improvement hints?


    Have you got a query about database performance? Want to know more about SQL databases? Find advice from experts on this page.

    Can anyone share SQL server database performance improvement hints? ERP software backend is SQL server database. ERP performance is slowing day by day due to large number of transactions then what steps you will take to improve performance of software or database.

    If database size is very big then how can we reduce that? Is there any way to set batch job in SQL to reduce database size in timely fashion?
  • #144378
    When data size increases then it is natural for the systems to response in a slower mode. While using SQL data base systems for large data based which are day by day increasing there are some measures which can be useful in tuning up the system to desired speeds.

    1. The historical data can be loaded separately either in devices offline or in the server itself in a separate place to be accessed on need basis rather on a regular one.

    2. Optimization of applications is one important aspect before going in for hardware upgradation.

    3. Replacing old hardware with new hardware. Sometimes even upgrading helps in bringing desired results.

    4. Scaling out the functionalities. For example you can port your CRM module in one server and ERP module in another.

    5. Sometimes changing from random disk access to sequential disk access helps in bringing improvement in disk related issues.

    6. Retrieving too much data, creating unnecessary transactions, using too many indexes are some common reasons for speed inefficiency.

    Above remedial measures are to be considered in a cost effective manner otherwise the benefits derived will not be worth their cost.

    Knowledge is power.

  • #144528
    There are few things which need to be followed to keep the performance of the database smooth.
    1. Check the SQL database tables which store the transaction details. Sometimes, these may not be cleared in a timely manner and hence the database size will increase. So, transaction related tables should be reviewed and a manual deletion/automation has to done to remove old transaction data.
    2. Check the database mount points location if there are any database backup or temporary files. If so, you need to delete those to get some disk space. You need to traverse into sub folders to check the existence of the backup files.
    3. Ensure that only authorized users are using the database. You need to have a proper access management system in place to ensure all have only required access. See if there is any unusual increase in the transactions to the database.

    Regards
    Rizwan


  • Sign In to post your comments