Viewing 15 posts - 12,481 through 12,495 (of 22,224 total)
There are changes to the query optimizer between 2000 and 2005. Because of this, you will see some changes in behavior. Most of the time you'll see improvements or no...
"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
May 25, 2011 at 6:56 am
You need to look at what processes you're putting through tempdb. If it's growing that much, it's because it's being used, so you need to identify what it is 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
May 25, 2011 at 4:42 am
You might want to look up a process called log shipping. I think that will do what you need much easier than what you're talking about.
Also, you won't be able...
"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
May 25, 2011 at 4:41 am
There are instances where a poorly written query performed adequately in 2000 but doesn't perform as well in 2005/2008. Usually fixing the issues with the query fixes the problem.
"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
May 25, 2011 at 4:37 am
That's what it's basically doing, but it's doing it in a single command as opposed to two. Why do you ask?
"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
May 25, 2011 at 4:35 am
Sorry, went off to bed. Looks like Gail answered all the questions already.
"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
May 25, 2011 at 4:21 am
When a checkpoint occurs all the dirty pages, stuff that has changed, gets written to disk. I haven't looked at Diagnostic Manager for quite a while, but I imagine it's...
"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
May 24, 2011 at 7:02 pm
How fragmented is it?
Also, what's the fill factor?
"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
May 24, 2011 at 3:55 pm
Let me say up front, I hate the DTA. When it gives advice, it frequently gives bad advice.
That said, it sounds like you weren't connected to a database with all...
"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
May 24, 2011 at 2:59 pm
Another vote for SQL Prompt Pro[/url]. I'd hate to live without that software.
However, you could try the Simple-Talk SQL Prettifier.
"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
May 24, 2011 at 2:55 pm
Brandie Tarvin (5/24/2011)
I'm probably going to get lynched for this one, but ... It is a valid scenario. Honest.Thoughts?
http://www.sqlservercentral.com/Forums/Topic1114315-149-1.aspx
Sorry Brandie, I haven't a clue.
"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
May 24, 2011 at 1:25 pm
GilaMonster (5/24/2011)
Grant Fritchey (5/24/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
May 24, 2011 at 9:54 am
GilaMonster (5/24/2011)
colin.Leversuch-Roberts (5/24/2011)
I never truly understand this fixation with clearing cache(s)
Me neither. I prefer to run queries more than once and discard the first results so as to get something...
"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
May 24, 2011 at 7:12 am
Abrar Ahmad_ (5/24/2011)
Grant Fritchey (5/24/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
May 24, 2011 at 7:11 am
Kiara (5/24/2011)
The only problem with my Kindles (I have two - both the DX and...
"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
May 24, 2011 at 5:50 am
Viewing 15 posts - 12,481 through 12,495 (of 22,224 total)