Microsoft SQL Server and Transaction

Questions and answers regarding general SQL and backend databases

Microsoft SQL Server and Transaction

Postby marco.rossi » Mon Aug 28, 2017 10:16 pm

Hi all,

some years ago, there was danger in using the command databaseManager.startTransaction() on a SQLServer database:
if one person killed a servoy session while a transaction was open, the entire servoy server freeze and no one could work.

Can anyone tell me if this kind of issue is already fixed?

Best regards and thank you for your time.

Marco
Marco Rossi
Senior Analyst Developer
Freelance Consultant

IT Manager @Mantho
Webmaster @Sitoliquido
marco.rossi
 
Posts: 110
Joined: Sun Apr 12, 2015 9:33 pm

Re: Microsoft SQL Server and Transaction

Postby murmi » Wed Aug 30, 2017 8:54 am

Hi Marco
We had similar Problems with Transactions on a 2008/R2 Server. We issued
ALTER DATABASE DBName SET READ_COMMITTED_SNAPSHOT ON
ALTER DATABASE DBName SET ALLOW_SNAPSHOT_ISOLATION ON
on each Database and got rid of the problem. Everything works smooth since then.
Maybe it helps on your problem as well.

Fritz
Fritz Maurhofer
Maurhofer Informatik AG
CH-8340 Hinwil
murmi
 
Posts: 41
Joined: Thu Jul 22, 2010 5:10 pm

Re: Microsoft SQL Server and Transaction

Postby marco.rossi » Wed Aug 30, 2017 11:41 am

Hi Fritz,

we will try to adopt your solution.
Thanks for your answer and for your time.

Best regards

Marco Rossi
Marco Rossi
Senior Analyst Developer
Freelance Consultant

IT Manager @Mantho
Webmaster @Sitoliquido
marco.rossi
 
Posts: 110
Joined: Sun Apr 12, 2015 9:33 pm


Return to SQL Databases

Who is online

Users browsing this forum: Bing [Bot] and 3 guests

cron