Viewing 15 posts - 18,481 through 18,495 (of 22,219 total)
In addition to simply observing performance degrade, have you collected information from performance monitor to see if buffer cache hit ratio (just for one example) is maintaining over time or...
"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
February 5, 2009 at 10:36 am
That is scary. However, I wouldn't worry too much (worry some, yeah).
I'm hesitant to suggest what to do since this is PeopleSoft, but let's assume for a moment that 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
February 5, 2009 at 10:22 am
Possibly. But I think there might be some samples for how to do it locally.
"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
February 5, 2009 at 10:14 am
Run the query with an explicit open transaction statement:
BEGIN TRANS
...
Don't put in a commit until you're complete with your testing.
"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
February 5, 2009 at 10:11 am
To give you a complete answer, you'd need to post the code, deadlock graphs, database structures, etc.
To make a few suggestions, Does the table have any other clustered index? If...
"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
February 5, 2009 at 7:42 am
Mahesh Bote (2/5/2009)
[font="Verdana"]Grant Fritchey (2/5/2009)
The last post is close...Grant i didn't get you.
Mahesh
[/font]
Your post is close to the answer. The thing is, SCOPE_IDENTITY will only work for a single row...
"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
February 5, 2009 at 7:34 am
Lynn Pettis (2/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
February 5, 2009 at 7:00 am
psangeetha (2/5/2009)
My criteria is when the parent rows are deleted, I dont want...
"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
February 5, 2009 at 6:09 am
It's possible for the compile time to be outrageous. We had an 80 table JOIN, plus an extensive WHERE clause that took 45 seconds to compile but only about 1.5...
"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
February 5, 2009 at 5:55 am
The last post is close. You do want to use the OUTPUT clause. But instead of trying to use it one row at a time, which is likely to be...
"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
February 5, 2009 at 5:51 am
colin Leversuch-Roberts (2/5/2009)
but I found the documentation to be...
"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
February 5, 2009 at 5:44 am
KSB (2/4/2009)
The first question I would ask is, do you really need 8000+ rows?
Yes, I want all these 8000 rows.
For example, you're getting a scan on dim_project_secure's clustered...
"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
February 5, 2009 at 5:41 am
1) It's just not open for the kind of manipulation I'm used to making
2) I don't have access to the tools it needs
3) Because I've been told to keep my...
"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
February 5, 2009 at 5:35 am
The only problem with Trace, and it's rather big, is that it's single threaded. So instead of multiple threads for multiple sessions, you get a single thread for all sessions....
"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
February 4, 2009 at 6:06 pm
And I've been staying out of the way since this was identified as PeopleSoft. Same approach I take at work.
"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
February 4, 2009 at 6:04 pm
Viewing 15 posts - 18,481 through 18,495 (of 22,219 total)