yehezkiel2006
Posts: 1
Joined: Fri Jun 29, 2018 3:48 am

Slow generate reporting

Fri Jun 29, 2018 5:00 am

Hi,
I am newbie in GPSgate application.
I have one server installed with SQL Server and GPSgate v5 (updated from previous version). And currently handle 1028 unit vehicle. The database growth rapidly and now is 61 Gb. The processor is Xeon E3-1220 v5 3Ghz memory 32Gb and HDD SCSI.

CPU usage avg < 20% and memory usage < 36%. but the disk activity is always 100% highest active time and Disk I/O activity < 1MB/sec but it slow when generating query for reporting. We only keep data until 3 months. the highest activity process is SQLServer. I tried to restart the sql server but still got same result.

Can anyone advise what is the best solution on this? We have plan to using separate reporting server : https://gpsgate.com/blogComment/archiving_reporting_server to avoid server work hard.

Return to “GpsGate Server - How to setup and use”