Viewing 15 posts - 11,686 through 11,700 (of 22,219 total)
LutzM (10/22/2011)
kstjacques (10/21/2011)
So the good news is the vendor is saying they will look into fixing the issue.
My favorite part of the latest...
"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 23, 2011 at 5:59 am
I'm more than a little confused by the question. The Merge Join operator inside of an execution plan is one of the most efficient operations there is. Problems around 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 23, 2011 at 5:52 am
How long does the oracle query take if you just run it on oracle? And how much data is being returned?
"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 23, 2011 at 5:47 am
If you're just getting started as a DBA, first thing, treat production like a patient and you're a doctor, do no harm.
After that, the list of things you have 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 23, 2011 at 5:45 am
Clint-525719 (10/21/2011)
1) We do not have the AdHoc optimization turned on, and actually, I'd forgotten about it. I've...
"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 22, 2011 at 5:25 am
Jack Corbett (10/21/2011)
Steve Jones - SSC Editor (10/21/2011)
Jack Corbett (10/20/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
October 21, 2011 at 1:15 pm
Jack Corbett (10/20/2011)
On a more serious note, I'd like to put together a new presentation, but I'm a bit short on ideas. Any suggestions?
Throw out an old one 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
October 21, 2011 at 10:08 am
If it's not turned on already, turn on optimizer for ad hoc workload.
Next, news to me, but worth mentioning, NUMA (which most systems have these days) makes the normal page...
"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 20, 2011 at 11:25 am
Piling on at this point, but nope. Not a chance. the DMO objects store either real time information or aggregation information. They couldn't store historical information without the system 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
October 20, 2011 at 11:20 am
You'd need to get into querying against the DMOs. sys.dm_exec_query_stats will have 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 20, 2011 at 11:00 am
Ian Massi (10/20/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
October 20, 2011 at 7:37 am
Phil Parkin (10/20/2011)
Grant Fritchey (10/20/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
October 20, 2011 at 5:57 am
derek.colley (10/20/2011)
I think he means 'login' rather than 'log in'
Entirely possible.
Here's the appropriate entry from the BOL
"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 20, 2011 at 5:57 am
Ninja's_RGR'us (10/20/2011)
HTH, all I did use use the script and like it. Michelle actually wrote it! 😉
ditto
"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 20, 2011 at 5:55 am
Do they all have the same query_plan_hash value?
Sounds like you might be a candidate for Optimize for Ad Hoc workloads, but it's hard to be sure.
"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 20, 2011 at 5:42 am
Viewing 15 posts - 11,686 through 11,700 (of 22,219 total)