A woman has been stabbed to death in an affluent suburb, and the alleged offender remains in hospital under police guard.