Viewing 15 posts - 7,606 through 7,620 (of 22,226 total)
sqldriver (8/5/2014)
Grant Fritchey (8/5/2014)
"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
August 5, 2014 at 10:35 am
If you have Enterprise SQL Server you can turn on compression
"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
August 5, 2014 at 9:22 am
Short answer, costing. Has to be something in the calculation engine that makes that determination. Not something I know. Adam might. Paul probably would.
"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
August 5, 2014 at 9:20 am
I'll bet if you compare costs by forcing plans to parallel using the trace flag, you'll see that, for whatever reason, the plans are higher in the systems where it's...
"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
August 5, 2014 at 9:10 am
Wait a sec, if you're offloading DBCC checks, the one check you can't offload is PHYSICAL_ONLY. That one check must still be run on the original. Then, it's all 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
August 5, 2014 at 9:04 am
I think it's a crazy requirement, but the only option you have is to rewrite the query without using the temp table. You could try using whatever query loaded 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
August 5, 2014 at 9:02 am
Nice.
We need one for DBAs.
"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
August 5, 2014 at 8:59 am
The tools available within SQL Server for monitoring the VM level stuff (memory, cpu, some disk counters depending on your VM) are pretty much non-existent. SQL Server and it's tools...
"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
August 5, 2014 at 8:04 am
GilaMonster (8/5/2014)
Koen Verbeeck (8/5/2014)
GilaMonster (8/5/2014)
Koen Verbeeck (8/5/2014)
GilaMonster (8/5/2014)
What do you mean? What kind of questions they'll ask in what context?I guess in a job interview.
In that case, for 5+ years...
"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
August 5, 2014 at 4:29 am
Are you getting deadlocks or are you getting blocks. I'm unclear based on the information.
But, no, the situation you're describing sounds quite abnormal. I'd need to see more about 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
August 5, 2014 at 4:22 am
I asked the same questions I asked someone with 2-3 years of experience. I just expected better answers. Also, when we get to the open-ended questions, I expect answers with...
"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
August 5, 2014 at 4:14 am
So far as I know, the approved method is to check to see if the server is the primary. I'm sure you could write a PowerShell routine that cycles through...
"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
August 5, 2014 at 4:11 am
The differences between Standard and Enterprise could be part of it. There are options within the optimizer that are different there. But, it probably comes back to the available memory...
"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
August 5, 2014 at 4:01 am
homebrew01 (8/4/2014)
SQLRNNR (7/31/2014)
In both cases, you can upgrade from 2000. I might even restore the database onto the 2008R2 box and leave it in compat 80 for a few...
"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
August 5, 2014 at 3:57 am
Some of the memory and CPU measurements within a VM become problematic. Again, I'd drill down to the specifics instead of using the average, but you might also want 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
August 5, 2014 at 3:48 am
Viewing 15 posts - 7,606 through 7,620 (of 22,226 total)