Viewing 15 posts - 12,331 through 12,345 (of 22,227 total)
And with all that, now it's going to be even harder trying to figure out why you're getting performance differences and where those differences are coming from. I hope you're...
"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
June 13, 2011 at 6:11 pm
61 different statements... You're on your own.
I will note that statement 7 & 8 (two of the highest, one in ON & one in OFF) both show ANSI_WARNINGS set 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
June 13, 2011 at 5:08 pm
todinhkhoi (6/13/2011)
Thank you for the instructions. I followed them, and finally I was successful in retrieving the data I wanted. I have another 2 questions...
"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
June 13, 2011 at 5:00 pm
Jack Corbett (6/13/2011)
Thanks for the congratulations. I'm looking forward to the new opportunities and challenges. ...
"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
June 13, 2011 at 4:55 pm
Yeah, it's a valid approach. Just as long as you know that those procs are cache dependent which means you could lose queries as they age out of the 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
June 13, 2011 at 4:53 pm
Are you getting different execution plans depending on if it's on or off?
"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
June 13, 2011 at 1:48 pm
sql_handle is how you connect to sys.dm_exec_query_text.
If you're concerned more about procedures, in 2008 you can use sys.dm_exec_procedure_stats. Not available in 2005, but it is 2008.
"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
June 13, 2011 at 1:46 pm
Sorry, I can't help you there. I don't have a 2000 instance available any more to test it out. You might try posting in the 2000 forum.
"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
June 13, 2011 at 1:00 pm
Plus, there is no one, perfect answer. So you set the MAXDOP to 1 and "fix" the CXPACKET problem, but now you've got queries that are taking forever because they...
"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
June 13, 2011 at 12:56 pm
I wouldn't mess with all the aggregations. sys.dm_exec_sql_stats is an aggregate of the performance already. You won't get differences. Also, why are you using that function instead of sys.dm_exec_sql_text 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
June 13, 2011 at 12:50 pm
Yep, you could hit issues. Also, the recommendations might include statements (such as the INCLUDE statement, ha) that won't work on 2000. There was a tuning advisor for 2000 databases....
"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
June 13, 2011 at 12:46 pm
Thought I'd share. My wife ordered this book and I finished it just now. Having dealt with a problem sleeper (and still dealing with him at age 13), this thing...
"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
June 13, 2011 at 12:42 pm
Jack Corbett (6/13/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
June 13, 2011 at 12:32 pm
Yeah, Dan has it right. If you filter on columns from the OUTER table in the WHERE clause you will get an INNER JOIN. The trick is to move those...
"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
June 13, 2011 at 12:31 pm
It was running for years with no issues at my previous employer.
"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
June 13, 2011 at 9:30 am
Viewing 15 posts - 12,331 through 12,345 (of 22,227 total)