Sql – How to you get database specific performance metrics for things like CPU/Memory/etc. in SQL Server 2005


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.

I would like some way to get these performance metrics so that I can rule out the database hardware as the culprit.

Best Solution

I just read a great article on using windows built in typeperf.exe for just this issue. http://www.mssqltips.com/tip.asp?tip=1575