Chloe's part Dachshund and honestly she's (IMO) the perfect dog! She is ready to get up and go, play, have fun, and is just as happy to hang around the house doing nothing. She is older and we got her as an adult though, so she may have been a little less willing to settle when she was younger, I don't know.
She's perfectly housebroken, has only had a handful of accidents since the day we got her 3 or 4 years ago, and all were for understandable reasons (sick/moved to a new house/etc).
She's never ever been snappy or aggressive. She's AWESOME with kids, and is very tolerant. She has been put through the ringer a few times with crazy kid guests, and has always been very tolerant. If she really wants to get away, she will run to my lap or hide under our bed (only happens when the kids are just persistently annoying and rough, otherwise she LOVES kids.
She's good with other dogs of all kinds, and is "livable" with small animals. She will leave them alone if you are in the room, and keeping an eye on her, but I wouldn't trust her alone in a room with a caged hamster/rabbit/guinea pig/etc. She's been around cats before and likes to chase them, but she really couldn't hurt one, they are twice her size.
She isn't yappy, but she will alert bark, and does like to run up and down the fence line and bark at/with the neighbors Weimaraner, and can get barky when playing with other dogs/when excited.
She is a great all around dog, not nervous-y or aggressive like some of the BYB dachshunds (of course she's gotta be the product of one, or an irresponsible owner). She DEFINITELY isn't fearful in any sense of the word. Nothing phases her.
I will say however that she fixates on food, and will stare at it and shake. She's obsessed with eating and will literally eat until her body is bloated and she can hardly walk. But I think it's a result of being underfed/living in a shelter for 3 months/etc. She was skin and bones when we got her. She could stand to lose a pound or so now, but is pretty healthy. We just have to limit what she eats because she has gotten onto the table before and eaten SO much that I actually thought I'd need to take her to the vet. Her stomach was 3x it's normal size and she could hardly walk. But the next morning she was back to normal, it was freaky.
Other than that though, she really doesn't have any issues at all. She's a sweet snuggly girl and I love her to death.
ETA: As far as agility goes, I bet she could do it, but she has much longer legs than most dachshunds because she is part Chihuahua. She loves to jump and will turn into pogo-dog when she's excited lol! She can jump into my arms from the floor if I'm standing! It's crazy.