0

I am working on a poory designed application, so please do not judge me by the work i have been posed. I have servers table whose data can be visualised as enter image description here

and attributes table which can be described as

enter image description here

and attribute_server table which can be described as

enter image description here

Now the question and scenario is what to do if the attribute has multiple types meaning, meaning a disk has its own set of types per server, and as well a cpu has multiple set of types per server, and as well multiple set of critical and warning threshold per disk attribute, per memory attribute, per cpu attribute, any idea fellas?

  • If you must stay with the schema, could you add more unique attributes? Is each supposed to map to a perfmon counter? – Jacob H Feb 5 at 15:16
  • sorry about the less knowledge but what is perfmon counter? – Ravi Feb 5 at 15:29
  • Sorry, Windows Performance Monitor (or the Resource Monitor too). That isn't really relevant unless these are actual recordings from those tools. But the concept is the same. My point was, to make the more unique attributes so that you can distinguish between your data points. – Jacob H Feb 5 at 15:38
  • Your attribute_server table has room for multiple disks per server. (So, I don't understand what the problem is.) – Rick James Feb 5 at 17:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.