We had a sleep number bed for many years. I liked it at first since DH and I could adjust our own sides. He likes a softer mattress and I like mine more on the firm side. The last few years we had it, my side didn't seem to hold my setting all night. I would set it at 75 and wake up with a horrible backache. During some nights, the mattress would lose air and the setting would be down to like 25. Other nights it would go up and in the morning it would be 100. Since it gained air as often as it lost it, I don't think it had a leak. It just wouldn't consistently hold the number I set. DH never seemed to have an issue with his side.
A couple years ago, we ditched the sleep number and got a regular mattress with an adjustable base. We can adjust the head and foot of the bed up and down. We love it. It's so much more comfortable and easier to get just the right setting.