SQL Server Management Studio 2008 R2中的查询分析器在哪里? [英] Where is the Query Analyzer in SQL Server Management Studio 2008 R2?
问题描述
我正在运行一些SQL,并且需要很长时间才能在asp.net c#应用程序中返回结果/解析/显示等.
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.
我已安装SQL Server Management Studio 2008 R2以连接到远程SQL Server 2000计算机.是否可以使用查询分析器或分析器查看最新情况?我不确定是否发送了太多请求,请求花费的时间是否太长,是否可以添加其他索引来加快处理速度等等.
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.
有没有免费的工具可以替代Microsoft工具?
Any free tools out there that are replacements for the Microsoft tools?
推荐答案
默认位置:
程序> Microsoft SQL Server 2008 R2>用于查询分析器的SQL Server Management Studio. 程序> Microsoft SQL Server 2008 R2>性能工具>用于Profiler的SQL Server Profiler.
Programs > Microsoft SQL Server 2008 R2 > SQL Server Management Studio for Query Analyzer. Programs > Microsoft SQL Server 2008 R2 > Performance Tools > SQL Server Profiler for profiler.
这篇关于SQL Server Management Studio 2008 R2中的查询分析器在哪里?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!