so this is 64 bit enterprise edition.  The sql instance which is doing nothing at this point has a max of 28 gig but it never hits this anyhow.  Feel...

I can restart but using your startup command I can't get to it through SSM

tells me only one user can login it a time and refuses login

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...

becoming senile (still supporting too many 2008 instances) you are correct only need catalog these days

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...

duh thanks missed the obvious one

duh should have thought of case will test and see what optimizer thinks

Thx

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...

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...

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...

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...

still type too fast, prod is enterprise edition where uat is actually developer, microsoft feature?

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...

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...

stats and indexes good, looks like this may be a storage issue