MyDoggieJessie (4/6/2011)
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.
Any thoughts?
I don't think it will have an impact. This is a protocol and you were seeing memory pressure according to the waits if memory serves correctly.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events