Forums (Obsolete)

Old Forums

Installation and deployment Questions on installation, system configuration and deployment to the live server.

Version 6.x > Installation and deployment > DB: Change physical log file for table

View modes:

Certified Developer v7

emanuele.firmani-aduno-gruppe - 6/1/2012 5:17:28 AM

DB: Change physical log file for table

We have a website that produces a lot of logs (in two months we have 1'300'000 entries and 7.5GB).
Our DBAdministrator asked me to move the table CMS_EventLog to a different physical file tha he would create in the same filegroup.

Is it possible? Should it have any sideeffect on future updates or patches?

Many thanks
Regards
Emanuele Firmani


Certified Developer v7	emanuele.firmani-aduno-gruppe - 6/1/2012 5:18:53 AM RE:DB: Change physical log file for table We are using v5.5R2 and planning a future move to v6.

Kentico Support

kentico_jurajo - 6/1/2012 1:26:28 PM

RE:DB: Change physical log file for table

Hi,

Which log files you mean?
The Kentico log is stored in the DB as a normal data records and default setting is to limit the records to 1000 items (Site Manager -> Settings -> System -> Log size)
Which DB consumes the most of the space?

My guess is you are talking about the SQL server full transation logs - this is SQL server side setting for given DB.

Best regards,
Juraj Ondrus

Certified Developer v7

emanuele.firmani-aduno-gruppe - 6/3/2012 11:40:18 PM

RE:DB: Change physical log file for table

I set the log max entries to 10'000'000 because I need all the log entries. We will set up also a batch process that moves all the logs older than 1 month to a different DB.
I'm not talking about the transaction logs.

Is it possible to change the physical log file for the table CMS_EventLog? This way we can also parallelize reading and writings.

Thanks
Regards
Emanuele Firmani

Kentico Support

kentico_jurajo - 6/4/2012 10:32:28 AM

RE:DB: Change physical log file for table

Hi,

Now I got it. Well, your question is more for the SQL server administrator. From Kentico side there is no setting how to set different physical location for given table. I am also unsure if it is possible on the SQL server level - I did a quick Google and it should be possible - there are several articles on this topic however I am not sure which one will fit your need the best.

Best regards,
Juraj Ondrus

Top