Would there be any performance benefit to disabling the Shared Memory Protocol?
We have a server that executes some rather large queries then pulls the data back to it via a linked server (I know, not such a good idea but that's what we're stuck with). This process has run fairly well for years but as of a few days ago became "extremely slow"...my gut feeling tells me we've just hit a tipping point in the sheer volume of data we're querying, then pulling back through the pipe.
I've read a bit online about the different types of protocols but am unclear if there's any performance boost to changing anything.
Never argue with an idiot; Theyll drag you down to their level and beat you with experience