and...

Post #70,035 by slugbug 12/19/02 9:00:50 PM Reply	and... before turning on auto-tuner: wrkshrpool is everything running out of *base and is there adequate min/max for the pool? or, is the db activity running in a shared pool? you can see where it is running by doing: wrkactjob F11 look for the pool ID you might also run idoctor against the system to get a clearer understanding of where the performance troubles are coming from. also, are you using toolkit or native driver for sql access? this can impact performance too. as for processors, there are 400 models that have single processor (maybe this is a 270?) as well as models that exceed 20+ processors. -slugbug
Post #70,040 by imric 12/19/02 9:18:08 PM Reply	smile Trust you to be more thorough than I! Imric's Tips for Living Paranoia Is a Survival Trait Pessimists are never disappointed - but sometimes, if they are very lucky, they can be pleasantly surprised... Even though everyone is out to get you, it doesn't matter unless you let them win.
Post #70,139 by mmoffitt 12/20/02 3:15:55 PM Reply	Thank you. I will see if they let me check any of that the next time I'm in. Appreciate your efforts and suggestions. Knowing these guys, I should have prefaced my initial post with "I understand that any host is only as good as its Admin, but, ..." ;-) This is all stuff they know to do, I suppose. But I'd bet not. BTW, a friend of mine that works there just pinged me. He ran a Crystal Report based on a single query with one join. It was some numbers grouped by week over 3 months. The report took 19 hours to run. Now, I know his Sql could be really bad, but 19 hours? <:-O

Welcome to IWETHEY!