Viewing 15 posts - 7,606 through 7,620 (of 22,232 total)
Or, you'll need to uninstall and then reinstall SQL Server. Not my preferred approach, but one that will work.
Be sure you have good backups in place before you do any...
"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 14, 2014 at 9:20 am
mqbk (8/13/2014)
It turned out that the configuration for the NIC teaming was the issue along with errors in the switches. Once they were corrected, the timeouts went away.
Thanks for 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 14, 2014 at 8:42 am
Interesting stuff. Thanks for posting the follow up. Clearing the cache as a mechanism for dealing with bad parameter sniffing is somewhat problematic. You might want to look to plan...
"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 8, 2014 at 4:52 am
GilaMonster (8/5/2014)
Grant Fritchey (8/5/2014)
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 5:34 pm
smtzac (8/5/2014)
TDE is enabled, do you think page compression will work?
Possibly. If I remember correctly (and we're going off my memory, so Katy bar the door), they compress before they...
"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 5:33 pm
Eirikur Eiriksson (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 5:31 pm
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
Viewing 15 posts - 7,606 through 7,620 (of 22,232 total)