Technical, Setup, Server Configuration

This contains all the information about databases, servers, networks, infrastructure.

How To - Produce Standard SQL Server Activity and Performance Reports
The Standard Toolset of SQL Server Reports can assist in troubleshooting ClickHome3. To produce the reports: Right click on your server Select Reports...
Thu, 12 Apr, 2018 at 4:39 PM
How To - Make a copy of Production Database for Testing
Backup This is the easy part, follow your normal routine for performing a SQL backup of the Production database. This is our process when backing up a da...
Thu, 22 Apr, 2021 at 8:24 AM
How To - Recycle the Application Pool
Sometimes to apply new settings you will need to recycle the Application Pool. Note that this may reset the sessions of currently connected users.  To d...
Mon, 16 Dec, 2019 at 12:03 PM
Database - Manage Backups and Transaction Log Growth
Problem: Client discovers an increase in transaction log size and is running out of space on the Log file drive. Solution: Maintenance of the SQL serv...
Fri, 10 Jul, 2020 at 8:59 AM
Database - High Growth in SQL Server Database Primary Data File
Client Reports their SQL Server Database Primary Data File has grown considerably. Request the client to  run a "Disk Usage By Table" Standard...
Thu, 12 Apr, 2018 at 4:36 PM
Database - Basic Instructions for Database Backup
Backing up and Restoring databases is not the responsibility of ClickHome staff. However during some Support or Implementation activities we will take a bac...
Thu, 12 Apr, 2018 at 4:36 PM
Database - Manually Create Fresh ClickHome 3 Database
This article is a stub from the Fresh Install of CH3 Article. This article relates to SQL Server 2014. Version numbers (ie 120) in command line will var...
Thu, 12 Apr, 2018 at 4:39 PM
Technical - Monitoring DB Mails
If ClickHome is sending notifications through the DBmail and you would like to check what has gone out. First things first - view the database mail logs...
Fri, 6 Apr, 2018 at 4:38 PM
Technical - ClickHome Performance
Over time the ClickHome system might slow down, one of the causes can be the performance of the SQL Server or specific queries. Use the SQL Performance ...
Tue, 10 Nov, 2020 at 11:45 AM
Technical - Windows Service "Hung" - Shows as started but not running
Sometimes your ClickHome windows service will have a fault where in the Services front end it displays "Started" but it is not processing Back End...
Thu, 12 Apr, 2018 at 4:33 PM