Raleigh police are investigating the death of a woman whose body was found on the grounds of Sacred Heart Cathedral Tuesday morning.