Viewing 15 posts - 14,851 through 14,865 (of 22,219 total)
Denny Cherry[/url] has a great little explanation of DTC.
"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
June 11, 2010 at 9:26 am
That was strange. The original text was meant for a different response
"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
June 11, 2010 at 9:18 am
I agree with Bhuvnesh, but I will add this: minimal access. Only give as much access as you absolutely have to, and no more.
"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
June 11, 2010 at 9:17 am
GilaMonster (6/11/2010)
Oops.
Ouch. It's kind of shocking, the fundamental ignorance about how these things work that seems to be so wide spread.
"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
June 11, 2010 at 8:53 am
Jeff Moden (6/10/2010)
Grant Fritchey (6/10/2010)
GilaMonster (6/10/2010)
Dan.Humphries (6/10/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
June 11, 2010 at 6:05 am
Real time monitoring & long term monitoring are different critters, as you're finding. We use Idera now. It can be tuned to capture more data than it's getting out of...
"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
June 10, 2010 at 12:49 pm
Again, not seeing everything, I suspect it's the two updates that are causing the issue. The INSERT & UPDATE is going to step on multiple pages or rows, in two...
"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
June 10, 2010 at 12:46 pm
I do this all the time on my local machines, laptop, workstation, etc., with no issues. I would not suggest you do this on a production system though. Installing &...
"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
June 10, 2010 at 12:38 pm
That process with an INSERT and UPDATE, I'm not shocked that it's deadlocking. You need to wrap it in a single transaction, not with two, which are both wrapped 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
June 10, 2010 at 12:30 pm
And don't forget, while PASS did not create SQL Saturday (Thanks Andy), it does now own it and provides the local groups the support structure so that they can run...
"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
June 10, 2010 at 11:53 am
Matt Miller (#4) (6/10/2010)
CirquedeSQLeil (6/10/2010)
Grant Fritchey (6/10/2010)
Jeff Moden (6/9/2010)
...nor do they knock their MVP rings...
Whoa! Hold on a sec... you got a ring? I didn't get a ring. If I...
"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
June 10, 2010 at 8:50 am
GilaMonster (6/10/2010)
Dan.Humphries (6/10/2010)
I do not activly seek such things but I am not sure you would be able to wipe the smile off my face with a sand blaster.
I...
"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
June 10, 2010 at 8:39 am
In order to reduce CPU usage, you need to know what is causing the usage to go so high. I'd suggest using the wait states to identify which processes are...
"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
June 10, 2010 at 7:54 am
Those are very large topics. I'd suggest starting with reading the Books Online to get the basic concepts down. Once you're there, swing by Paul Randal's blog. He's got tons...
"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
June 10, 2010 at 7:06 am
OUTPUT clause, as stated above, is the best approach, especially because it allows for multiple rows. But if you're only ever dealing with a single row, you can capture the...
"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
June 10, 2010 at 7:03 am
Viewing 15 posts - 14,851 through 14,865 (of 22,219 total)