Thanks Tara, and there just happens to be an article on using powershell to capture perfmon statistics in one of my emails this morning: http://www.simple-talk.com/sql/database-administration/gathering-perfmon-data-with-powershell/?utm_source=simpletalk&utm_medium=email-main&utm_content=Perfmon-20100712&utm_campaign=SQL

I totally agree. I should have said this is an OLTP system, not OLAP. Queue length and system waits are great performance metrics, but I'm looking for workload metrics....

Also determine that any UNIQUE indexes are not used by the application to avoid duplicates. Dropping the index could potentially allow duplicate values in the column(s) with less than...