What are some best practices for Running Reporter, version 9.x?
Upgrade to the latest version of Reporter
Use the sizing guide found here. (Sizing for Reporter OS alone and not to include FTP logs File Storage)
Only send access log files from the ProxySG in the optimized format: bcreportermain_X.
Use only the recommended browsers, the list of recommended browsers can be found in the release notes for the version of Reporter you are running.
Ensure only one type of logs are sent to each database; each of the below access logs should be in separate databases.
Streaming (Streaming media logs)
Proxy Client logs
Optimizing log processing is discussed in Chapter 2 of the Reporter Administration Guide, under the heading "About Optimizing Log Processing Configurations" follow these recommendations to optimize the processing of logs.
NOTE: Version 9.x Reporter only supports Symantec ProxySG HTTP, HTTPS, and Proxy Client access logs.
Use FTP to upload your reports to a local drive on the Reporter server.
Use 64-bit CPU hardware with the supporting operating systems. Reporter can run on both Red hat enterprise Linux version 5, or Microsoft Windows 2003 and 2008 servers. See the Symantec Reporter version 9.x release notes file for the exact specifications.
Do not run Reporter on a Windows Primary Domain controller. Some large database queries can consume so much CPU time that authentication requests start to slow down or even stall.
Disk space and placement of access logs:
Upload your access logs to a separate server, and pull them down via the FTP protocol to be processed into the databases. If you can't upload them to a separate server, have them uploaded to a separate mount point, or Drive on the server you run Reporter on.
Only upload them every hour to ensure you don't overload your servers file system. To minimize load, Symantec recommends that you only process access logs once a day. By Default, Reporter is configured to check, and process, access logs every ten minutes.
Create you database(s) on local mount points, or disk drives, on your server. If you create a database on a Disk drive, or Mount point (LINUX) other than the one the Reporter service runs on, it will not monitor it and alert you when you run low on space.
Ensure you always test how long a Report takes to run before you schedule it. This ensures that you allow appropriate time between scheduling each report.
Do not store more than 50,000 access logs in one folder. Reporter has trouble with more than this amount, when it comes to having to re-process them all at once.
Schedule Reporter to process it's access logs at 2 AM every day to avoid running reports, and processing access logs at the same time.
Do not upload more than a year worth of access logs to the same folder. By default, the ProxySG does not write the year into the name of access log, so after a year, Reporter sees the same name log file in the folder. The rename occurs as Reporter moves or rename the access logs once it has finished processing them. The file names will look like the following:
Original file name from the year before: SG_main__2100316010000.log.gz
After an attempt to rename/move the access log file, it will name this file to: dup0001_SG_main__2100316010000.log.gz
Shut down gracefully:
Ensure Reporter is shutdown gracefully before stopping the Host operating system.
For LINUX, run the "/etc/init.d/bcreporter stop" command before stopping LINUX.
For Windows, run a "Net stop bcrservice" as a script, prior to stopping Windows.
Before scheduling a report, manually generate it to time how long it takes.
Schedule reports at different times.
Predict how long a report will run and schedule large reports at staggered intervals from each other.
Schedule large reports at the slower times of the day, such as after midnight.
To allow for future growth, install your application on VMware. This allows you to add disk space, and memory, as your database grows.
Imported Document ID: 000008247
Subscribing will provide email updates when this Article is updated. Login is required.