Hi All,
I am looking for a guide to tune the siebel analytics server configuration. I have gone through the Siebel bookshelf and Siebel support web to find some material but no success. I have found some parameter, which can improve or slow down the server performance. BUT, I dont find a answers to my following question.
What is the range of values for each parameters?
What is the threshold for each parameters?
When we should tune those parameters? (I mean, we should change the value of parameter 'X' when we see certain behavior)
The problem is for 'N' number of users i am getting good performance (only 8% of transactions have response time > 5 sec. ); But for '2N' number of users the performance gets worst (85% of transaction have response time > 5 sec.). Both test were run with analytics cache enabled. we are not using the separate HDD for analytics cache. What i see is during the '2N' user load test there is considerable increase in following performance counters in analytics application server
Disk Time
pages/sec (Hard page fault)
CPU%
I believe if the report queries are written badly or DB is not configured properly, than the transaction response time difference with increase no of users can not have drastic change of 8% to 85%. Please correct me if i am wrong.
Other interesting thing is there is 300-400 MB of ram is available and still we see DiskTime of (110%) in 2N user load and hard page fault (pages/sec) increase from 20 to 140. I believe that hard page faults should occur when there is a lack of RAM which is not the case here. Looks like analytics is configured to use only certain amount of RAM.
I will appreciate if some can share their experience with tuning the siebel analytics server configuration.
Thanks
-Nilesh
I am looking for a guide to tune the siebel analytics server configuration. I have gone through the Siebel bookshelf and Siebel support web to find some material but no success. I have found some parameter, which can improve or slow down the server performance. BUT, I dont find a answers to my following question.
What is the range of values for each parameters?
What is the threshold for each parameters?
When we should tune those parameters? (I mean, we should change the value of parameter 'X' when we see certain behavior)
The problem is for 'N' number of users i am getting good performance (only 8% of transactions have response time > 5 sec. ); But for '2N' number of users the performance gets worst (85% of transaction have response time > 5 sec.). Both test were run with analytics cache enabled. we are not using the separate HDD for analytics cache. What i see is during the '2N' user load test there is considerable increase in following performance counters in analytics application server
Disk Time
pages/sec (Hard page fault)
CPU%
I believe if the report queries are written badly or DB is not configured properly, than the transaction response time difference with increase no of users can not have drastic change of 8% to 85%. Please correct me if i am wrong.
Other interesting thing is there is 300-400 MB of ram is available and still we see DiskTime of (110%) in 2N user load and hard page fault (pages/sec) increase from 20 to 140. I believe that hard page faults should occur when there is a lack of RAM which is not the case here. Looks like analytics is configured to use only certain amount of RAM.
I will appreciate if some can share their experience with tuning the siebel analytics server configuration.
Thanks
-Nilesh