Viewing 15 posts - 6,781 through 6,795 (of 22,219 total)
If you don't update your statistics the optimizer will make bad choices for your query plans. This can seriously negatively impact performance. So, large database or not, you have 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
February 5, 2015 at 7:09 am
Brandie Tarvin (2/5/2015)
Do you agree or disagree that trick questions are...
"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 5, 2015 at 6:47 am
Cody K (2/5/2015)
Yes the graphs are definitely the same. I mean it's not the same row/page but they're all on the same table, same queries, same combination of indexes.
Perfect. Then...
"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 5, 2015 at 5:48 am
right, the object definition.
"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 5, 2015 at 5:48 am
Yeah, it's really an issue with the servers and their configuration.
But, that's not to say that tuning won't help. Reduce the amount and number of reads you need and then...
"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 5, 2015 at 4:51 am
One option is to hang your shingle as it were on a blog. I know a lot of people who get work that way.
"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 5, 2015 at 4:49 am
Everything Dwain has said so far is spot on.
So, to your first question, is it ok and will it help performance to defragment your indexes daily.
Sure. If you have 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
February 5, 2015 at 4:45 am
You basically have to rebuild the table, twice. Once to remove the old clustered index and once to add the new one.
"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 5, 2015 at 4:36 am
Any chance your query is using NO_LOCK?
That can absolutely lead to missing rows.
"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 5, 2015 at 4:35 am
Yeah, someone has 'sa' privileges.
You might also look at the system_health extended event session. It captures some modifications along these lines (but not all).
"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 5, 2015 at 4:34 am
I'm with Gail. It's very likely that your process is working, but capture the deadlock graphs from production just to be sure that you're dealing with the same objects. Then...
"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 5, 2015 at 4:32 am
ChrisM@Work (2/5/2015)
Grant Fritchey (2/4/2015)
SQLRNNR (2/4/2015)
Grant Fritchey (2/4/2015)
Sioban Krzywicki (2/4/2015)
Some of it is probably the sport you're focusing on. Two of the sports were football and field events (shot put, discus,...
"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 5, 2015 at 4:06 am
patrickmcginnis59 10839 (2/4/2015)
dwain.c (2/4/2015)
patrickmcginnis59 10839 (2/4/2015)
dwain.c (2/4/2015)
SQL Query invoked by Crystal Reports v9.2 Performance Issue
I'm a great believer in...
"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 5, 2015 at 3:52 am
SQL_Surfer (2/4/2015)
Actually, finally came up. But i see only one plan in the cache. Should I be seeing two for parameter sniffing?
No, not for a bad parameter sniffing problem.
"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 5, 2015 at 3:51 am
SQL_Surfer (2/4/2015)
As soon as I take the recompile option out, web hangs...Process goes to runnable step and never finishes for me to get to the execution plan.
Get the estimated 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
February 5, 2015 at 3:50 am
Viewing 15 posts - 6,781 through 6,795 (of 22,219 total)