Unified CVP: Reporting Server Logging Causes Performance Issues

From DocWiki

Revision as of 23:06, 6 May 2010 by Cchetty (Talk | contribs)
Jump to: navigation, search

Reporting Server Logging Causes Performance Issues

Problem Summary Multiple performance issues may be seen with reporting server performance. For example, reporting server may stop righting to the database for a time period and no data is recorded for the time period. The RPT interval stats show 0 database writes during the period.
Error Message No error message is displayed.
Possible Cause The database is set to use unbuffered logging mode. Change the database to use buffered logging mode.
Recommended Action To verify logging mode:
dbaccess sysmaster    Select * from sysdatabases where name='cvp_data')

To change the database to use buffered logging mode:

Ontape -B cvp_data 
Release Unified CVP 4.x, Unified CVP 7.x
Associated CDETS # CSCtg55787

Rating: 0.0/5 (0 votes cast)

Personal tools