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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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)
July 25, 2011 at 8:02 am
Viewing 15 posts - 241 through 255 (of 1,518 total)