Viewing 15 posts - 241 through 255 (of 1,518 total)
Jeffrey Williams-493691 (8/20/2011)
I see this a lot, and the assumption by the person is that splitting out data...
__________________________________________________________________________________
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]
August 20, 2011 at 11:37 am
GilaMonster (8/20/2011)
The query optimiser costs were times at one point. They were benchmark times on a specific computer in the MS testing...
__________________________________________________________________________________
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]
August 20, 2011 at 5:34 am
GilaMonster (8/19/2011)
Marios Philippopoulos (8/19/2011)
Default value is 5 sec; may be too low for most systems.
Setting it to higher values (say 15-20...
__________________________________________________________________________________
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]
August 20, 2011 at 4:55 am
Another setting to play around with: cost threshold for parallelism.
Default value is 5 sec; may be too low for most systems.
Setting it to higher values (say 15-20 sec) may 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]
August 19, 2011 at 3:07 pm
GilaMonster (8/19/2011)
Goes straight to graphical plan here, on same version of SSMS
Hmm, now that I am running it again on the same server, I get the graphical plan for one...
__________________________________________________________________________________
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]
August 19, 2011 at 10:03 am
GilaMonster (8/19/2011)
That's how SSMS 2005 behaves. Sure you're not running the wrong version by accident?
Nope, I'm running 10.0.2531.0 on my SSMS.
The server I am monitoring is on 10.50.2500.
Here is the...
__________________________________________________________________________________
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]
August 19, 2011 at 8:41 am
Jeff Moden (8/17/2011)
Marios Philippopoulos (8/17/2011)
More specific to the problems you’ve resolved through the use of thoughtful and narrowly-scoped CLRs, my question on that would be, why do most...
__________________________________________________________________________________
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]
August 18, 2011 at 7:48 am
Jeff Moden wrote:
More specific to the problems you’ve resolved through the use of thoughtful and narrowly-scoped CLRs, my question on that would be, why do most (and I do mean...
__________________________________________________________________________________
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]
August 17, 2011 at 8:02 pm
One of the things I dislike most about cmdshell is its lack of specificity.
As long as a valid DOS command is passed to it, cmdshell will run it happily...
__________________________________________________________________________________
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]
August 17, 2011 at 10:50 am
Ninja's_RGR'us (8/12/2011)
And they can't tell you what happened or what's hapenning during the issue?Thanks for the tip!
Not fully; SQL Sentry is showing the high IO_COMPLETION waits and the perfmon counters...
__________________________________________________________________________________
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]
August 12, 2011 at 2:03 pm
Ninja's_RGR'us (8/12/2011)
You can get sql monitor for free for 14 days, that should give you your answer...
Thanks, we are using SQL Sentry and IGNITE for monitoring. But thanks for the...
__________________________________________________________________________________
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]
August 12, 2011 at 1:51 pm
Ninja's_RGR'us (8/12/2011)
40X slower is not enough for them?sp_update_resume, sp_distribute.
In the mean time, what changed on that server or the db sine the last successful 1 minute exec?
The hourly snapshot-refresh job...
__________________________________________________________________________________
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]
August 12, 2011 at 1:44 pm
dheeraj gupta (8/10/2011)
The things you mentioned looks good. Does it mean that Update Stats with Full Scan is not needed for the Indexes that were rebuilt?
Can you pl provide the...
__________________________________________________________________________________
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]
August 10, 2011 at 8:18 am
Ninja's_RGR'us (7/25/2011)
Ok so he must be confused!I'm just using the normal text column of the trace to then get the sp_name. Nothing special.
Makes sense. So you don't think there...
__________________________________________________________________________________
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]
July 25, 2011 at 8:13 am
Ninja's_RGR'us (7/25/2011)
Marios Philippopoulos (7/25/2011)
Perry Whittle (7/23/2011)
Marios Philippopoulos (7/22/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]
July 25, 2011 at 8:02 am
Viewing 15 posts - 241 through 255 (of 1,518 total)