Question & Answer
Question
SQL Database Mode.
Answer
Contents
Problem
SQL Database Mode.
Solution
Problem
SQL Database Mode.
Solution
Database sizing guidelines for Tealeaf Visitor Staging and Report databases are based on multiple interdependent factors. For more information on database sizing contact IBM Tealeaf Professional Services.
Setting the Recovery Model and Logging Levels for Tealeaf Databases
To properly maintain the Tealeaf databases control their size and improve performance Tealeaf recommends using the Simple Recovery Model for SQL Server and compressing the log files.? If you are experiencing database size and performance problems review the following steps to set the Recovery Model to the Simple setting:
- For each installed Tealeaf database:
- In SQL Server Management Studio right-click each Tealeaf database and select Properties.
- In the dialog select the Options page.? Review the setting in the Recovery Model drop-down.? To reduce the size of the database set this setting to Simple.? Click OK at the bottom of the dialog.
- Repeat the above steps for the other Tealeaf databases.
- Stop the Tealeaf Data Collector and Tealeaf Reporting services through the Windows Services Control Panel.
- In SQL Server Management Studio for each database:
- Right-click the database name. Select Tasks --> Shrink --> Files.
- In the dialog select Log from the File Type drop-down. Click OK.
- Repeat the above steps for the other Tealeaf databases.
- After the above has been completed for each database restart the Tealeaf services.
These steps reduce the size of your databases and reduce the disk I/O by lowering the amount of logging that is being done.
Article Reference
00000587
"
[{"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Product":{"code":"SSERNK","label":"Tealeaf Customer Experience"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"","label":""}}]
Was this topic helpful?
Document Information
Modified date:
08 December 2018
UID
ibm10777429