OnBase Technical Blog

Creating Customized Database Maintenance Plans

Within the Database Maintenance Guide (found here) Hyland Software, Inc. provides general recommendations for maintenance strategies. Realize that these recommendations are very generic in nature and will likely have to be modified for Enterprise ...

Tools for Troubleshooting Performance Issues

This is the first post, in what will hopefully be a series of posts, discussing tools that are useful when troubleshooting performance issues in a SQL Server database.The first tool we would like to mention is a custom stored procedure called WhoIsAc...

OnBase Database Modifications

There have been occasions where customers have asked if they can modify the database directly. The short answer is no, and for full details on what is permitted with regard to changes to the OnBase database, please see the Database Use Policy, found...

Sizing the SQL Server Transaction Log and TempDB

Customers often ask for size estimates for the OnBase database transaction log and TempDB database. There is no definitive answer that we can provide, unfortunately; it depends. The Transaction Log At the time of this writing, no documented recommen...

SQL Server Instance-level setting: Optimize for Ad hoc Workloads

In SQL Server 2008, a new instance level setting was introduced: Optimize for Ad hoc Workloads. Enabling this setting improves the efficiency of the plan cache by only placing a plan stub in the plan cache the first time a batch is compiled instead ...

White Paper: Aligning OnBase SQL Accounts in Mirrored Environments

OnBase supports many business continuity/disaster recovery strategies, including high availability via Microsoft Database Mirroring. This white paper provides DBAs with guidance on how to prepare their environments for automated failover to the mirro...

Database State of In Recovery

A SQL Server database can be in different states, and these states are detailed in MSDN here. Typically, an OnBase database is an Online state, where it is actively available for use. For the database state of Recovery or In Recovery, no attempts s...