Viewing 15 posts - 14,206 through 14,220 (of 22,224 total)
Rob Schripsema (10/4/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
October 4, 2010 at 1:31 pm
Until you get into the third party tools (my favorites, in no particular order, are Red Gate SQL Response, Confio Ignite, Idera Diagnostic Manager), then I'd suggest a combination 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
October 4, 2010 at 1:27 pm
You might be looking for the DMO sys.dm_exec_query_stats. It contains an aggregation of the performance of the queries currently in cache. You can also look at sys.dm_exec_proc_stats in 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
October 4, 2010 at 1:24 pm
I'm assuming you're not talking about disaster recovery (DR)?
Just for tuning performance, first thing I'd do is set up data collection to get a good set of metrics from performance...
"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 4, 2010 at 1:21 pm
Matt Miller (#4) (10/4/2010)
Steve Jones - Editor (10/4/2010)
david_wendelken (10/4/2010)
So, rather than piss and moan about not getting equal pay for equal work, why not learn what career and job negotiating...
"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 4, 2010 at 11:29 am
sql_er (10/4/2010)
1. Subtree cost: Not sure how often people use this, but...
"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 4, 2010 at 11:25 am
Jeff Moden (10/4/2010)
Dave Ballantyne (10/4/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
October 4, 2010 at 8:30 am
Jeff Moden (10/4/2010)
Dave Ballantyne (10/3/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
October 4, 2010 at 6:43 am
Hey Wendy! Excellent editorial. 110% agreement. You really couldn't have put it any better.
BTW, regarding boys & girls & toys, I have twins, one boy, one girl, our intention was...
"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 4, 2010 at 6:35 am
It depends on how your views are put together. If they're all simply "SELECT *" type of views, then they more or less fix themselves as they are referenced. On...
"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 2, 2010 at 5:26 am
Tim Parker (10/1/2010)
The senior DBA that I work with gave me that idea. So I cheated a bit... 😀
No, no, no. We don't call it cheating. We call...
"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 2, 2010 at 4:15 am
Hey guys, thanks for dumping a load of... something into my in box. What the heck were you guys smoking in here last night?
"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 2, 2010 at 4:09 am
I really hate the DTA. Piece of Marketing if you ask me.
"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 1, 2010 at 1:30 pm
I sure don't have any, but you might search through Brent Ozar's blog[/url]. He's talked about them pretty frequently.
"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 1, 2010 at 1:29 pm
Tim Parker (10/1/2010)
In case I completely misunderstood your question, here is a link to BOL that discusses the HOLDLOCK table hint.ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_6tsql/html/8bf1316f-c0ef-49d0-90a7-3946bc8e7a89.htm
See if this is what you're looking for.
I think 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
October 1, 2010 at 12:05 pm
Viewing 15 posts - 14,206 through 14,220 (of 22,224 total)