Viewing 15 posts - 151 through 165 (of 1,518 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...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
November 11, 2011 at 11:39 am
SQLRNNR (11/11/2011)
Marios Philippopoulos (11/11/2011)
SQLRNNR (11/11/2011)
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
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...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
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...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
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...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
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...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
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...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
November 5, 2011 at 9:19 am
r.dragoi-1095738 (11/4/2011)
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
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...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
November 3, 2011 at 9:09 am
Dave Mason (11/2/2011)
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
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...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
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...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
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... 🙂
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
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...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
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...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 17, 2011 at 11:20 am
Viewing 15 posts - 151 through 165 (of 1,518 total)