Idera is safe enough to let me save as XDL

going to try that also, the blocking we got on old box and 2008r2 was once a day, now getting this deadlock almost every time. the statement it is...

going to run blitzindex and look at sql that deadlock keeps causing.

already have that use IDera DM and looking at Ozar Blitzcache. These are the same offensive queries that were killing us before. Only difference is we now have...

one of the problems before was the PLE as almost zero, new server has 512 gig of RAM. Old server CPU was never really above 45%. This is...

maxdop at 8, have on particular query that is deadlocking all the time (it is some ugly code, 3rd party can't change). It would cause blocking on old server...

Will start checking for recompiles, this is a fairly old code set from vendor way to hard to describe. ALso seeing a lot of deadlocks which did not happen...

3rd party same bad code offenders as before none of that has changed other than new box and sql 2012. I have heard CPU issues with numa

brand new HP physical

updated stats and indexes, I am consultant on this one, never seen this happen before. May consider setting back to 2008 compatible for database. They were actually getting...

it is not an error but when you go to file properties in tempdb and choose add a file and select the elipse it does not show the T drive...

The tempdb is actually there and working I just wanted to add another file to tempdb. So at the cluster level tempdb on the local storage is working, just...

no this is new feature of 2012

Depending on your system that may or may not be available. Are you looking for what is using the most resources? Look at brent ozar site and look...

Unfortunately in both of these cases my input is little, I just have to get it to work