Viewing 15 posts - 16,246 through 16,260 (of 22,226 total)
Without code it's hard to know what's happening, but if you're loading data into a temp table and then locking it in a second step, there's your problem. You need...
"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
October 27, 2009 at 6:26 am
I'm not sure I'd compare Spotlight & Diagnostic Manager directly. Yes, both show you real time measurements of server performance, but DM also keeps historical information so that you can...
"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
October 27, 2009 at 6:25 am
Logical order is the ordering of the index. Let's assume an index based on last name. The logical order would be:
Adams
Johnson
Smith
Williams
But, due to page splits, insertions, deletes and the other...
"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
October 27, 2009 at 6:21 am
vaidehi.rajamani19 (10/27/2009)
But the client requirement is to find the percentage of time taken for DB 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
October 27, 2009 at 5:24 am
Feel better Barry.
"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
October 27, 2009 at 5:18 am
Jeff Moden (10/26/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
October 27, 2009 at 5:16 am
RBarryYoung (10/26/2009)
Sadly, I will not be able to attend this year. 🙁 Raise one for me, lads!
Nuts, sorry to hear it.
"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
October 26, 2009 at 6:18 pm
I just started on the "good" plan, and it's all scans, not a seek in the process. There's missing index information:
/*
Missing Index Details from Clarks Unique Orders @ 26-OCT-2009 good.sqlplan
The...
"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
October 26, 2009 at 9:32 am
Even before I look at the execution plan, why are you doing this instead of an equals?
s.CampaignID IN (53)
"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
October 26, 2009 at 9:24 am
huston.dunlap (10/26/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
October 26, 2009 at 7:43 am
Best thing you can do is get the actual execution plan for a good performing version and a bad performing version. The differences between the two are where the problems...
"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
October 26, 2009 at 7:37 am
There are a lot of ways you can do it and a lot of different types of performance tests. Are you trying to do a performance test based on the...
"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
October 26, 2009 at 7:10 am
Excellent introduction. Nice job Gail. Couldn't ask for better.
"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
October 26, 2009 at 6:13 am
sarvesh singh-457805 (10/25/2009)
Hi Grantlooking at the execution plan whichs tables do you think needs indexes.
For an execution plan that large, a complete break-down and set of recommendations would become billable...
"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
October 25, 2009 at 2:40 pm
sarvesh singh-457805 (10/24/2009)
I did run sp_updatestats to update the statistics. Do i have to update the statistics again. As far as missing index is concerned...
"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
October 25, 2009 at 12:17 pm
Viewing 15 posts - 16,246 through 16,260 (of 22,226 total)