Viewing 15 posts - 6,046 through 6,060 (of 22,226 total)
Take a look at the execution plan for the query. That will tell you what's happening with it. DISTINCT is an aggregation command. To get the best performance out 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
May 22, 2015 at 2:59 am
TomThomson (5/21/2015)
Have a look at this one. To me it looks like a recipe for disaster.
Or, we could just set fire to the server room and watch 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
May 21, 2015 at 6:03 pm
There are lots and lots of issues here, but speaking from personal experience, let me tell you what the #1 biggest problem is going to be.
You're going to have X...
"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
May 21, 2015 at 6:02 pm
A deadlock won't lock people out. It'll error out. Do you mean you have blocking?
And as for resolving deadlocks, it's usually a series of things. You have to get 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
May 21, 2015 at 12:18 pm
Eric M Russell (5/21/2015)
If you feel confident that this particular query should always leverage the non-clustered columnstore index, then have you tried an index like so?
WITH (INDEX (IX_EmployeeReview_CS))
But the issue...
"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
May 21, 2015 at 12:12 pm
I'm not sure. I don't have a good answer to that.
"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
May 21, 2015 at 11:33 am
GilaMonster (5/21/2015)
Grant Fritchey (5/21/2015)
Anti-virus
VM configuration
Server configuration (no NOT memory, I suspect something CPU related)
Queries that have always caused pain...
"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
May 21, 2015 at 10:18 am
jasona.work (5/21/2015)
Grant Fritchey (5/21/2015)
jasona.work (5/21/2015)
If I bring up the fact that I've not read The Thread from start to finish, does my secret SSC decoder ring get taken away?:w00t:
Duh!
Yes.
...yawa nekat...
"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
May 21, 2015 at 10:06 am
Yeah, I've installed them and used them successfully. They're great, if terribly fiddly. These would only ever get installed in test or development systems. There's no need, nor should 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
May 21, 2015 at 9:40 am
Check the execution plan. It really comes down to have it's being resolved. If you read the FAQ from Microsoft it outlines places where you can revert to row mode...
"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
May 21, 2015 at 9:35 am
Greg Edwards-268690 (5/21/2015)
Have you ever seen I/O contention lead to high CPU usage?
I ran into this on a host they decided to use for all nightly backups at 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
May 21, 2015 at 9:28 am
jasona.work (5/21/2015)
If I bring up the fact that I've not read The Thread from start to finish, does my secret SSC decoder ring get taken away?:w00t:
Duh!
Yes.
"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
May 21, 2015 at 9:21 am
Brandie Tarvin (5/21/2015)
Lynn Pettis (5/21/2015)
cunningham (5/21/2015)
soooo this is where you lot go to blow off steam!
Welcome to The Thread! Now that you are here, you really should spend 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
May 21, 2015 at 9:20 am
One of your top queries is from Activity Monitor. You should probably not have it open all the time. You're actually adding load to the server by doing that.
Let...
"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
May 21, 2015 at 4:56 am
artisticcheese (5/20/2015)
Grant Fritchey (5/20/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
May 20, 2015 at 4:57 pm
Viewing 15 posts - 6,046 through 6,060 (of 22,226 total)