Viewing 15 posts - 6,736 through 6,750 (of 22,219 total)
Local variables versus hard coded values versus parameters, you could be seeing parameter sniffing in action. The hard coded values will take an accurate measure of the statistics. The parameters...
"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
February 18, 2015 at 2:39 pm
Maybe I missed the .sql on the second one. It had the standard name for a window. My bad.
"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
February 18, 2015 at 2:36 pm
Is it possible it's coming in as read only? I work with various source control systems all the time and I'm not seeing a similar issue.
One difference between the 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
February 18, 2015 at 11:36 am
Compile time for the query and time to load everything into memory. Those are pretty standard costs that affect many queries the first time they're run.
"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
February 18, 2015 at 11:24 am
On a side note, make sure you change the Cost Threshold for Parallelism to something other than the default. That's going to affect how your processors get used in as...
"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
February 18, 2015 at 11:21 am
I would not look to replication as a DR or HA solution. It's mainly for data distribution for reporting, stuff like that.
Then, you need to break down HA and DR...
"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
February 18, 2015 at 11:20 am
Oh, and I wouldn't just do something to a table without consulting with the developer. If I have to show them the before and after execution plans, resource use 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
February 18, 2015 at 11:13 am
Since neither of you are sure if the cluster will improve or hurt performance, I'd suggest an experiment to find out. The real question is, from the heap, are 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
February 18, 2015 at 11:12 am
I'd love to see the plan that indicates a missing index. I've had a hard time getting interesting plans out of the memory-optimized queries.
You can create indexes. There are non-clustered...
"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
February 18, 2015 at 7:14 am
Selectivity is how unique any given value on a column or set of columns will be. This information is stored with the statistics for the index you create. The most...
"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
February 18, 2015 at 5:48 am
Any Threadizens going to make SQL Rally before SQL Bits. I'll be at both (which means I'll miss Wednesday at Rally).
"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
February 18, 2015 at 5:36 am
Jeff Moden (2/18/2015)
Steve Jones - SSC Editor (2/17/2015)
Grant Fritchey (2/17/2015)
Not mentioned is the OS. If I only have two drives, the OS on one and everything else on the other.
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
February 18, 2015 at 5:34 am
Not mentioned is the OS. If I only have two drives, the OS on one and everything else on the other.
"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
February 17, 2015 at 1:39 pm
Then all I can suggest is the standard stuff. Make sure you're queries are filtering on criteria where there are indexes. Add indexes if necessary. Update the statistics, possibly using...
"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
February 17, 2015 at 12:30 pm
Without the execution plan, nothing but vague guesses are possible.
"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
February 17, 2015 at 11:28 am
Viewing 15 posts - 6,736 through 6,750 (of 22,219 total)