Viewing 15 posts - 12,481 through 12,495 (of 22,219 total)
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
1.1. Not per se. I prefer just using the STATISTICS IO and STATISTICS TIME when working with a single query. It's easier than this set up and accurate enough
1.2.a. If...
"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:08 am
No, don't use the DTA. It's recommendations are frequently a waste of time and that's if it makes recommendations.
Your approach is OK as mechanism to see what the query...
"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 4:37 am
I buy 'em all. I've got a kindle, an ipad and I'll shortly have an Asus running Honeycomb.
Seriously though, the Kindle is excellent for reading and the battery life is...
"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 4:33 am
When you tell SQL Server to run a backup, the backup process runs under the context that SQL Server is configured in, not the context in which you are connecting...
"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 4:12 am
opc.three (5/23/2011)
Craig Farrell (5/23/2011)
GilaMonster (5/23/2011)
LutzM (5/23/2011)
GilaMonster (5/23/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 23, 2011 at 6:43 pm
Viewing 15 posts - 12,481 through 12,495 (of 22,219 total)