Use extreme prejudice when and where you run DBCC FREEPROCCACHE! SQL Books Online sums this up quite nicely:

Use DBCC FREEPROCCACHE to clear the plan cache carefully. Freeing the plan...

Thanks to all the folks who made comments and helped clear up the same questions I had. And thanks Rudy - good to know that mucking about with these...

Neil,

Awesome code - thanks! Still trying to get my head around it - lol.

A suggestion: I was looking for a way to get the manager's name as well as...

Joe Celko is one of the top authority in all things SQL - not just SQL Server - SQL! Newbie you are.

Yep - you're preaching to the choir.

I spoke too soon - try this instead: http://blogs.msdn.com/b/vascov/archive/2008/09/30/using-performance-dashboard-with-sql-server-2008.aspx

I'm a complete neophyte with DMVs - any additional insight would be gladly welcomed!

Mike

In your proc GetProcessorUsage, you're referring to a column 'cpu_ticks_in_ms' which doesn't exist in sys.dm_os_sys_info in SQL 2008 - http://msdn.microsoft.com/en-us/library/ms175048.aspx

According to this article, the column has been removed...

Back to the original statement of "... you shouldn't have installed all that for an evaluation edition" - why not? Isn't that why we have evaluation editions: to see...

A bowl of M&M's with all the browns removed, maybe?

Hyperbaric chamber!!! Oh, that's bad 🙂

Franky, thanks for your reply - your suggestions helped get me on the right track.. See my reply to Peter to see what I came up with.

Regards, Mike

Peter, thanks for your reply; here's what I ended up doing:

1 - In the data flow task, I created a data flow source that pointed to the DB2 database

2 -...