title: How can you get database specific performance metrics for things like CPU/Memory/etc. in SQL Server 2005?
body: <p>I have a couple databases on a shared SQL Server 2005 cluster instance, that I would like performance metrics on. I have some processes that run for a very long time and suspect that code inefficiencies, rather than insufficient hardware are to blame.</p>
  
  <p>I would like some way to get these performance metrics so that I can rule out the database hardware as the culprit.</p>