Viewing 15 posts - 7,846 through 7,860 (of 22,224 total)
jcrawf02 (7/1/2014)
Grant Fritchey (6/30/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
July 1, 2014 at 6:51 am
By the way, change that cost threshold value. The default value of 5 is way too low for most systems. I'd suggest bumping it to 50 for an OLTP system...
"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, 2014 at 6:50 am
Cost threshold for parallelism on both boxes. ANSI connection settings on both boxes. Get an estimated execution plan from both boxes and compare them.
"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, 2014 at 5:13 am
Check the execution plan for both. See what's being generated by the optimizer. That will help you understand if there is something mundane like statistics at fault, or if you're...
"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, 2014 at 5:11 am
That's actually a tough problem. If this were a SQL Server 2012 instance I would ask if it was possible that those clients be Read Only. In this case you...
"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, 2014 at 5:09 am
Yeah, if that equals NULL was in the WHERE clause I'd be laughing my bottom off.
"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, 2014 at 5:00 am
Also, if you're backing up to a remote drive across the network, check the network connectivity. That can seriously impact backup performance.
Check the wait statistics while the backup is running...
"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, 2014 at 4:58 am
I wouldn't worry about the indexes on 2014 more than I would on 2008. Whatever index rebuild you normally use should be fine. Traditionally many people will update their statistics...
"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, 2014 at 4:54 am
You should plan on testing that they work in every case. Some will, but others will require upgrades to the client components. There are new versions for SQL Server 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
July 1, 2014 at 4:52 am
Nice write up.
And you didn't say hello? Please do next time.
"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, 2014 at 4:47 am
New Born DBA (6/30/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
July 1, 2014 at 4:38 am
That's caused by a long running checkpoint operation, where the data gets written to disk from memory. It's not an indication of a memory leak. It's an indication of large,...
"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, 2014 at 1:42 pm
Tuning is a cyclical process that you just keep doing and doing. Basically you monitor a server, gather metrics on what's performing well, what isn't, what normal looks like, 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, 2014 at 1:36 pm
I don't know that I'd use ODBC. I'd rather go for as direct a connection as possible. You should be able to make a direct connection if it's Microsoft Azure...
"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, 2014 at 9:32 am
I have to say, this really sounds like interview questions. I'm only answering interview questions if I get the job.
"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, 2014 at 9:19 am
Viewing 15 posts - 7,846 through 7,860 (of 22,224 total)