问题描述
我有一些正在运行的 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 > 性能工具 > SQL Server Profiler for 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 中的查询分析器在哪里?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！