1

I have an assignment to tune a poorly performing query running on a SQL 2005 database. I have SQL 2008 management tools installed on my workstation. Can I use some of the new query tuning tools in 2008 like the data collector and system data collection sets to help analyze and tune this guy?

Matt Ball
  • 354,903
  • 100
  • 647
  • 710
Jim Evans
  • 6,285
  • 10
  • 37
  • 60

1 Answers1

0

No, I don't believe so.

http://msdn.microsoft.com/en-us/library/bb677248.aspx

You can see the only versions listed are 2008, R2 and Denali.

Sam
  • 7,543
  • 7
  • 48
  • 62
  • From what I remember, those tools would help you get a picture of the server and find poorly performing queries. Maybe I'm wrong. Thankfully SQL 2005 has dynamic management views which should help you quite a bit when tunign. – Sam Apr 05 '11 at 15:35