I like the name well enough, but it's a one-owner name and ludicrous on a small child. If I met one, I'd look around for his brother Mycroft, and I'd speculate that the parents were probably the kind of sad people who write fan letters to 221b Baker St.
That said,
Sherlock and Mycroft would be totally brilliant names for a pair of bloodhounds!