We are using SQL Anywhere v12.01.3810.
We have some large postings that run for about 4 hours (Day End type postings) that we schedule to run at Midnight each night. We also have a shift of workers that are doing transactional type work (small queries / update / insert statements) at the same time. The problem we have is that some of the postings are very intensive and are causing performance issues for the other workers.
What are your suggestions in this case?
I have tried setting priority of posting user to Low (SET OPTION "Admin"."priority" = 'Low';) and our transactional user to Critical. I am going to change priority of our "Admin" user to Background to see if that will make a difference.
Thanks for any suggestions.
asked 10 Jul '13, 10:00