Viewing 15 posts - 12,331 through 12,345 (of 22,219 total)
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
In addition to videos which can be incomplete, I'd suggest getting a copy of Kalen Delaney's book "SQL Server 2008 Internals." It's a must own.
"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:28 am
If you really have lots of fields not used by other processes and a table as wide as that, I think you'd be better off looking at some form of...
"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:28 am
Since that's an estimated plan not an actual plan it's hard to know for sure, but it looks like the table has a cardinality estimate of about 1 million...
"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:21 am
I'm curious what performance issues you've seen with Red Gate SQL Monitor?
I work for the company and we're constantly trying to improve the product. If you have some specific...
"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 8:29 am
How do you mean? Do you want alerts when there are errors? You can configure this using Alerts in SQL Agent.
"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 8:27 am
No, something else must be occurring. I'm with the Ninja, I'd need to plan to understand.
Just a guess, you added the index and then reran the query? Unless you...
"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 8:25 am
Why are you trying to drop one of the system procs? I'd leave that alone.
"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:30 am
GilaMonster (6/13/2011)
Anyone noticed that we now have pretty pictures as well as alphabet soup? http://www.sqlservercentral.com/Forums/Topic1123813-359-1.aspx
The soup has been strained though. Improvements.
"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 am
Viewing 15 posts - 12,331 through 12,345 (of 22,219 total)