Viewing 15 posts - 14,356 through 14,370 (of 22,224 total)
Rebuilding the indexes should have also rebuilt the statistics, so I wouldn't necessarily assume that's where the problem lies. Without seeing the queries & execution plans it's hard to know...
"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
September 14, 2010 at 6:28 am
coolwebs (9/13/2010)
SELECT usecounts,
cacheobjtype,
...
"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
September 13, 2010 at 1:05 pm
I agree with the ANSI settings. That can result in different execution plans for the same procedure. But, you might also be seeing parameter sniffing. Are all the apps 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
September 13, 2010 at 12:46 pm
Blanket statements are usually worthless, so with that in mind...
I'd suggest, at a minimum, making the PK's clustered instead of non-clustered. Probably they're the best access path to 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
September 13, 2010 at 12:43 pm
I think in this case it would be "with friends like these, who needs anchors." Works at about the same I imagine.
"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
September 12, 2010 at 7:22 pm
GilaMonster (9/12/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
September 12, 2010 at 10:42 am
Steve Jones - Editor (9/10/2010)
Holy Smoke - Be prepared to laugh out loud http://is.gd/f4cHh (Facebook)
Can't get to Facebook from work and my phone won't let me watch Flash (damn Verizon...
"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
September 10, 2010 at 9:24 am
Stefan Krzywicki (9/10/2010)
Grant Fritchey (9/10/2010)
Jack Corbett (9/10/2010)
Steve Jones - Editor (9/10/2010)
I always find time to read. Keeps me sane with...
"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
September 10, 2010 at 8:16 am
GilaMonster (9/10/2010)
Jeff Moden (9/10/2010)
I don't have the time to read many books but that was a good one.Title? Author?
Here you go. First in a trilogy. Ancient stuff.
"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
September 10, 2010 at 8:04 am
Jack Corbett (9/10/2010)
Steve Jones - Editor (9/10/2010)
I always find time to read. Keeps me sane with a break from this...
"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
September 10, 2010 at 8:02 am
Yeah, I like using trace events to see what's being run against the database and then determine where to spend my time tuning.
"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
September 10, 2010 at 7:57 am
In addition to Gail's advice, try some of the classic deadlock resolutions. Check the code to ensure that everything is accessing the tables involved in the same order, stuff like...
"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
September 10, 2010 at 7:47 am
I'd suggest reading through this article[/url] from Jeff Moden. He really lays down some great methods for going through comma seperated fields like 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
September 10, 2010 at 7:46 am
First, the positives:
Way to go on pointing out that you need to validate data during the tuning process. This is something that it's far too easy to assume and doesn't...
"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
September 10, 2010 at 6:30 am
Instrumentation into the TSQL code itself? Heck no. But we do use trace events to monitor our apps & databases & servers in development, qa and production, in order 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
September 10, 2010 at 6:11 am
Viewing 15 posts - 14,356 through 14,370 (of 22,224 total)