Viewing 15 posts - 11,641 through 11,655 (of 22,224 total)
Lexa (11/21/2011)
Grant Fritchey (11/21/2011)
Lexa (11/20/2011)
Grant Fritchey (11/20/2011)
But to be...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 21, 2011 at 8:16 am
Wibble.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 21, 2011 at 5:07 am
The only number in there that means anything without a comparison to other numbers is the processor queue length. A length of 16 suggests you might have some CPU conflicts...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 21, 2011 at 4:28 am
I'd suggest using Gail's second choice there. Most shops I've worked in set the logs to cycle. Of course, maybe that's true because I'm the one that sets them to...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 21, 2011 at 4:24 am
Lexa (11/20/2011)
Grant Fritchey (11/20/2011)
But to be honest, it sounds...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 21, 2011 at 3:59 am
bridgt01 (11/20/2011)
As for updating stats, stats have been updated and indexes have...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 21, 2011 at 3:57 am
I've been working with Red Gate tools for 10 years now. I've been working for the company for the last nine months. I liked their software so much I went...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 21, 2011 at 3:47 am
Try getting the execution plan when it's slow and when it's fast. Compare the two. It could be bad parameter sniffing.
But to be honest, it sounds like contention. Have...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 20, 2011 at 6:00 am
ggpevans (11/19/2011)
The two topics are
a) Relationships
b) Joins (Inner joins and cross joins etc)
I understand that...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 20, 2011 at 5:58 am
Sounds like some seriously large queries and/or some processing occurring within queries that is excessively large. Based on what you've provided, it's hard to say what. I'd suggest setting up...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 19, 2011 at 10:45 am
And for those interested, you can run an upgrade directly from CTP3.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 19, 2011 at 5:58 am
So you have a WHERE clause against a 30,000 row multi-statement table valued function... To quote a famous man "Well there's your problem.[/url]"
Seriously though, you may have any number...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 18, 2011 at 4:02 pm
WayneS (11/18/2011)
Congrats Grant for making the Top 10 Community Choice Bloggers list! Keep up the good work!
Thanks.
I had no idea I was doing good work.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 18, 2011 at 2:11 pm
WayneS (11/18/2011)
:w00t::w00t::w00t:Just passed 70-451. Now I have all exam pre-req's for 88-970 done... just not sure I'm ready for that one yet though.
Well done.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 18, 2011 at 11:54 am
Ninja's_RGR'us (11/18/2011)
Steve Jones - SSC Editor (11/18/2011)
Grant Fritchey (11/18/2011)
My title is Product Evangelist, but my job is Booth Babe.Babe, bouncer, or barbarian?
In that kilt?
yes!
Exactly.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 18, 2011 at 8:54 am
Viewing 15 posts - 11,641 through 11,655 (of 22,224 total)