Viewing 15 posts - 5,896 through 5,910 (of 22,226 total)
And if you don't have a plan that will go parallel on its own, just use TRACEFLAG 8649. That will drop the query cost to zero so you'll see a...
"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
July 2, 2015 at 7:20 am
It really depends on your transaction load, but you have a couple of options. Use Extended Events and capture all the RPC Completed and SQL Batch Completed events for one...
"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
July 2, 2015 at 3:33 am
rodjkidd (7/2/2015)
I liked Belgium when I visited. The beer does help of course 😀 Must go back again soon.
Grant when and where will you be in the UK?
Don't stand a...
"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
July 2, 2015 at 3:09 am
Koen Verbeeck (7/2/2015)
When are you coming to Belgium? We are currently in a heat wave, so bring sunscreen 🙂
Week after next. Next week is in the UK.
"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
July 2, 2015 at 3:07 am
Lynn Pettis (7/1/2015)
"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
July 1, 2015 at 3:44 pm
Sean Lange (7/1/2015)
Grant Fritchey (7/1/2015)
Sean Lange (7/1/2015)
jasona.work (7/1/2015)
Half the people (the smart ones?) take the other 4 days...
"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
July 1, 2015 at 3:42 pm
Koen Verbeeck (7/1/2015)
Grant Fritchey (7/1/2015)
Sean Lange (7/1/2015)
jasona.work (7/1/2015)
Half the people (the smart ones?) take the other 4 days...
"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
July 1, 2015 at 3:38 pm
Sean Lange (7/1/2015)
jasona.work (7/1/2015)
Half the people (the smart ones?) take the other 4 days off, and the people...
"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
July 1, 2015 at 12:21 pm
Being a college drop-out and utterly w/o degree, yet, I'd argue, a relatively successful career within IT, I'm frankly not sure what a college degree would have done for 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
July 1, 2015 at 10:34 am
It's still just about standard monitoring. Keep an eye on your wait statistics, watch to see if these change in a negative fashion. Same thing goes for the queues within...
"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
July 1, 2015 at 8:08 am
If you don't have the capabilities to do disaster recovery, your company can go under.[/url] That's the number one argument for me. We have to be able to do disaster...
"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
July 1, 2015 at 7:59 am
A second vote for the Internals book. It's great. My book on execution plans does go over how the optimizer works, but not in as much detail. Plus, you can...
"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
July 1, 2015 at 7:55 am
Also, as much as I'm guilty of saying this, it's not about improving the plan. It's about improving the performance of the query. The plan just exposes how the optimizer...
"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 30, 2015 at 12:41 pm
DBA From The Cold (6/30/2015)
Grant Fritchey (6/30/2015)
DBA From The Cold (6/30/2015)
"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 30, 2015 at 6:24 am
GilaMonster (6/30/2015)
Eeep. Just realised that tomorrow's the 1st of July. Or the 'refresh email every 5 seconds' day.
Mine is April 1st, which also means that it's "check the header 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 30, 2015 at 5:37 am
Viewing 15 posts - 5,896 through 5,910 (of 22,226 total)