title: Where is the Query Analyzer in SQL Server Management Studio 2008 R2?
body: <p>I have some SQL thats getting run and it is taking to long to return the results / parse / display, etc. in a asp.net c# application.</p>
  
  <p>I have SQL Server Management Studio 2008 R2 installed to connect to a remote SQL Server 2000 machine. Is there a Query Analyzer or profiler I can use to see whats going on? I'm not sure if I'm sending too many requests, if the requests are taking too long, if there are additional indexes I can add to speed things up etc.</p>
  
  <p>EDIT:</p>
  
  <p>Any free tools out there that are replacements for the Microsoft tools?</p>