Viewing 15 posts - 18,886 through 18,900 (of 22,219 total)
Monitoring stored procedures is best done by running what is called a server side trace. You can use the tool "Profiler" to define the trace and then script it out...
"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
January 5, 2009 at 6:39 am
Keep hacking away at it, you'll arrive at something useful. In the mean time, you might want to pick up a book on database design. The one I like 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
January 5, 2009 at 6:29 am
motanihatim110 (1/4/2009)
Thanks for reply.
It is not actually eConnect but modified version (smart connect which is eonesolution product and that is also modified by eonesolution for us). I dont know how...
"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
January 5, 2009 at 6:17 am
rajg (1/5/2009)
"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
January 5, 2009 at 6:05 am
It sounds like you're taking the approach I would have expected based on all my readings on this topic. Logical and straight forward, playing against the strengths of each technology....
"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
January 5, 2009 at 5:53 am
Jeff Moden (1/2/2009)
Grant Fritchey (1/2/2009)
"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
January 5, 2009 at 5:48 am
JoeA (1/2/2009)
I'm on a team that is reengineering a very large application...
"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
January 2, 2009 at 1:03 pm
Jack Corbett (1/2/2009)
"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
January 2, 2009 at 10:02 am
I just repeated your tests and did not get your results.
Just a guess, did you highlight it exactly the same way both times? Meaning, including carriage return and line feeds...
"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
January 2, 2009 at 9:58 am
I may as well be the dissenting opinion.
It depends on the complexity of the joins. When we're talking about simple, say fewer than 15 or so, tables joined together,...
"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
January 2, 2009 at 8:46 am
There is less disparity between the estimated & the actual, so that's good. You've still got a missing JOIN predicate. That should get fixed.
I still suggest you run UPDATE STATISTICS...
"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
January 2, 2009 at 8:41 am
Maybe a change to the connection settings? This will cause a new plan to be compiled.
"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
January 2, 2009 at 7:30 am
At least show what you've tried that hasn't worked.
"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
January 2, 2009 at 7:22 am
AndyG (1/2/2009)
"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
January 2, 2009 at 6:46 am
wagner crivelini (1/2/2009)
When I wrote this article I had in mind that not all T-SQL beginner are completely unaware...
"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
January 2, 2009 at 6:34 am
Viewing 15 posts - 18,886 through 18,900 (of 22,219 total)