db tuning done? name index enabled?
that's lots of users for only 5000 machines - I hope you don't have huge userlists per machine?
Unluckyly we have lots of users.
Base about 2k caused by a early design flaw.
Later on we add about 30 to newer clients.
Some clients need to accept about 200 in top for department interoperability reasons.
Wasnt my decision, but we had no alternative.
Not shure about the Performache and Index.
Will check that tomorrow at office - i didnt build up the system.
My conclusion of your answer ist :
System is reaching its capacity limits, right ?
Soon there will be 10k+ 18k Machines on top..
User ammount will increase about 10k to 30k till final Infrastructure.
Scary, but it has to be done.
I would have chosen a FullSizeBlade with Dual Quadcore and 32 GB Ram with mezzanine Boards (SSD-Like) for DB @Win2k3.
But reality is that what has to be handled...
you current machine is good for what you are using it for - probably up to 10k machines etc. I expect some of the performance steps were skipped.
Il chek out tomorrow and give feedback!
Thanks a lot!
At Least hardware seems sufficient!
At least we brought service outages down to 2-3 a day from 5 to 8 the last days by stopping some connectors,schedules and exports.
Ill refer to :
First of all check all recommendations from best practices guide. It explains how to enable index cache also.
Monitor CPU usage but also disk idle %. Limit number of concurrent administrative (EEM) sessions. Maintain your database.
All described in the best practices did the Job and Server works perfectly now.
Reliability will get measurable next week, but system works good.
Started all Import Jobs at once and system worked properly.
Will move on to "database maintainance".
maybe one day I'll write a wizard to check and apply those things for people...