Viewing 4 posts - 1 through 4 (of 4 total)
Thanks. I carried out a full index rebuild and updated statistics for the main database on the server and that seems to have helped the issue a bit. During Christmas...
January 9, 2017 at 1:17 am
Yes - the job has gone from 4 - 10 hours (there are number of update queries called via a stored procedure). Queries that normally completed in a short period...
January 6, 2017 at 6:24 am
We have overnight jobs on this server that update a data warehouse. I noticed the job time had jumped from around 4 hours to 10 hours without anything changing as...
January 6, 2017 at 5:06 am
I've uploaded the xml query plan. Not sure how useful it will be as pretty up every query that requires parallelism is having an issue.
January 6, 2017 at 4:41 am