工具名称我可以分析哪些Web应用程序或Sql Server可能很慢 [英] Tool Name Where I Can Analyse The Which Can Be Web Application Or Sql Server Is Slow

问题描述

你好，







i开发的网络应用程序但是当多个用户登录时它正在工作

很慢。



i检查我的程序花了11秒然后需要花多少时间

从sql server到web应用程序。





i想知道哪些工具可以找到哪些东西需要时间

从sql server加载并绑定数据到web应用程序

hello,



i developed web application but when multiple user is login then it is working
very slow.

i check my PROCEDURE it is taking 11 sec then how much time it will take
from sql server to web application .


i want to know any tool where i can find which thing is taking time
to load and bind data from sql server to web application

推荐答案

我会从 SQL事件探查器 [ ^ ]并查看数据库端是否是瓶颈，如果是，为什么。此工具可帮助您找到花费太多时间的语句。请参阅Profiler任务中的各个主题以了解更多如何使用它。

I would start with SQL Profiler[^] and see if the database side is the bottleneck and if it is, why. This tool helps you to locate the statement or statements that take too much time. See the individual topics in Profiler Tasks to learn more how to use it.

这篇关于工具名称我可以分析哪些Web应用程序或Sql Server可能很慢的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！