IPB

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> KSC MDF/LDF File size [Solved], How can i reduce the size
Brian Oakes
post 20.03.2017 13:59
Post #1


Newbie
*

Group: Members
Posts: 8
Joined: 25.02.2015




Hello!

I was looking at the disk space used on the KSC 10 (10.3.407) and I noticed the mdf file is 947 megs, and the ldf file is 389gig

To me this seems a bit of out whack. Any reason you can think of why the ldf file is so large, and more importantly... any idea how to reduce it?

Thanks!

This post has been edited by Brian Oakes: 20.03.2017 14:03
Go to the top of the page
 
+Quote Post
Kirill Tsapovsky
post 20.03.2017 14:38
Post #2


Technical Support Specialist
**************

Group: KL Russia
Posts: 11634
Joined: 3.12.2013
From: Moscow




QUOTE(Brian Oakes @ 20.03.2017 12:59) *
Hello!

I was looking at the disk space used on the KSC 10 (10.3.407) and I noticed the mdf file is 947 megs, and the ldf file is 389gig

To me this seems a bit of out whack. Any reason you can think of why the ldf file is so large, and more importantly... any idea how to reduce it?

Thanks!


Hello.

Please provide information on the size of your actual SQL KAV database, the backup size and the mentioned tempdb files sizes.
If System Management enabled and utilized?
Please collect and provide ~15 minutes of traces of Server, Console and Network Agent on the KSC server, including start (restart) of KL services.

Thank you.


--------------------
In English: GSI report | AVZ report | KSC10 Traces | KES10 Traces | KSC9 Traces | KES8 Traces | klnagchk log
На русском: Отчет GSI | Лог AVZ | Трассировки KSC10 | Трассировки KES10 | Трассировки KSC9 |Трассировки KES8 | Отчет утилиты klnagchk

Пожалуйста, оцените оказанную помощь, используя опцию "Rating" в названии топика!
Please evaluate support help by using "Rating" option!
Go to the top of the page
 
+Quote Post
Brian Oakes
post 20.03.2017 15:41
Post #3


Newbie
*

Group: Members
Posts: 8
Joined: 25.02.2015




QUOTE(Kirill Tsapovsky @ 20.03.2017 05:38) *
Hello.

Please provide information on the size of your actual SQL KAV database, the backup size and the mentioned tempdb files sizes.
If System Management enabled and utilized?
Please collect and provide ~15 minutes of traces of Server, Console and Network Agent on the KSC server, including start (restart) of KL services.

Thank you.


KAV DB - 948mb
KAV LOG - 409049mb
KSC Backup - 357GB

If System Management enabled and utilized? - Not sure what this means?

I have the data gathered and zipped. It's 77 megs. How would you like me to attach it? Thanks for the help!
Go to the top of the page
 
+Quote Post
Kirill Tsapovsky
post 20.03.2017 15:44
Post #4


Technical Support Specialist
**************

Group: KL Russia
Posts: 11634
Joined: 3.12.2013
From: Moscow




QUOTE(Brian Oakes @ 20.03.2017 14:41) *
KAV DB - 948mb
KAV LOG - 409049mb
KSC Backup - 357GB

If System Management enabled and utilized? - Not sure what this means?

I have the data gathered and zipped. It's 77 megs. How would you like me to attach it? Thanks for the help!


System Management is advanced KSC functionality that includes, among other things, storage and deployment of Microsoft and other third party patches and updates: this may dramatically increase the size consumed by the server.

You can use any file sharing resource to upload the file, then provide the link.

Is it possible to determine at which point the log file increases (during which actions)?

Also, please specify whether you have the latest patch (B ) for KSC 10.3.407 installed on the server.

Thank you.


--------------------
In English: GSI report | AVZ report | KSC10 Traces | KES10 Traces | KSC9 Traces | KES8 Traces | klnagchk log
На русском: Отчет GSI | Лог AVZ | Трассировки KSC10 | Трассировки KES10 | Трассировки KSC9 |Трассировки KES8 | Отчет утилиты klnagchk

Пожалуйста, оцените оказанную помощь, используя опцию "Rating" в названии топика!
Please evaluate support help by using "Rating" option!
Go to the top of the page
 
+Quote Post
Brian Oakes
post 20.03.2017 16:20
Post #5


Newbie
*

Group: Members
Posts: 8
Joined: 25.02.2015




QUOTE(Kirill Tsapovsky @ 20.03.2017 06:44) *
System Management is advanced KSC functionality that includes, among other things, storage and deployment of Microsoft and other third party patches and updates: this may dramatically increase the size consumed by the server.

You can use any file sharing resource to upload the file, then provide the link.

Is it possible to determine at which point the log file increases (during which actions)?

Also, please specify whether you have the latest patch (B ) for KSC 10.3.407 installed on the server.

Thank you.


Thanks for the explanation. To be honest that might be enabled. We don't need it for Windows Patches etc, but for other items like Chrome, and Flash etc, that could come in handy. I took over KSC duties from someone, but I am still getting my head around it.

No just noticed the size recently when we were moving the VM to another host. I looked to see why it was taking so long, then noticed the size of the disk.

In the General Section of the properties of the server, the listed version is: 10.3.407. Not sure if that is changed when updated to the latest patch. I haven't done anything to install it, but if it's auto patched then it might have it.

Here is a link to the data - https://1drv.ms/u/s!Am5VxbugtT5qi7UDvypM7Ty9NjkVgA

Thanks, appreciate it!
Go to the top of the page
 
+Quote Post
Kirill Tsapovsky
post 20.03.2017 16:30
Post #6


Technical Support Specialist
**************

Group: KL Russia
Posts: 11634
Joined: 3.12.2013
From: Moscow




QUOTE(Brian Oakes @ 20.03.2017 15:20) *
Thanks for the explanation. To be honest that might be enabled. We don't need it for Windows Patches etc, but for other items like Chrome, and Flash etc, that could come in handy. I took over KSC duties from someone, but I am still getting my head around it.

No just noticed the size recently when we were moving the VM to another host. I looked to see why it was taking so long, then noticed the size of the disk.

In the General Section of the properties of the server, the listed version is: 10.3.407. Not sure if that is changed when updated to the latest patch. I haven't done anything to install it, but if it's auto patched then it might have it.

Here is a link to the data - https://1drv.ms/u/s!Am5VxbugtT5qi7UDvypM7Ty9NjkVgA

Thanks, appreciate it!


Patch "B" is not currently provided as an autopatch, however it is suggested for installation.
Please create an run a "Databases maintenance" task for KSC, checking the option "Shrink database": this should decreade the temp log size. If the file does not resume growing unproportionally afterwards, this should resolve the issue.

Thank you.


--------------------
In English: GSI report | AVZ report | KSC10 Traces | KES10 Traces | KSC9 Traces | KES8 Traces | klnagchk log
На русском: Отчет GSI | Лог AVZ | Трассировки KSC10 | Трассировки KES10 | Трассировки KSC9 |Трассировки KES8 | Отчет утилиты klnagchk

Пожалуйста, оцените оказанную помощь, используя опцию "Rating" в названии топика!
Please evaluate support help by using "Rating" option!
Go to the top of the page
 
+Quote Post
Brian Oakes
post 21.03.2017 05:58
Post #7


Newbie
*

Group: Members
Posts: 8
Joined: 25.02.2015




QUOTE(Kirill Tsapovsky @ 20.03.2017 07:30) *
Patch "B" is not currently provided as an autopatch, however it is suggested for installation.
Please create an run a "Databases maintenance" task for KSC, checking the option "Shrink database": this should decreade the temp log size. If the file does not resume growing unproportionally afterwards, this should resolve the issue.

Thank you.


Howdy!

I ran the DB maintenance job, and that solved the problem. Thanks for the tip!
Go to the top of the page
 
+Quote Post
Dmitry Eremeev
post 21.03.2017 08:31
Post #8


Technical Support Specialist
**************

Group: KL Russia
Posts: 11014
Joined: 30.07.2014
From: Moscow




QUOTE(Brian Oakes @ 21.03.2017 04:58) *
Howdy!

I ran the DB maintenance job, and that solved the problem. Thanks for the tip!


Please evaluate support help by using "Rating" option!


--------------------
In english: GSI report | AVZ report | KSC10 Traces | KES10 Traces | KSC9 Traces | KES8 Traces(RUS) | klnagchk log(RUS)

На русском: Отчет GSI | Лог AVZ | Трассировки KSC10 | Трассировки KES10 | Трассировки KSC9 |Трассировки KES8 | Отчет утилиты klnagchk

Подписаться на новости о корпоративных продуктах

Пожалуйста, оцените оказанную помощь, используя опцию "Rating" в названии топика!

Please evaluate support help by using "Rating" option!


Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic

 



Lo-Fi Version Time is now: 24.04.2017 19:14