This is such a broad topic, and most of the DMV's work together to give you a better insight into performance problems. The Microsoft whitepaper "Troubleshooting Performance Problems in SQL Server 2008" is a good source. http://msdn.microsoft.com/en-us/library/dd672789(v=sql.100).aspx