Viewing 15 posts - 9,751 through 9,765 (of 22,224 total)
Off the top of my head, no.
It sounds like the optimizer, because the function, assumed it needed to bring back all the data in order to filter it down. But...
"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 14, 2013 at 5:42 am
Still pretty much back to where I was. You'll note that one is moving all the data and the other is not. I suspect that the functions on the data...
"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 14, 2013 at 4:23 am
Remote scan is pretty much what it says, a scan against a remote machine through linked servers. I didn't talk about that in the book. Maybe something I should add.
So,...
"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 14, 2013 at 3:26 am
I'd suggest going to the moment in time when that occurred and look at the top 10 queries. You may have to bounce around the time a little bit 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
June 14, 2013 at 2:50 am
I'm with Ed. The Client Statistics are really only useful if you want to measure round-trip time, from the client to the server and back to the client. They're just...
"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 14, 2013 at 2:46 am
Short answer, yeah, the files will be available. Longer answer, go here to get Microsoft's word on how this works.
"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 14, 2013 at 2:43 am
Yeah, I'm with everyone else. Really sounds like query tuning needs to happen immediately. Sometimes throwing hardware at a problem doesn't make it better. In addition to Gail's articles, check...
"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 14, 2013 at 2:41 am
You don't need to see the actual plan to see if it's doing a parallel execution. You can pull the plan out of cache for the query, while it's 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
June 14, 2013 at 2:39 am
Since you're on SQL Server 2008, you don't actually have to rely on the traceflags any more. The system_health extended event session will record deadlock graphs that will allow 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
June 14, 2013 at 2:34 am
You might try using a derived table and getting TOP 1 with an ORDER BY to get the latest version instead of the > operator. Something like the code I...
"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 14, 2013 at 2:32 am
SQLRNNR (6/13/2013)
You guys have a "widget" on your blog that allows the display of certain icons or badges (e.g. MVP...
"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 14, 2013 at 1:13 am
Stefan Krzywicki (6/13/2013)
Grant Fritchey (6/13/2013)
Stefan Krzywicki (6/13/2013)
The Dixie Flatline (6/13/2013)
Sean Lange (6/13/2013)
Steve Jones - SSC Editor (6/13/2013)
The Dixie Flatline (6/13/2013)
Brandie Tarvin (6/13/2013)
The Dixie Flatline (6/13/2013)
"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 13, 2013 at 10:06 am
Stefan Krzywicki (6/13/2013)
The Dixie Flatline (6/13/2013)
Sean Lange (6/13/2013)
Steve Jones - SSC Editor (6/13/2013)
The Dixie Flatline (6/13/2013)
Brandie Tarvin (6/13/2013)
The Dixie Flatline (6/13/2013)
"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 13, 2013 at 9:33 am
Gary Varga (6/11/2013)
chrisn-585491 (6/11/2013)
I can see a scenario where organizations turn to cloud based services to host their e-commerce database or quickly spin up some one-off analytical solution requested by...
"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 11, 2013 at 11:38 am
Gary Varga (6/11/2013)
"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 11, 2013 at 7:47 am
Viewing 15 posts - 9,751 through 9,765 (of 22,224 total)