• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 364
  • Last Modified:

Statistics Reports is getting huge!!

The statistics report is continuing to grow.  I don't use statistic reports, how do I stop this or limit the size that it can grown to?  
0
sfrisk
Asked:
sfrisk
  • 3
  • 2
  • 2
1 Solution
 
qwaleteeCommented:
Remove REPORT from the ServerTasks= line in NOTES.INI
0
 
sfriskAuthor Commented:
"Report" is not on the ServerTasks line.
0
 
qwaleteeCommented:
Do you have a consolidated statistics report? Then another server has been set to generate stats for the server you are looking at.

I'm assuming in all this that you are talking about the STATREP.NSF database.
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
SysExpertCommented:
ANother solution is to set the auto delete option to something like 30 days, in the replication settings.


I hope this helps !
0
 
sfriskAuthor Commented:
Qwalette - We have one server running Domino and I'm not sure what type of statistic report I have.  Up until about a month ago, I never noticed it.  Yes, it's the statrep.nsf database.  

SysExpert - under replication settings, I don't see any option to delete.  
0
 
qwaleteeCommented:
As afr as I can recall, the only thing that dumps content into STATREP is the REPORT task. Type SHOW TASKS on the server console and check if COLLECT or REPORT

ALso, if you are only worried about the size of statrep itself, you can always delete it, or purge it and compact it. If there is nothing new being added, but at one time it was very large, then it may never grow smaller until you do one of these steps!
0
 
SysExpertCommented:
IN the replication settings - Space Saver TAab. there is a check box - remove Documents not modified in the last xx days ( default 90 ), CHeck the box and set it to 30 days.

You may also need to run compact on it once in a while to recover white space.


I hope this helps !
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now