STOP WRITING TO THE LOGARCHIVE table

  • 4 November 2009
  • 2 replies
  • 4 views

Badge +11

Hi


When i ran the profiler utility on sql server to test the progress of some task on k2 workspace, i have noticed that most of the resources went in writing to the LOGARCHIVE table.


IS THERE A WAY TO STOP THAT IN K2?


2 replies

Badge +9

It is probably because you turned on database logging in your HostServerLogging.config.


It is this line in the config file.  If you turn it to Active="True"


        <LogLocation Name="ArchiveExtension" Active="False" LogLevel="Debug" />


Depending on the LogLevel setting, this could potentially create quite a load on the table.

Badge +11

Thanks alot

Reply