Viewing 15 posts - 871 through 885 (of 1,518 total)
Well-tuned queries - in an OLTP system - genarally should not parallellize. This is almost certainly a case of a suboptimally tuned system.
Is auto-updatestats, auto-createstats turned on for your databases?
Do...
__________________________________________________________________________________
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 22, 2008 at 6:03 pm
Arun (10/12/2008)
oh thats really true.. but i wonder if some DBA of today would really work in an environment where...
__________________________________________________________________________________
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, 2008 at 2:38 pm
Thank you, I think it's clear to me now.
__________________________________________________________________________________
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, 2008 at 9:16 am
Matt Miller (10/17/2008)
TheSQLGuru (10/17/2008)
So it looks like the only difference between what you guys are saying and what the TheSQLGuru is saying is in the fill factor for the NC...
__________________________________________________________________________________
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, 2008 at 9:04 am
Matt Miller (10/17/2008)
Marios Philippopoulos (10/17/2008)
TheSQLGuru (10/17/2008)
Marios Philippopoulos (10/16/2008)
I think it's settled. I will ask the developer to create the non-cl. idxs with 60% fill factor.Thanks for your help.
Since (it seems...
__________________________________________________________________________________
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, 2008 at 8:24 am
TheSQLGuru (10/17/2008)
Marios Philippopoulos (10/16/2008)
I think it's settled. I will ask the developer to create the non-cl. idxs with 60% fill factor.Thanks for your help.
Since (it seems that) the data is...
__________________________________________________________________________________
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, 2008 at 8:15 am
Jeff Moden (10/16/2008)
Marios Philippopoulos (10/16/2008)
I'm not sure I follow though. How would the non-clustered indexes get fragmented? The table population is done all at once,...
__________________________________________________________________________________
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, 2008 at 7:20 am
I think it's settled. I will ask the developer to create the non-cl. idxs with 60% fill factor.
Thanks for your help.
__________________________________________________________________________________
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 16, 2008 at 9:42 am
Matt Miller (10/16/2008)
The data rows of the underlying table are not sorted and stored in order based on their nonclustered keys.
I think this statement corroborates my earlier interpretation of how...
__________________________________________________________________________________
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 16, 2008 at 9:20 am
Matt Miller (10/16/2008)
Marios Philippopoulos (10/16/2008)
__________________________________________________________________________________
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 16, 2008 at 9:01 am
I've always thought that ONLY the clustered index stores its key values in (logical) order, and that storage of the non-clustered index data just follows the order of the clustered...
__________________________________________________________________________________
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 16, 2008 at 8:45 am
It's true that the ordering of the other 2 columns - FKID and Dt - is not sequential, as is that of the AID column.
Let's for a moment assume -...
__________________________________________________________________________________
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 16, 2008 at 8:23 am
Thank you both for your replies.
I'm not sure I follow though. How would the non-clustered indexes get fragmented? The table population is done all at once, in a sequential fashion...
__________________________________________________________________________________
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 16, 2008 at 4:10 am
I think I got it. 🙂
After adding the performance view, I also added a dashboard view.
While creating the dashboard view I clicked on the "Click to add a view"...
__________________________________________________________________________________
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 15, 2008 at 2:09 pm
I have successfully created the rule according to the information in the article.
I have also created a performance view in the Monitoring tab of the Ops Mgr console and configured...
__________________________________________________________________________________
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 15, 2008 at 1:12 pm
Viewing 15 posts - 871 through 885 (of 1,518 total)