Viewing 15 posts - 5,281 through 5,295 (of 22,219 total)
Thanks for all the help guys. I'm thinking that I'm going to back off and rethink my blog post. I can't get my head around what I need to do...
"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
December 17, 2015 at 7:00 am
Seriously, just go and answer their questions. Trying to memorize a set of answers is not going to get you the job. A junior level person with only a year...
"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
December 17, 2015 at 3:18 am
mattmparker (12/16/2015)
- Does the density/distribution of salesperson-region relationships have high cardinality (salespeople strongly associated with one or two...
"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
December 16, 2015 at 10:35 am
mattmparker (12/16/2015)
So, for example, a region and a salesperson are likely to be related, not a unique relationship, in each sale.
I think you're on the right track, and just...
"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
December 16, 2015 at 10:30 am
BuckWoody (12/16/2015)
Not sure I have enough info to answer this, but I have a cheat-sheet referenced on this page that might help, along with some ideas: https://buckwoody.wordpress.com/2015/12/02/knowing-which-statistical-formula-to-use/
Thanks Buck. That's already...
"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
December 16, 2015 at 10:23 am
It could be Azure, but you really should still see a wait of some kind. I'm with Kevin.
"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
December 16, 2015 at 9:07 am
Just be aware that SQL Server will use up every bit of memory you give it and that's not a bad thing. The real concern is if you're seeing wait...
"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
December 16, 2015 at 8:56 am
Steve Jones - SSC Editor (12/16/2015)
Jeff Moden (12/16/2015)
Family always comes first but that's a bugger. Was looking forward to seeing you again, ol' friend.
Ditto. Was hoping to get there,...
"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
December 16, 2015 at 8:26 am
shirish_padekar (12/16/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
December 16, 2015 at 4:12 am
The trick is going to be identifying what is causing the so much CPU to be used. Since you're just getting started and you're on 2008, the best approach is...
"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
December 16, 2015 at 4:07 am
A simple way? None that I'm aware of.
I did a search. The script documented here comes up pretty frequently, but it's anything but simple.
Looking at Paul's script, I'm pretty 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
December 15, 2015 at 6:57 pm
What are the actual wait metrics? Check sys.dm_os_wait_stats before, during, and after the issue. Also, look to sys.dm_exec_requests while the issue is running to see active waits. You need 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
December 15, 2015 at 6:53 pm
sql.queries (12/15/2015)
I think I will need to study execution plans to accomplish this. Any advice where to start?Thanks
Actually, yes. Look down to the links in my signature
|
|
V
"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
December 15, 2015 at 7:21 am
GilaMonster (12/15/2015)
Don't just look at the execution plan operators and assume which is better. Test. Get actual metrics and compare numbers (and I don't mean cost %).
THIS!
Scans are not necessarily...
"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
December 15, 2015 at 3:14 am
xsevensinzx (12/14/2015)
Why prove the usefulness of R to the DBA as opposed to a general purpose language like Python that can accomplish the same 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
December 15, 2015 at 3:07 am
Viewing 15 posts - 5,281 through 5,295 (of 22,219 total)