Solaris

Guys where can i find values to add in /etc/system to make sun solaris 10 working better ? im sure there is alot of values but i dont know from where i can find them if you know any please send direct and if you know another sites send links to it, thanks so much.

Actually, there are not that many, because many of the old ones have been retired. Using /etc/system is not longer the "correct" way to tune things.

Leaving that aside you need the kernel tunable parameters document from the SA collection in the Solaris documentation.

The best way to tune a server/database/application for best performance is to reach acceptable performance requirement without tunning it.
This means that the configuration and setup is correctly done by using the default setting.

Any additional tuning often ends up giving up something else (E.g. performance/administrative/manageability/availability) in return of something else.

If a benefit can be gained with no expense of other stuff, the developer of the software would have gladly put it in the 1st place. (E.g. New features like sizing the buffers for IO/network are targeted for guru end-users to use them and report the bugs so that they can fix/stablize the new feature and set them as the default for best release so that the reminaing end-users dun have to tune it)

Of course there are exceptions there you would gladly trade in item X for item Y. But you have to know what is that item Y you want (E.g. Fast network performance for large data transfer).

There is no golden setting like: fast = yes.
If there is such a setting, all the vendor will put this as the default and the users need not set it.

That is not always possible. There are many applications that require the system to be 'tuned' in order to run correctly. It is not at all uncommon for example for a process to need to open more file descriptors than are allowed by default.

A default system is often tuned, like a car, to give reasonable all-round performance. It is entirely possible that there may be certain setting which can drastically alter that performance of a certain area without major overhead to other processes.

Also many settings an appilcation designer/coder would like to use may require special priveleges and although they may be updated by root, the application may be running as, and be require to run as, an unprievleged user.

Also as a futher point the correct way of tuning system parameters in Solaris 10 is *very* different from previous releases and in order to implement the same recommended settings this information is needed.

In a single purpose server there can be a "golden" setting or settings, and the system should be tuned appropriately.

You are right to say that, "There are many applications that require the system to be 'tuned' in order to run correctly."

In those cases, I prefer to call that configuration setup instead of 'tuning' the server because it cannot function properly without such settings:
Some examples that fall under this category are semaphore settings for Oracle, File descriptor handler for Application Server.

And there are others recommended settings like:
scsi queue for EMC storage, maxphys for solaris max io size, vxio:vol_maxio for VxVM max io size. I reckon these are the "golden" settings you are talking about here.

As for me, I would prefer to benchmark all these 'golden' settings during the UAT after implementation. If these are left out accidentally, it guess it is not going to break the application. Based on my experience from my implementation and benchmark, it will only improve the performance by <=10%. Not much to rave about.

Your statement, "In a single purpose server there can be a "golden" setting or settings, and the system should be tuned appropriately." is right to certain extent, but I will prefer to put it as, "In a single purpose server there can be a "golden" setting or settings, and the system can be tuned to meet the user expectation/requirement."

http://searchoracle.techtarget.com/q...075628,00.html

It's not oly true of single purpose servers, and whether you like to admit or not even changing parameters to required settings are tuning measures, by virtue of the fact that they make use of kernel tunable parameters, in the same way that if I use the presets on my radio I'm still tuning to the station I want to listen to, even it someone else programmed for it into my radio for me.