Segfault666
IS-IT--Management
On our Terminal server we have accountants and procurment people. These 'users' (i hate that word) always seem to want to run their invoices at the same times of the month.
The database is in Access so it's pittiful to begin with.
My problem is that when both of them run it, one takes ~100% of one CPU, and the other takes ~100% of the other CPU. The server usually carries about 20-25 people.
So now, in their infinite wisdom they both go about their individual tasks and suddenly, out of the blue, the server decideds that it's not going to respond. So they call me.
I happily tell them that they have successfully ground the server to a halt, pretty much holding up EVERYONE on the system becasue of how and what they are running. Then they have the nerve to complain that it's taking a few extra seconds to print an invoice after they see me shadown them and lower the priority and change affinity.
Soooooooo....
I know that you can use start.exe /low to start a process in low-priority mode, unfortunatley this isn't working to well for me.
I would like modify the shortcuts that start Access and make them all run in Low Priority Mode. How can this be done simply? When I use Start.exe, it runs the app but doesn't change priority; perhaps I'm doing something wrong. Dunno.
any comments / advice?
(Please don't say 'migrate to SQL', I would like to let you know that my dreams never come true).
So yea, thanks!
any advice would be greatly appreciated.
The database is in Access so it's pittiful to begin with.
My problem is that when both of them run it, one takes ~100% of one CPU, and the other takes ~100% of the other CPU. The server usually carries about 20-25 people.
So now, in their infinite wisdom they both go about their individual tasks and suddenly, out of the blue, the server decideds that it's not going to respond. So they call me.
I happily tell them that they have successfully ground the server to a halt, pretty much holding up EVERYONE on the system becasue of how and what they are running. Then they have the nerve to complain that it's taking a few extra seconds to print an invoice after they see me shadown them and lower the priority and change affinity.
Soooooooo....
I know that you can use start.exe /low to start a process in low-priority mode, unfortunatley this isn't working to well for me.
I would like modify the shortcuts that start Access and make them all run in Low Priority Mode. How can this be done simply? When I use Start.exe, it runs the app but doesn't change priority; perhaps I'm doing something wrong. Dunno.
any comments / advice?
(Please don't say 'migrate to SQL', I would like to let you know that my dreams never come true).
So yea, thanks!
any advice would be greatly appreciated.
