Viewing 15 posts - 151 through 165 (of 1,517 total)
george sibbald (11/11/2011)
Marios Philippopoulos (11/11/2011)
george sibbald (11/11/2011)
I'd compare query plans. Maybe the proc needs a recompile in prod.
But the odd thing is that after I run DBCC FREEPROCCACHE in dev...
November 11, 2011 at 11:39 am
SQLRNNR (11/11/2011)
Marios Philippopoulos (11/11/2011)
SQLRNNR (11/11/2011)
November 11, 2011 at 11:06 am
SQLRNNR (11/11/2011)
That would be a good start. You might try the tool SQL Sentry Plan Explorer. I find it many times more helpful in reading exec plans.
It's a...
November 11, 2011 at 10:57 am
I have been able to trace back from the 2 join operators to an index seek with hugely incompatible numbers of rows, Actual vs Estimated.
Here is a schematic of this...
November 11, 2011 at 10:54 am
I was able to collect the actual (live) exec plan of the proc, and I see a monstrous (18 billion) number of rows passed at some point in the plan.
I...
November 11, 2011 at 10:41 am
george sibbald (11/11/2011)
I'd compare query plans. Maybe the proc needs a recompile in prod.
But the odd thing is that after I run DBCC FREEPROCCACHE in dev and restore the prod...
November 11, 2011 at 10:02 am
codebyo (11/4/2011)
r.dragoi-1095738 (11/4/2011)
I would select the rows first into a variable table and after that I would use the cursor (over the variable table)
I would advise that as well.
I may...
November 5, 2011 at 9:19 am
r.dragoi-1095738 (11/4/2011)
November 4, 2011 at 8:25 am
GSquared (11/3/2011)
If you have to use a cursor for this, make it STATIC instead of FAST_FORWARD. It'll probably be faster that way, and it will definitely release locks faster.
Thank...
November 3, 2011 at 9:09 am
Dave Mason (11/2/2011)
November 2, 2011 at 1:14 pm
GilaMonster (10/26/2011)
Marios Philippopoulos (10/26/2011)
GilaMonster (10/26/2011)
Open transaction, no commit. Tran stays open so locks held even though the session was sleeping.
Thanks, but why on tempdb? The SELECT was running on a...
October 26, 2011 at 8:53 am
GilaMonster (10/26/2011)
Open transaction, no commit. Tran stays open so locks held even though the session was sleeping.
Thanks, but why on tempdb? The SELECT was running on a user database.
I don't...
October 26, 2011 at 8:45 am
Ninja's_RGR'us (10/19/2011)
As someone real smart said => 😀Ninja's_RGR'us (10/12/2011)
Just a PS. Doesn't work on 2K5 :angry:
Duly noted... 🙂
October 19, 2011 at 10:22 am
Thanks, I truncated the Segment table last night and was able to get the db size down to a more manageable size.
From what Microsoft mentioned to me, the highest contributors...
October 19, 2011 at 9:08 am
Lynn Pettis (10/17/2011)
Did you check the SQL Serror log as well? There may be more information in other logs that would help identify the problem.
There are no corresponding errors...
October 17, 2011 at 11:20 am
Viewing 15 posts - 151 through 165 (of 1,517 total)