CPU and Memory Usage: Connect and disconnect
Posted: Sat Feb 13, 2016 11:13 pm
I'm having problems with consumption of the CPU and the memory.
What of these options would help me to consume less?
Option #1
Connect to sql server, execute the sql command and disconnect once it is done. And do again for each command.
Option #2
Connect to sql server, execute all the sql commands and disconnect when script dies.
More ideas will be very appreciated.
Thank you
What of these options would help me to consume less?
Option #1
Connect to sql server, execute the sql command and disconnect once it is done. And do again for each command.
Option #2
Connect to sql server, execute all the sql commands and disconnect when script dies.
More ideas will be very appreciated.
Thank you