SQL

Slow Performance in OnGuard with SQL Server 2022

03/27/2024Matthew Therolf
Symptom Database-intensive OnGuard operations present a noticeable performance loss when the database is hosted in SQL Server 2022 and the OnGuard login for SQL (the SQL-authentication login) does not have db_owner permission to the database. Re...

Unique Constraint Errors on Serial Number

02/11/2022April Daniels
Symptom In the log, you may encounter errors referring to duplicate serial numbers. The following example is for an Oracle database: Database error encountered: Serial Number: 1360725739, Event: 0-0, Panel: 5281: ORA-0001; unique constraint (LEN...

How to capture a SQL Profiler Trace and export results.

02/07/2022April Daniels
How to capture a SQL Profiler trace, and then export the results. Procedure Steps Log into SQL Management Studio and select Tools > SQL Server Profiler .   Log into the SQL Server database as a user with permission to perform a trace. Select t...

Database Error, unable to archive database

02/07/2022April Daniels
Symptom  When attempting an archive or purge your database, you see one of the following errors:            When observed in System Administration, you see the following connection error:      Resolution  In most cases, the issue is reso...

SQL Server Data Source drivers used with OnGuard

02/04/2022April Daniels
Symptom  SQL Server Data Source drivers used with OnGuard  Resolution  OnGuard 7.3 and earlier installed with SQL Server requires that SQL Server Data Sources use the SQL Server Native Client 11.0 driver . OnGuard 7.4 and later installed with SQ...

Migrating an Existing SQL Database to Azure SQL

10/11/2018April Daniels
Procedure Prepare an empty database on the Azure server (preferably with the same name as existing on-premises database) for each of your existing databases (for example, the live, reports, and archival databases). From the Microsoft download...

Installing OnGuard on Microsoft Azure SQL

10/11/2018April Daniels
Installing OnGuard on Microsoft Azure SQL requires manual configuration changes because: The field for the database server name during installation expects a valid hostname (such as   DBSERVER0002 , but not tcp:databasename.database.windows....

How to setup ODBC Logging

07/02/2018April Daniels
There are some cases where configuring ODBC logging might provide additional information to troubleshoot application connections that use ODBC.   Procedure Steps Open 32 bit ODBC Data Source Administrator (C:\Windows\Syswow64\odbcad32.exe)...

Improving indexes and providing a performance increase when running reports

03/28/2018April Daniels
Improving indexes and providing a performance increase when running reports   Procedure Steps   The first 3 SQL commands provide the most improvement. The other 2 are also necessary for overall improvement. If you have any questions, pleas...

SQL Server service starts and immediately stops

03/07/2018April Daniels
Symptom When attempting to open OnGuard applications on the server and workstations, users will receive "Cannot establish communication with the login driver" and when opening SQL Server Management Studio users will see "Package 'Microsoft SQL ...