It's a standard phrase that means that you have a guest and, at first, all goes well. You're happy to have her until she turns into a slob, doesn't pay for any groceries and brings strange men home at night!

You originally welcomed her but now her visit has become tiresome and she is "wearing out" her welcome (you are "wearing out", essentially, and must ask her to leave).