I think your real question is which database working best for repository.
For SQL Server, read the following
Other than that, there is not much difference.
When you run into performance issue, most likely it is caused by repository size, network traffic, available random access memory, etc.
This is especially true if you are using direct connect.
If you are using proxy server, you need add more cached memory for the server.
Add comment