Windows Server 2003 DB2 9.5 8 gig memory - 300 gb of SAN disk.
DB2 set up with automatic storage option.
A Database with 5 Schemas holding many tables. Around 150 gig of data spread over the 5 Schemas.
An outside source will acccess one schema to read data using ODBC connection.
Processing on the database will be inserting and updating to 4 schemas and creating and inserting data into tables in the Schema
for reading by the outside source.
How do you monitor the performance impact of the outside source reading the schema tables?
Would it be best to only allow the outside source reading when all inserting and updating on other schemas complete or would a
seperate Database be better?
Any other suggestions to lessen impact or improve performance - no money to improve hardware configuraton?
A 32bit instance means that 4 of your 8 GB of RAM is wasted. It cannot be addressed at all. And since windows will take up about half of the remaining 4, you have only 2 GB of usable memory. That could be a performance problem.
What I meant by "How are the accessing the data" is if they were writing adhoc queries or are using some application or such with predefined queries. That is why I asked the second question.
Since they are writing their own queries, you are basically at their mercy. If they write a totally horrendous query, you will have to suffer while it executes.