Simple Database Question

End users expect their queries to return results as quickly as possible. How do you know that performance of a database is good? What are some tools that can measure performance and provide an in-depth look in to trouble areas? Please provide at least 1 tool you find and explain what it does and what it provides to assist with database and query tuning.