Viewing 15 posts - 12,451 through 12,465 (of 22,224 total)
I'd check the execution plans. Something has to be changing there. I'm not a fan of cross-database queries anyway.
"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
May 27, 2011 at 4:43 am
Especially on a reporting system I would not suggest ditching parallelism. Usually reporting systems get the most help from parallelism.
However, if you've done the research and you're getting excessive waits...
"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
May 27, 2011 at 4:36 am
You have to do the hard slog. Gather performance metrics, capture wait stats, get the longest running and most frequently called queries, then start addressing the issues. There are extremely...
"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
May 27, 2011 at 4:33 am
Everyone has hit a lot of the highlights, I especially like checking the SELECT operator properties to see the compile & runtime values on params & the reason for early...
"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
May 27, 2011 at 4:25 am
Fraggle-805517 (5/26/2011)
Grant Fritchey (5/26/2011)
You're still guaranteed a recompile each time a temp table is created and first referenced.
Grant,
I understand that I will get recompile each time a temp table is...
"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
May 26, 2011 at 1:36 pm
Brandie Tarvin (5/26/2011)
Grant Fritchey (5/26/2011)
Brandie Tarvin (5/26/2011)
"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
May 26, 2011 at 1:32 pm
Fraggle-805517 (5/26/2011)
Grant Fritchey (5/26/2011)
You're still guaranteed a recompile each time a temp table is created and first referenced.
Grant,
I understand that I will get recompile each time a temp table is...
"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
May 26, 2011 at 1:32 pm
Brandie Tarvin (5/26/2011)
I'm not...
"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
May 26, 2011 at 11:53 am
GilaMonster (5/26/2011)
One very uncomfortable PM sent...From the posts the person has made, they are totally out of their depth. 6TB DBs, major perf problems and barely a clue.
How do people...
"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
May 26, 2011 at 9:39 am
Roy Ernest (5/26/2011)
Gianluca Sartori (5/26/2011)
Brandie Tarvin (5/26/2011)
GilaMonster (5/26/2011)
Roy Ernest (5/26/2011)
"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
May 26, 2011 at 9:37 am
Roy Ernest (5/26/2011)
"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
May 26, 2011 at 7:54 am
Jack Corbett (5/26/2011)
Isn't the compile time for large procedures why they changed to statement level compile with 2005? In theory the whole procedure should not need to be recompiled...
"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
May 26, 2011 at 7:06 am
Stefan Krzywicki (5/26/2011)
Gianluca Sartori (5/26/2011)
Jeff Moden (5/25/2011)
Gianluca Sartori (5/25/2011)
No way, the Summit is too far and too expensive for me.Especially now that I'm moving into freelance consulting.
You have the right...
"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
May 26, 2011 at 6:40 am
You're still guaranteed a recompile each time a temp table is created and first referenced.
"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
May 26, 2011 at 6:39 am
GilaMonster (5/26/2011)
Fraggle-805517 (5/26/2011)
"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
May 26, 2011 at 6:36 am
Viewing 15 posts - 12,451 through 12,465 (of 22,224 total)