SQL server slowness

SQL server slowness

As your product works with the SQL Server database system, the transaction log file can grow very large. The larger it gets, the more sluggish the performance of your product becomes.


Shrink the transaction log file.  

  • Start the SQL Server Management Studio by clicking Start, All Programs, SQL Server, SQL Server Management Studio.
  • In the left pane, expand the Databases item, and right-click wkennel and choose Properties.
  • Click Options.
  • Change the Recovery model option to Simple, if it isn't set to that already.
  • Click OK
  • Right-click the database again, and choose Tasks -> Backup...
  • If there is a backup filename listed under Back up to, click on it once and click Remove to remove it. Do this for all file names listed.
  • Select Disk in the Back up to section toward the bottom and click the Add button
  • Give the backup file a name, and include the full path to it, and .bak as the extension. For example, C:\KCBackup.bak
  • Click OK and the database will be backed up.
  • Right-click the database again, and choose Tasks -> Shrink files
  • Change file type to Log
  • Click OK.
  • Now reset the recovery model back to Full: In the left pane, expand the Databases item, and right-click wkennel and choose Properties.
  • Click Options.
  • Change the Recovery model option to Full.
  • Click OK

The preceeding procedures will shrink the log file and return the original speed back to your product. For good measure, reboot the SQL Server computer


    • Related Articles

    • Installing Kennel Connection 7 & SQL Server

      Installing Kennel Connection 7 & SQL Server Welcome to the installation guide for Kennel Connection 7.  Kennel Connection 7 is compatible with Windows 7 or higher operating systems.  Windows 10 is recommended.  Important:  If you are installing ...
    • Renaming SQL Server to match your new computer name

      Renaming SQL Server to match your new computer name IMPORTANT:  **Please note this is not something covered under the Software Connection support plan. This is an external SQL server support issue that you may need to contact an outside PC technician ...
    • Error "Microsoft ODBC SQL Server driver DBNETLIB Connection Write send" when using SQL server

      Cause 1 - This is a network drop where this computer is losing connection to the server/main computer.   Sometimes just rebooting the computer is enough to get it to reconnect.  If that doesn't work, technical support can attempt to network it again. ...
    • Setting SQL to always start with Windows

      Setting SQL to always start with Windows When using a SQL database, SQL server needs to be running in order for Kennel Connection to function.  SQL server should always start when Windows starts.  Here are the steps. Click on Start, All Programs. ...
    • Installing KC7 with an already existing version of SQL

      Installing Kennel Connection 7 with an existing version of SQL Server Welcome to the installation guide for Kennel Connection 7.  Follow the instructions below to get KC7 installed on your machine. Important:  If you are installing KC7 on your ...