Whilst high level tools such as Windows Perfmon can give you an overview of server performance and Waitstats can provide you with an insight into where bottlenecks are occuring within the database engine, seeking out the source of most SQL Server performance