Application "hangs" after some time without work

Examine the cause of this problem?

Disable the data access layer of your application and check if it still happens.

When not, use SQL Profiler to see, whether it is cause to a lock on SQL Server.

btw, for a POS system you need to carfully design your database and the access strategy to avoid locks in the first place.

How is it possible to avoid this problem.

The one million dollar question!
There's no direct answer for that. It's like if your car just suddenly stopped. And why it stopped? No more gasoline? Electrical problem? Are you breaking the car? The engine blew?

You need to check first, right?
You can start to check for errors in the machine and in the SQL Server. You can also start a SQL Profiler to capture the T-SQL statements to know where it stopped. You can start a SSMS session and check there for locking processes.
And these are only some tasks for start.

But the application is fast in continued operation, save and print less 2 seconds. The problem is when no one works in pos in intervals 10 minutes or longer.

best regards

The problem is when no one works in pos in intervals 10 minutes or longer.

Check if there's any antivirus running on the server. Usually they are configured to run when there's no activity.
Also check for SQL Server jobs running during the less performance periods.

Hi,

In fact is in autoclose mode. I changed to false and is more fast no doubt. Will any implications for example for a single POS to have this option to false.

best regards

Well, how can we tell.. Is the database local to your POS?

Setting auto-close to false, means that your SQL Server instance while accquire and hold resources for your POS database, even when your primary POS application is not running.

So when it's on the local POS client, then this may add with other external factors to a resource shortage.

Hi,

Except some sporadic access to the Internet, usually the only application installed just only POS. And in this case no aditional machines "share" database.

best regards

So, it should work. Just check how many memory you have granted to your SQL Server instance. I would limit this value.

Hi,

For a 2 Gb Machine which recommended value?

best regards

How big is your database? But I would start with 1GB max.

Please change the marked answer. It was clearly the  auto-close option.