blocks|key|3884768|text|Sql+Server提供了一些优秀的工具来帮助您解决这种情况。这些工具内置于Management+Studio+(以前称为Enterprise+Manager+%2B+Query+Analyzer)中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3884769|使用SQL+Profiler向您显示来自web应用程序的实际查询。|3884770|复制每个问题查询(占用大量CPU时间或IO的查询)。使用"Display+Actual+Execution+Plan“运行查询。希望你能看到一些明显的索引缺失。|3884771|您还可以运行优化向导(按钮就在“显示实际执行计划”旁边。它将运行查询并提出建议。|3884772|通常，如果您已经有了索引，而查询运行速度仍然很慢，则需要以不同的方式重写查询。|3884773|将所有查询保存在存储过程中会使这项工作变得容易得多。|3884774|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|P|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|Q|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|R|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|S|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|M|$]]

Sql Server has some excellent tools to help you with this situation. These tools are built into Management Studio (which used to be called Enterprise Manager + Query Analyzer). 

Use SQL Profiler to show you the actual queries coming from the web application.

Copy each of the problem queries out (the ones that eat up lots of CPU time or IO). Run the queries with "Display Actual Execution Plan". Hopefully you will see some obvious index that is missing. 

You can also run the tuning wizard (the button is right next to "display actual execution plan". It will run the query and make suggestions.

Usually, if you already have indexes and queries are still running slow, you will need to re-write the queries in a different way.

Keeping all of your queries in stored procedures makes this job much easier.

blocks|key|5295438|text|若要分析SQL+Server，请使用SQL+Profiler。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|5295439|你可以从Red+Gate使用ANTS+Profiler来分析你的代码。|5295440|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/ms181091.aspx|1|http://www.red-gate.com/Products/ants_profiler/index.htm^0|I|C|0|0|E|D|1|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]]|C|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@$A|U|B|V|1|W]]|C|$]]|$1|F|3|-4|5|6|7|X|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]|N|$5|I|J|K|C|$L|O]]]]

To profile SQL Server, use the <a href="http://msdn.microsoft.com/en-us/library/ms181091.aspx" rel="nofollow noreferrer">SQL Profiler</a>.

And you can use <a href="http://www.red-gate.com/Products/ants_profiler/index.htm" rel="nofollow noreferrer">ANTS Profiler</a> from Red Gate to profile your code.

blocks|key|3884872|text|另一个与ASP.NET配合得很好的.NET分析器是dotTrace。我亲自使用过它，并在我的代码中发现了许多瓶颈。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3884873|entityMap|0|LINK|mutability|MUTABLE|url|http://www.jetbrains.com/profiler/^0|P|8|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Another .NET profiler which plays nicely with ASP.NET is <a href="http://www.jetbrains.com/profiler/" rel="nofollow noreferrer">dotTrace</a>. I have personally used it and found lots of bottlenecks in my code.

blocks|key|3039721|text|我相信你已经有了你需要的答案来分析这些查询。但是，这是性能调优中最简单的部分。一旦你知道是查询，而不是网络或应用程序，你如何找到并解决问题？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3039722|性能调优是一件复杂的事情。但有一些地方需要先看一看。你说你正在返回大量的数据？您返回的数据是否比所需的数据多？您真的只返回所需的列和记录吗？使用select+*返回100列可能比返回实际使用的5列要慢得多。|3039723|您的索引和统计数据是最新的吗？如果你有一段时间没有这样做了，看看如何在BOL中更新统计数据和重新建立索引。你对所有的连接字段都有索引吗？where子句中的字段如何呢？|3039724|你用过游标吗？你使用子查询了吗？联合如何-如果你正在使用它，它可以被更改为联合所有吗？|3039725|你的查询是sargable+(谷歌如果不熟悉这个术语的话。)|3039726|当你可以使用group+by时，你正在使用distinct吗？|3039727|你有锁吗？|3039728|还有许多其他的东西要看，这些只是一个开始。|3039729|entityMap^0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|V|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|W|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|X|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|Y|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|Q|$]]

I believe you have the answer you need to profile the queries. However, this is the easiest part of performance tuning. Once you know it is the queries and not the network or the app, how do you find and fix the problem?

Performance tuning is a complex thing. But there some places to look at first. You say you are returning lots of data? Are you returning more data than you need? Are you really returning only the columns and records you need? Returning 100 columns by using select * can be much slower than returning the 5 columns you are actually using. 

Are your indexes and statistics up-to-date? Look up how to update statisistcs and re-index in BOL if you haven't done this in a awhile. Do you have indexes on all the join fields? How about the fields in the where clause.

Have you used a cursor? Have you used subqueries? How about union-if you are using it can it be changed to union all?

Are your queries sargable (google if unfamiliar with the term.)

Are you using distinct when you could use group by?

Are you getting locks?

There are many other things to look at these are just a starting place.

blocks|key|5295650|text|如果有一个特定的查询或存储过程我想调优，我发现在查询之前打开统计信息非常有用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5295651|SET+STATISTICS+TIME+ON
SET+STATISTICS+IO+ON|code-block|syntax|javascript|5295652|在查询分析器中打开统计信息时，统计信息将显示在“结果”窗格的“消息”选项卡上。|5295653|IO统计数据对我特别有用，因为它让我知道是否需要索引。如果我从IO统计信息中看到较高的读取计数，我可能会尝试向受影响的表添加不同的索引。当我尝试索引时，我再次运行查询，以查看读取计数是否下降。经过几次迭代，我通常可以找到所涉及的表的最佳索引。|5295654|以下是这些统计命令的MSDN链接：|5295655|SET+STATISTICS+TIME|offset|length|5295656|SET+STATISTICS+IO|5295657|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/ms190287.aspx|1|http://msdn.microsoft.com/en-us/library/ms184361.aspx^0|0|0|0|0|0|0|J|0|0|0|H|1|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|13|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|14|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|15|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|16|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|17|8|@]|9|@$O|18|P|19|1|1A]]|A|$]]|$1|Q|3|R|5|6|7|1B|8|@]|9|@$O|1C|P|1D|1|1E]]|A|$]]|$1|S|3|-4|5|6|7|1F|8|@]|9|@]|A|$]]]|T|$U|$5|V|W|X|A|$Y|Z]]|10|$5|V|W|X|A|$Y|11]]]]

If there is a particular query or stored procedure I want to tune, I have found turning on statistics before the query to be very useful:

<pre><code>SET STATISTICS TIME ON
SET STATISTICS IO ON
</code></pre>

When you turn on statistics in Query Analyzer, the statistics are shown in the Messages tab of the Results pane.

IO statistics have been particularly useful for me, because it lets me know if I might need an index. If I see a high read count from the IO statistics, I might try adding different indexes to the affected tables. As I try an index, I run the query again to see if the read count has gone down. After a few iterations, I can usually find the best index(es) for the tables involved.

Here are links to MSDN for these statistics commands:

<a href="http://msdn.microsoft.com/en-us/library/ms190287.aspx" rel="nofollow noreferrer">SET STATISTICS TIME</a>

<a href="http://msdn.microsoft.com/en-us/library/ms184361.aspx" rel="nofollow noreferrer">SET STATISTICS IO</a>

How would one go about profiling a few queries that are being run from an ASP.NET application? There is some software where I work that runs extremely slow because of the database (I think). The tables have indexes but it still drags because it's working with so much data. How can I profile to see where I can make a few minor improvements that will hopefully lead to larger speed improvements?

Edit: I'd like to add that the webserver likes to timeout during these long queries.

Profiling SQL Server and/or ASP.NET

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云AI代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

功能1上新10个字符

功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符。

功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符。

功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符

功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符

功能4上新

文章&问答评论现已支持表情

全新交互，全新视觉，新增快捷键、悬浮工具栏、高亮块等功能并同时优化现有功能，全面提升创作效率和体验

社区富文本编辑器全新改版！诚邀体验～ 

精选全网热门MCP server，让你的AI更好用 🚀

💥开发者 MCP广场重磅上线！

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

如何分析从ASP.NET应用程序运行的几个查询？由于数据库的原因，我工作的一些软件运行速度非常慢(我认为)。表有索引，但它仍然拖拉，因为它正在处理如此多的数据。我如何分析，看看我可以在哪里做一些小的改进，希望能带来更大的速度提升？编辑:我想补充的是，在这些长查询期间，add服务器喜欢超时。

问分析SQL Server和/或ASP.NET
EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问分析SQL Server和/或ASP.NETEN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问分析SQL Server和/或ASP.NET
EN