Deleting of Transaction Log file

Deleting of Transaction Log file

Dear Specialist

 

One of our customer is facing with the very slow page loading and sometimes it fails when loading the device list page.

Because of that, the administrator is feeling hard to manage their devices. 

There are just 3000 of android devices connected to 1 SOTI server which its hw spec can endure to 10000 devices. 

 

1. Why is the page loading time too long?(2~3mins)

2. Is there any known solutions for this matter? 

3. How about deleting Transaction Log file of mobicontrol DB file?

 

Thank you

 

David Park

 

9 Answers

Order By:   Standard | Newest | Votes
RKMOD@SOTI | posted this 17 January 2019

Hi David,

Kindly find below the answer to your questions:

1) The Page (web console) could be taking more time to load due to high resource consumption on the server. You need to check if there is high CPU or memory consumption on the server.
You can refer to the following link in order to understand the server configuration with respect to the number of devices:
https://www.soti.net/mc/help/v14.0/en/setup/installing/system_requirements.html

2) You can restart all the services to reduce the CPU consumption and monitor if the consumption increases again.

3) Yes, you can also shrink DB and truncate logs to improve the performance.

Technical Support | SOTI Inc. |1.905.624.9828 | support@soti.net | www.soti.net |

  • 0
  • 0
David Park | posted this 21 January 2019

Dear RKMOD

 

Thank you for the answer.(I thought nobody would answer me ha). 

Regarding the Deleting of Transaction Log file. 

 

1. There are two way of it 

  a. Delete on Mobi Control Web console. 

  b. Delete Log file on MobiControlDB file in DBMS. 

 

Doesn't it matter with b.?

Thank you 

 

David Park

  • 0
  • 0
Benedict Lumabi | posted this 21 January 2019

1. Is this bare-metal or virtual-machine?

2. If bare-metal, what is the specs of the server?

3. If virtual machine, what specs have you assigned?

  • 0
  • 0
David Park | posted this 21 January 2019

Dear Benedict 

 

Thank you for the answer. 

Here is the server info 

 

  1. Server Specification of MobiControl Server(MS, DS)

Manufacturer : Lenovo

Model : System 3550 M5

Processor : Intel® Xeon® CPU E5-2623 v4 @ 2.60GHz 2.60GHz

RAM : 16GB

System 64Bit, X64 processor

 

  1. Connected Device to above 1 Physical Server.

Almost 3100 Android Devices and in the near future, it will increase up to 5000.

 

Thank you

 

It is not Virtual but one physical server. 

 

David Park

  • 0
  • 0
Raymond, Chan | posted this 21 January 2019

- Do you have your DS, MS and SQL servers all in one physical server instance with your Xeon E5-2623 v4 cpu and 16GB RAM?

 

- What is the version and build numbers of your MobiControl Server?

 

- What is the version number of your MS-SQL server? Express or Paid edition?

 

- Do you know how many concurrent web-console sessions were opened (on average) to be served at any time?  Or does the problem persist even for only 1 web-console session?

 

- Have you used Microsoft utility to check cpu and memory loading of your server?  If so, what are the results?

 

- Does each and every page loading consistently take 2-3 minutes, or it just occasionally (say 1 out of 10 or more attempts)  takes so long?  Is there any statistics on the spread say for a few tens of loading attempts?

 

  • 0
  • 0
David Park | posted this 22 January 2019

Dear Raymond

 

Thank you. 

Here is my answer. 

Do you have your DS, MS and SQL servers all in one physical server instance with your Xeon E5-2623 v4 cpu and 16GB RAM?

>>DS and MS : on one physical Server

>>SQL Server : Separated on one physical server maybe same spec but I am checking again.  

 

- What is the version and build numbers of your MobiControl Server?

Agent Version : 13.3.2 Build 1014 and 13.5.1 Build 1044

Server Version : 13.3.0 Build 3411

 

- What is the version number of your MS-SQL server? Express or Paid edition?

  SQL Server 2016 KO Standard

 

- Do you know how many concurrent web-console sessions were opened (on average) to be served at any time?  Or does the problem persist even for only 1 web-console session?

There is 1 administrator and 1 web-console.

 

- Have you used Microsoft utility to check cpu and memory loading of your server?  If so, what are the results?

Not yet. What is the MS Util?

 

- Does each and every page loading consistently take 2-3 minutes, or it just occasionally (say 1 out of 10 or more attempts)  takes so long?  Is there any statistics on the spread say for a few tens of loading attempts?

Generally every page loading takes long time but especially in Device List.

  • 0
  • 0
Raymond, Chan | posted this 22 January 2019

Without the SQL server,  16GB just for DS + MS should be OK.  To confirm, you can check if there is much free RAM available.   The free MS util  that can be used is  the"Resource Monitor" under Administrative Tools. You can also check if there is any excessive network traffic between your DS+MS and SQL server.

 

If memory and network bandwidth are not the root cause of your problem,  maybe the server version you are using is.  According to the v13.3 release notes,  at least the following are related to run-time performance issues :

  MCMR-11751   fixed in  v13.3.0.3766

  MCMR-11401, MCMR-10562, MCMR-11367 fixed in   v13.3.0.3690

 

You might need to check with Soti support team to see if it is worth investigating the need to have a server upgrade.  Of course, many other factors need to be considered.

 

 

 

  • 0
  • 0
David Park | posted this 18 February 2019

Dear Raymond

 

Thank you for the useful knowledge. 

I've checked our customer's environment and found something weird. 

My customer has installed Mobicontorl and SQL server on 1 physical server. 

and the memory usage of SQL Server is strangely too much. 

Please refer to the below image. 

The memory is assigned about 8GB only for SQL Server. 

Why has this SQL Server too much memory? 

 

Thank you

 

David Park

  • 0
  • 0
Raymond, Chan | posted this 18 February 2019

I wouldn't be too surprised with the memory used for SQL if you have over 3000 devices enrolled on your system.  If you have about 20% free memory available, then you shouldn't worry that much. 

 

Did you also check the cpu, disk I/O and Nework I/O loading on your server host? Try to  see if there are big loading spikes in any of the above when you try to list devices on a web-console session in a browser.  If there is sufficient spare resources in all of the above items,  you might focus more on the MobiControl server version.  As mentioned in my previous post, you might need to consider upgrading to more recent build of v13.x.     However, it must be noted that there are many technical and non-technical factors to consider for a server upgrade.    A poorly planned or implemented upgrade may create more problems than what you have now.   

 

It's best for you to provide more detailed information of your implementation to Soti or local reseller/distributor, so that they can give relevant recommendation(s) on what can be done to improve.

  • 0
  • 0
Give us your feedback
Give us your feedback
Feedback