Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dos_net_pass
Starting Member
3 Posts |
 Posted - 2009-09-08 : 11:09:43
|
| I have a situation where users are indicating that Report rendering within a client application has slowed from 1-2 seconds to 15 - 20 seconds. Usign the SL profiler I have traced the calls to the database and in all cases the duration values are small ( < 30 ). If I use Query Analyzer to run the queries involved they all run fast and with the same Profiler duration results. The client application is run via Remote Desktop from a users PC.The SQL Profiler results appear to indicate that the issue is not with SQL Server but with the client application and/or the network connection. Does anyone have any pointers to what I should look at to try and narrow down where the problem lies? Perfmon counters, connection settings?Thanks |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2009-09-08 : 16:15:19
|
| I think that the first question that needs to be answered is, "Where is the problem?" Is this a SQL issue, a network issue, an application issue or a report rendering issue?From what you have presented, it looks like it is not a SQL issue per se. Can you gather some tracing data at the application level? What I'd like to know is where is the time being spent. Does the SQL (stored procedure?) return to the application within the expected time? If it does, then the problem lies downstream. If not, then you need to resolve why Profiler is showing a standard execution time but the applicatiohn is still held up.People have recommended the ANTS product as an application side profiling tool.HTH=======================================Men build too many walls and not enough bridges. -Isaac Newton, philosopher and mathematician (1642-1727) |
 |
|
|
|
|
|
App performance slow, profiler duration low