Viewing 15 posts - 11,626 through 11,640 (of 22,219 total)
You're comparing calculated values to calculated values. Indexes are no longer a part of the equation. It's nothing but scans. That's a guaranteed performance degradation as more and more rows...
"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 2:52 pm
GilaMonster (11/21/2011)
GSquared (11/21/2011)
It must be DBA season somewhere.Open season on DBAs??? *fetches bow*
*fetches rifle* And not the bolt-action one either.
"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 2:22 pm
Gail's articles will get you started. When you need more, please consider my book (in the signature line).
"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 11:16 am
1 & 2 are in the Books Online.
3. Yes. For more details see the Books Online.
4. There is an error log associated with the Agent. You can get errors there...
"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 11:15 am
A differential is the sum total of all changes since the last full backup. When did you last take a full backup?
"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 11:14 am
It's as the Ninja & Gail says, a plan is neither good nor bad, per se. It's the statistics, the structure, and your query, that drive what kind of plan...
"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 11:00 am
goofy2sql (11/21/2011)
"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 10:57 am
Jack Corbett (11/21/2011)
"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 9:06 am
ChrisM@Work (11/21/2011)
Grant Fritchey (11/21/2011)
Wibble.It won't work without the knickers and pencils;-)
Yeah, got those here.
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 8:18 am
CPU & IO pressure are different. I'd need a lot more information to make even vague suggestions.
"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:17 am
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
Viewing 15 posts - 11,626 through 11,640 (of 22,219 total)