Viewing 15 posts - 6,631 through 6,645 (of 22,226 total)
t.mounika01 (3/6/2015)
"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
March 9, 2015 at 6:58 am
It sounds like a blocking or resource contention issue. Let's assume that your queries are tuned, but they suddenly start timing out. It's likely that there's one resource of query...
"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
March 9, 2015 at 6:53 am
What is the cost of the query as it currently exists?
Setting your threshold to 5 might work, but only if the cost of that query is over 5. If it's...
"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
March 9, 2015 at 6:46 am
ChrisM@Work (3/9/2015)
The optimiser has difficulty with more than seven or eight tables in the FROM list regardless of how they are joined. More than that and you are very likely...
"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
March 9, 2015 at 6:44 am
Most tables in most systems (and by most, 99% plus a few extra digits) should have a clustered index. It doesn't have to be unique as defined, although it's better...
"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
March 9, 2015 at 6:40 am
Assuming no data manipulation, you might also be able to use a scalar function. Due caution, testing, your mileage may vary, etc. But, it'll make the code a lot easier...
"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
March 9, 2015 at 6:37 am
Bouke Bruinsma (3/9/2015)
You might try creating a few views to break up the query.
I myself an against views altogether. The current view is part of an application. I can change...
"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
March 9, 2015 at 6:34 am
Without seeing the query and the plan, just speculation, but, timeout means that the optimizer went through the number of optimizations that it determined should arrive at a good enough...
"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
March 9, 2015 at 6:31 am
First option, use a table valued parameter. Here's documentation on how that works.
Another option, use Jeff Moden's scripts to turn comma delimited lists into a table. Here's documentation[/url] on that.
"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
March 9, 2015 at 6:26 am
Your process is not hung on CPU. You may need more memory, faster, or more, disks, or a faster network. You can use sys.dm_os_wait_stats to understand what precisely is causing...
"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
March 9, 2015 at 6:24 am
Eirikur Eiriksson (3/6/2015)
"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
March 7, 2015 at 1:48 am
Lynn Pettis (3/1/2015)
I am HOME!I had a nice dinner at Kassondra's house. I'm sorry, nothing beats good home cooking!
Well done sir.
"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
March 2, 2015 at 10:20 pm
Pretty much what Jeff says. Actually, that's just a good rule to live 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
March 1, 2015 at 10:12 pm
Lynn Pettis (3/1/2015)
Okay, getting close to boarding time. I am going to go dark. Next time I get on I will be home in beautiful Colorado Springs, Colorado
WHOOP!
That's...
"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
March 1, 2015 at 10:10 pm
Lynn Pettis (3/1/2015)
Brandie Tarvin (3/1/2015)
Lynn Pettis (3/1/2015)
By the way, I'm in Atlanta waiting for my flight to SLC.YAY! Welcome back to the U.S. of A., Lynn.
Thank you. It is good...
"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
March 1, 2015 at 7:40 am
Viewing 15 posts - 6,631 through 6,645 (of 22,226 total)