Viewing 15 posts - 1 through 15 (of 16 total)
sorry image did not come across as planned, I missed an obvious on the key lookup that actual rows millions of rows more than estimated. The even uglier part of...
March 6, 2020 at 3:08 pm
becoming senile (still supporting too many 2008 instances) you are correct only need catalog these days
February 5, 2020 at 4:40 pm
Not seen any mention, but more than likely this may be a bad plan from executed sql. Run sp-whoisactive, or download Brent Ozar's blitzcache. Start there as soon as it...
January 29, 2020 at 2:25 pm
duh thanks missed the obvious one
January 24, 2020 at 4:42 pm
duh should have thought of case will test and see what optimizer thinks
January 13, 2020 at 6:28 pm
trying to figure out a way to deal with left joins and the sub queries, with this amount of data in the sub query leanings towards temp tables with some...
January 13, 2020 at 4:12 pm
Ok perfect storm, do db backup and restored which is supposed to bring stats with this. Runs fine on dev. I use Ola's index stuff on everything. It did fail...
December 10, 2019 at 7:19 pm
no i just took sql straight from sentry one capture, ran on in mgmt studio n on dev edition runs great, this just started. All the configs are same been...
December 10, 2019 at 4:49 pm
still type too fast, prod is enterprise edition where uat is actually developer, microsoft feature? Also since prod dies can only look at est plan, but it matches the plan...
December 10, 2019 at 4:35 pm
still type too fast, prod is enterprise edition where uat is actually developer, microsoft feature?
December 10, 2019 at 4:02 pm
sorry hit submit too fast, any ideas on this one, makes no sense at all why does query on high horsepower server bury tempdb with 5 times the ram. They...
December 10, 2019 at 4:00 pm
so other dba looked at disk activity in sentry one and caught we have two controllers, one with 3 disks, the other with 9. This 9 includes drives with the...
October 15, 2019 at 7:31 pm
stats and indexes good, looks like this may be a storage issue
October 14, 2019 at 12:47 pm
Looks multiple problems, query is bad but ran on test system I/o issues in report server. ran blitzio and got some scary results with stall time over 40ms
October 11, 2019 at 5:59 pm
just started here as dba so change probably not it is 133 million rows index seemed to help will look at cleanup just in case thanks for help
October 9, 2019 at 5:34 pm