Hi, after install a new SQL Server 2017 and SambaPOS on Windows 10. Checking the reports, I found out that Cost Report and others just showing Preparing Cost Report, and it took forever to complete.
I wonder if it is related to my SQL Server component which I picked when setup. I only chose to install Database Engine Services.
It supposed to be the default Today report. It took unusual long to prepare a report probably around 20 minutes to 30 minutes, during such a long time, you won’t know if there’s anything wrong going on.
However, as long as the report showed, other reports worked smoothly until next work period (usually). The next morning, I have to wait for preparing reports again.
As I told you, after finish that preparing step, all the reports are as quick as it should be until the next day. When I told you 20 to 30 minutes, I tried to make the number as small as possible. It probably took me a whole morning to finish preparing.
So sorry for the misinformation about database size ealier. 500 MB meant to be the database bakup size. The real size is 40 GB now when I check directly with SQL Server Management Studio.