December 21, 2010 at 2:51 pm
good afternoon
i have a question
usually 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 macine (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?
ILL APPRECIATE YOUR HELP
December 21, 2010 at 3:15 pm
pavargasq (12/21/2010)
good afternooni have a question
usually 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 macine (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?
ILL APPRECIATE YOUR HELP
No need to shout 😉
IMO your SSIS-app is loaded locally, i.e. where you launch the dtsrun to load the ssis-package from a certain file location or msdb.
So, that off load may be a gain for your server.
However does it out weigh the data volume network needs because of local caching ops ?
I've seen a couple of setups that use a dedicated sql instance for hosting only SSIS apps and run them using sqlagent or ad hoc alerts launching sqlagent jobs. Is that worth it ? It depends on what you expect for performance from that particular box.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply