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 |
|
priyankchouksey
Starting Member
3 Posts |
 Posted - 2004-12-18 : 06:19:44
|
| WE use VB as front end for our SQL server.Our procedure takes less then a second to execute when we call it from VB. But the Same Exe Takes 20 seconds at client end.We tried to see if there is network problem, So we executed a Simple query which took 3 secondes at both ends. that means there is no problem with SQL. but the variation in response time at client end and ours.(We use system DSN to connect to DB)Please let me know if some one faced the same problem. |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-12-18 : 15:31:23
|
| How big is the recordset you're returning to the client? Are you doing a lot of formatting with it after?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
priyankchouksey
Starting Member
3 Posts |
Posted - 2004-12-19 : 23:49:06
|
| We are not returning any recordset from the sp. what we do is passing XML string to the sp and on the basis of IDs in XML string, we insert update or delete from table, in this stored procedure. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-12-20 : 00:05:51
|
| Same question applies. How big is the XML string. You need to figure out how much time it actually takes to reach the server in a completed state. Then, how long is the execution of the proc itself. During this time, what do the the network, disk read queue, and disk write queue lengths look like on both the client and SQL Server? Track the query at the same time in Profiler to see if the actual execute time varies between different clients.Is this a stored procedure, or inline code? I would assume a stored procedure from your first post.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
priyankchouksey
Starting Member
3 Posts |
Posted - 2004-12-20 : 00:11:00
|
| Is there any way (Like SQL Debugger) to find out how much time has been taken by a SQL statement, in the sp. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-12-20 : 00:15:49
|
| Profiler. You would use the SP:Stmt Completed action.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
|
|
Response Time