How many custom properties can be added to a node? Is there a limit on it? How many can we add before it brings down the performance ?
Custom properties don't do anything by themselves. They are just another column added to a database table.So the only direct impact of adding custom properties is more database space is needed to store this field for every node/volume/interface (whichever the property is added to).
As such, the number that can be added is limited only by the DB size limitations of the server.
The only performance concern I can envision is how many alerts are being created to reference those custom properties, and how often do those alerts run.
the custom properties which I am going to add, doesn't get referenced in any alerting.
But, we are referring to a few custom properties for all alerts as our custom property only will be containing the assignment group information.
I'd say add away.
It sounds like you're not adding any additional workload - just adding more info that is no different than node name or IP address, machine type, etc. as far as the application is concerned.