Viewing 15 posts - 17,581 through 17,595 (of 22,219 total)
There are several articles on Gail Shaw's blog[/url]. There are several good articles here on SQL Server Central, just search in the window in the upper right. For real depth...
"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
April 28, 2009 at 1:28 pm
GilaMonster (4/28/2009)
Grant Fritchey (4/28/2009)
Hmmm... Now I am confused.
You and me both. I started writing a blog post on this, explaining that there could be serial and parallel plans in cache....
"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
April 28, 2009 at 1:18 pm
Hmmm... Now I am confused. I remember seeing that in action, but when you run RECONFIGURE WITH OVERRIDE the cache gets cleaned out, so I couldn't have done it playing...
"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
April 28, 2009 at 12:27 pm
I did it in the execution plan book. Let me look it up...
Damn, found a typo. I'm blaming you becuase I wouldn't have seen it otherwise...
Crap... Evidently I just lied......
"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
April 28, 2009 at 12:19 pm
Looks like your statistics might be a tad off. The index seek operation that is taking up 86% of the cost shows an estimated 1 row, but is returning 65000....
"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
April 28, 2009 at 11:42 am
Since SQL Server 2000 is off the main stream support path, how about the fact that if a mandatory security patch comes out that breaks 2000, you can't count on...
"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
April 28, 2009 at 11:34 am
Can you save the actual execution plan as a .sqlplan file, zip it and attach that? Without all the underlying data it's hard to read an execution 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
April 28, 2009 at 11:30 am
I'm sorry, I've never seen that one occur before. On a guess, someone did it. Especially if it's everywhere.
"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
April 28, 2009 at 11:14 am
Yes. You can apply controls to it directly so that it only uses a single CPU and limited memory. It means that the auditors will actuall make less impact on...
"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
April 28, 2009 at 11:00 am
Thinking about it further, would this be construed as a test system? Then you don't need to buy a license for it.
Either way, if you really have to let them...
"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
April 28, 2009 at 10:11 am
sam (4/28/2009)
Grant Fritchey (4/27/2009)
Move to 2008 then you can put the Resource Governor to work along with some policy based management.
We're just finishing up our migration of 170 dbs 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
April 28, 2009 at 10:08 am
GilaMonster (4/28/2009)
Paul White (4/28/2009)
"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
April 28, 2009 at 10:05 am
Oops. I misread what they had created. Sorry. I saw it as a compound index. My bad.
"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
April 28, 2009 at 7:23 am
Oh, and Tom Larock has a new article [/url]over at Simple Talk on using Audit.
"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
April 28, 2009 at 6:16 am
You might look at Change Data Capture. Here's an article on auditing on MSDN. That might help.
"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
April 28, 2009 at 6:14 am
Viewing 15 posts - 17,581 through 17,595 (of 22,219 total)