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 |
|
alejo46
Posting Yak Master
157 Posts |
 Posted - 2010-12-21 : 16:56:31
|
| good afternooni have a questionusually processes,likE DTS, or procedures are run in the application server NAMED ie SERVER1, USING REMOTE DESKTOP AND RUN THE PROCESSES USING SSMO.SSMO is also installed in my local machine (PC).The question is if there is any difference running tho procedure in the local machine or in the server SERVER1 BECAUSE THEY ARE POINTING TO THE SAME DATABASE?THE RESOURCES USED FOR BOTH SITUATIONS ARE DIFFERENT?, I MEAN when i run the procedure ussing SSMO locally (PC). am i using the pc resources instead of SERVER1?, in any case, does it affect performance?ILL APPRECIATE YOUR HELP |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2010-12-21 : 18:21:33
|
| If you are calling a stored procedure that lives in a database on a server, that server is doing all the work. If you are returning a million rows, that could eat up your local.JimEveryday I learn something that somebody else already knew |
 |
|
|
|
|
|
ruunng a process in a PC or in the server