Viewing 15 posts - 14,296 through 14,310 (of 22,232 total)
lallu_jaya (9/28/2010)
I shall do it that way. I actually found that one of the join was redundant and removed it and found performance improvement.
Grant,
Thanks for your reply. Shall not worry...
"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
September 29, 2010 at 5:46 am
That's pretty much what you need. While you're there you should probably go ahead and capture duration, the database, start time, maybe the user... you can add six or seven...
"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
September 28, 2010 at 1:25 pm
Jeff Moden (9/28/2010)
"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
September 28, 2010 at 7:41 am
Complete side point, but note the difference between how Gail had you do the table joins and how you were doing them in the original query. What you're doing 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
September 28, 2010 at 7:02 am
I'm not a guru either.
It sounds like you were probably hitting a combination of issues. I suspect the transactions were holding locks open for an excessive amount of time, partly...
"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
September 28, 2010 at 7:00 am
Because the dependency viewing in SQL Server is more than a little bit messed up. Try running a query against sys.dm_referencing_entities to get the objects that are referring to 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
September 28, 2010 at 6:59 am
The estimated costs are just that, estimates. They're calculations based on the statistics available and the query being run. While they are the only number available to us when working...
"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
September 28, 2010 at 5:48 am
Steve Jones - Editor (9/27/2010)
Jeff Moden (9/27/2010)
...I guess I should look at the more postive "at least people are trying" aspect.
If they are trying. Remember that posts, articles, etc....
"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
September 27, 2010 at 7:22 pm
Alvin Ramard (9/27/2010)
Grant Fritchey (9/27/2010)
Jeff Moden (9/27/2010)
Grant Fritchey (9/27/2010)
"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
September 27, 2010 at 1:36 pm
Steve Jones - Editor (9/27/2010)
Most sessions are recorded.You could also make an appeal to Allen Kinsel to slide one of you two.
Not me. Allen is overworked as is. He's done...
"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
September 27, 2010 at 1:35 pm
digdave7 (9/27/2010)
Thanks for the reply; you're comments helped. I did want to ask (if you dont mind) for more feedback on the "migrate the keys"...
"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
September 27, 2010 at 1:34 pm
Jeff Moden (9/27/2010)
Grant Fritchey (9/27/2010)
"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
September 27, 2010 at 1:24 pm
A lady at ASKSSC could use some help. I know you guys don't go there often.
She's, I'd say, being abused by the boss. Might want to chime in.
"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
September 27, 2010 at 12:08 pm
WayneS (9/27/2010)
CirquedeSQLeil (9/27/2010)
Sometimes we learn quite a bit through our articles and our blogs that we would not have learned otherwise.
So true. In fact, the last article that I...
"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
September 27, 2010 at 9:17 am
Steve Jones - Editor (9/27/2010)
Alvin Ramard (9/27/2010)
Jeff Moden (9/26/2010)
... there are a whole lot of people that should'na be allowed near a computer never mind a database.
Seen too many 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
September 27, 2010 at 8:42 am
Viewing 15 posts - 14,296 through 14,310 (of 22,232 total)