SQL Anywhere database - sqla5505 concurrent data access issues

Author

sqla5505 concurrent data access issues

luke goodfellow

2005-05-26, 3:23 am

hi all,

having some performance issues running a dbsrv50.exe database engine. when
we run a large database function on one database, the engine is becoming
unresponsive to other clients working in other databases. (e.g. running a
process in database payroll1 below, and users accessing payroll2, billing1,
billing2 are effectively 'locked out' of the system while the process
completes).

first question:
are there any environmental/database options which will make the system more
multi-database friendly?

second question:
does sqla version 9 do all this much better?

engine environment & details:
- server is a twin processor machine running Windows Server 2003
- database server engine (dbsrv50.exe) startline
dbsrv50 -c512m -xtcpip -nserver
o:\database\payroll1
\database.db -npayroll1
o:\database\payroll2
\database.db -npayroll2
o:\database\billing1
\database.db -nbilling1
o:\database\billing2
\database.db -nbilling2
- each database.db file is between 100Mb and 400Mb is size

Breck Carter [TeamSybase]

2005-05-26, 7:23 am

Try this:

SET TEMPORARY OPTION BACKGROUND_PRIORITY = 'OFF';

Version 9 is much faster than version 5.

Breck

On 25 May 2005 21:23:42 -0700, "luke goodfellow"
<luke. goodfellow@caresyste
ms.com.au> wrote:

>hi all,
>
>having some performance issues running a dbsrv50.exe database engine. when
>we run a large database function on one database, the engine is becoming
>unresponsive to other clients working in other databases. (e.g. running a
>process in database payroll1 below, and users accessing payroll2, billing1,
>billing2 are effectively 'locked out' of the system while the process
>completes).
>
>first question:
>are there any environmental/database options which will make the system more
>multi-database friendly?
>
>second question:
>does sqla version 9 do all this much better?
>
>
>
>engine environment & details:
>- server is a twin processor machine running Windows Server 2003
>- database server engine (dbsrv50.exe) startline
> dbsrv50 -c512m -xtcpip -nserver
> o:\database\payroll1
\database.db -npayroll1
> o:\database\payroll2
\database.db -npayroll2
> o:\database\billing1
\database.db -nbilling1
> o:\database\billing2
\database.db -nbilling2
>- each database.db file is between 100Mb and 400Mb is size
>

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

Sponsored Links