Slow Issue

奋斗1314 · 发表于 14-4-2011 03:42 PM

我想问这里的高手们，有什么方法check为什么application process anything will slow??

我通常是用sp_who2 'active' to check it, but after that don't know what should i do.

请各位高手们帮帮忙。。

aiklee10 · 发表于 15-4-2011 10:58 PM

window slow + ram then reboot ^^

soonyu · 发表于 19-4-2011 11:51 AM

Another tools- >SQL Profiler
SQL Server -> Performance- > SQL Server profiler
Connect to server we want to monitor
Choose event - RPC

omplete, TSQL:SQL:BatchCompleted
Column filter -> Duration -> Greater than or equal 3000 (10000 = 10 second)
Run and execute the application which run slow
Get the SQL query from SQL Profiler and check the sql query

奋斗1314 · 发表于 22-4-2011 11:52 AM

回复 3# soonyu

Thank for your reply. After i get the SQL query what should i do?
I have view the query but it seem like no any problem besides that i aslo try to run in SQL Analyze but it take a few second to complete it.

		自动登录	找回密码
密码			注册

Slow Issue

所属分类: 电脑手机