Viewing 15 posts - 31 through 45 (of 275 total)
no maintenance jobs were running but there are 60-some-odd applications running on this server and some do overnight processing, batch loadings etc. . i don't have any direct visibility on...
October 28, 2016 at 7:17 am
thanks guys. fortunately, i have the opportunity to make a test with our QA system first. i'll try the plan suggested by Alex and see how it works. ...
October 17, 2016 at 9:13 am
For my issue, i think the problem was related to the CHECKDB running out of disk space for the snapshot. we increased the disk space sometime around the time...
September 13, 2016 at 5:53 am
Brandie Tarvin (8/18/2016)
Does that make sense?
absolutely! Thanks a lot.
August 18, 2016 at 7:41 am
Perry Whittle (8/17/2016)
JarJar (8/17/2016)
August 18, 2016 at 1:42 am
Grant Fritchey (8/17/2016)
JarJar (8/17/2016)
...i've added missing indexes for all the joins possible...
based on an evaluation of the execution plans to understand where indexes are needed... I hope. Not just...
August 18, 2016 at 1:33 am
thanks guys. the deadlocks are occurring on the local server. the table is very frequently updated depending on user activity (it's a logging table). i've added missing indexes...
August 17, 2016 at 2:59 am
thanks again guys. the developers have found a workaround for the cross join. we're going to give it another try.
but there is something strange going on right now...
July 19, 2016 at 2:05 am
Jeff Moden (7/18/2016)
JarJar (7/18/2016)
July 18, 2016 at 8:15 am
additionally, getting rid of the column name and --------- in the output so that i only have the drop statements would be a bonus.
July 14, 2016 at 5:44 am
BLOB_EATER (7/5/2016)
You...
July 5, 2016 at 5:49 am
thanks guys. i'm also using ola's scripts. i'm doing physical_only check dbs during the week and a full checkdb on the weekend. the period is supposed to be quiet...
July 5, 2016 at 3:59 am
Viewing 15 posts - 31 through 45 (of 275 total)