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 |
|
chih
Posting Yak Master
154 Posts |
 Posted - 2009-06-02 : 21:26:27
|
| Hi everyone,In our company, some PC execute the SP and get the result in 3mns. Some PC execute the same SP but take more than 30 mins to get the result. I have checked the PC but CPU and memory usage is low.Any reason cause that?Thank you in advance |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-06-03 : 04:29:56
|
| No way to tell with the information provided:1) Same database?2) Same database server and only different clients? Or do the 2 'PC' run local db servers with different copies of the same database?3) Same LAN?4) Same parameters to the SP?5) Same time of day.Also -- what does the SP do? If it's no too big and not too sensitive you can post the SQL. Could well be it just isn't as efficient as it could be.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2009-06-03 : 10:18:41
|
| Use Profiler to see what's actually going on...there is no way a procedure varies by half an hour depending on which user is running it (unless there is logic related to the executing user of course).- Lumbago |
|
|
|
chih
Posting Yak Master
154 Posts |
Posted - 2009-06-03 : 19:11:46
|
Thank you for the reply.1) Same database? Yes2) Same database server and only different clients? Or do the 2 'PC' run local db servers with different copies of the same database?2PC connect to the same db server located in data center3) Same LAN?Yes4) Same parameters to the SP?No, after I check it, they have different exclusion conditions. I guess this is the reason. 5) Same time of day.Yesquote:
Originally posted by Transact Charlie
No way to tell with the information provided:1) Same database?2) Same database server and only different clients? Or do the 2 'PC' run local db servers with different copies of the same database?3) Same LAN?4) Same parameters to the SP?5) Same time of day.Also -- what does the SP do? If it's no too big and not too sensitive you can post the SQL. Could well be it just isn't as efficient as it could be.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION
|
|
|
|
|
|
|
SQL Performance issue on client PC