December 7, 2018 at 2:01 pm
Ok I have a 2016 ent edition 128 gig of RAM 8 core. Have a 3rd party oltp app that also has some integration (SSIS, Biztalk) tied into it. THere are some problems with some of the SSIS and Biztalk that kill the server for a few minutes but what I deal with directly after that is blocking with the 3rd party app for a few minutes. Does not happen any other time. In fact what is odd is some of the query plans for the OLTP seem to be an issue (too many reads etc) and then it goes away. (ANd yes stats and indexes are good) ANy other setting I may need to deal with to help. I have Maxdop at 0 (dont see a lot of cxpackets)
December 10, 2018 at 5:00 am
There are times the queries take bad plan if the IN parameter datatypes does not match the table definition. Do you have any control over the code in the OLTP server? If so you could make the necessary changes.
-Roy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply