Viewing 15 posts - 14,176 through 14,190 (of 22,224 total)
Even without an execution plan, I count five (5) different IN statements and I see a number of functions on columns in the WHERE clauses. Those alone will kill performance.
"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
October 6, 2010 at 6:06 am
What about setting up a server side trace to monitor for that query? You can capture who is calling it, when, from where, pretty much everything you need.
"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
October 6, 2010 at 6:03 am
Although, using sys.dm_exec_requests won't show blocking if parallelism is involved.
Another way to do it, and you can use almost the same query, is to look at sys.dm_os_waiting_tasks.
"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
October 6, 2010 at 6:01 am
Less than a thousand to go. I think it'll take another couple of days, but it's sure to be this week.
"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
October 6, 2010 at 5:54 am
GilaMonster (10/5/2010)
sqlbuddy123 (10/5/2010)
My two cents..You can check these books to become a master
I'll disagree slightly...
Books alone will not make you a master. Books + experience + experimentation may, with sufficient...
"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
October 6, 2010 at 5:41 am
Derrick Smith (10/5/2010)
"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
October 6, 2010 at 5:39 am
GilaMonster (10/6/2010)
Does anyone think my response here was over-the-top? http://www.sqlservercentral.com/Forums/FindPost999124.aspx
Not even a little bit. Very clear, to the point, fact based... looks fine to me.
"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
October 6, 2010 at 5:36 am
bitbucket-25253 (10/5/2010)
Just have to throw my 2 cents in and help the count along ....Now how many members of the thread will be coming to SQL Saturday#60 in Cleveland......
Sorry, 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
October 6, 2010 at 5:34 am
John__A (10/5/2010)
Grant Fritchey (10/5/2010)
"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
October 5, 2010 at 1:55 pm
Alvin Ramard (10/5/2010)
Steve Jones - SSC Editor (10/5/2010)
Perhaps Gail could practice some archery in view of the office. Maybe aim for low down on the torso 😛
Waving a shiny piece...
"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
October 5, 2010 at 1:54 pm
I can't point to specifics, but I've seen anecdotal evidence that suggestions in some edge cases, the changes to the optimizer between 2000 and 2005 can product sub-optimal execution plans....
"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
October 5, 2010 at 11:39 am
GilaMonster (10/5/2010)
We're officially in UAT, though both the front-end dev and I are still developing. Had a meeting...
"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
October 5, 2010 at 11:24 am
A friend of mine just posted an excellent little PowerShell script that might be something you're looking for. Check out Aaron Nelson's blog post[/url].
"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
October 5, 2010 at 11:01 am
The problem with a lot of the perfmon counters and a recommended value is that so much of it depends on the system where you're running them. For example, I/O...
"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
October 5, 2010 at 10:58 am
Piling on a little bit, I think Steve sells himself a little short. Basically, if I wanted to learn something in or around SQL Server, he lists the three sources...
"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
October 5, 2010 at 10:53 am
Viewing 15 posts - 14,176 through 14,190 (of 22,224 total)