Viewing 15 posts - 17,806 through 17,820 (of 22,226 total)
1204 puts out a hard to use deadlock graph. If you can, can you recapture it using traceflag 1222? That one is much cleaner and easier to read.
"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
April 6, 2009 at 1:20 pm
Check the actual execution plan. In the properties of the various processes it will show you if you're using parallelism and how many threads were used by the process.
"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
April 6, 2009 at 1:00 pm
Excellent. Glad you tracked it down. Thanks for posting the solution here.
"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
April 6, 2009 at 11:33 am
I'm really against a black list. I'm far too likely to end up on it one day. Plust I'm probably not going to consult it until I've already stepped into...
"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
April 6, 2009 at 11:32 am
Wilfred van Dijk (4/6/2009)
Yes, I know the meaning of this error, but why is the same statement giving this error in a Job and not in a query window???
Assuming 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
April 6, 2009 at 8:31 am
Best wishes Roy.
"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
April 6, 2009 at 7:36 am
There's no 100% sure way to verify that things are not used in your database. As others have outlined, it's possible to see whether or not things have been accessed...
"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
April 6, 2009 at 7:29 am
Something is holding a lock on your system. It could be a long running process or an uncommitted or unrolledback transaction. Try looking at sys.dm_os_waiting_tasks or sys.dm_tran_locks to see what'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
April 6, 2009 at 7:22 am
Don't use auto shrink. That's a major performance hit in most circumstances. If you've had some kind of over-sized transaction or error with the log backups or something that caused...
"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
April 6, 2009 at 7:13 am
That warning is pretty straight forward. Somewhere in the code a string is getting placed that's just too long.
Also, on a side note, instead of using @@IDENTITY, I'd suggest you...
"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
April 6, 2009 at 7:09 am
San (4/6/2009)
Somehow I managed to install SQL2k5 with different instance name and logged using "machineName\instanceName". Now another problem is that, when I select " " option in SERVER NAME...
"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
April 6, 2009 at 7:03 am
I liked the podcast even more than the editorial.
I don't think you were only pointing at those asking questions when you suggested we needed to treat others as we...
"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
April 6, 2009 at 6:49 am
While that does allow a single procedure to act on multiple tables, you're still only getting a single table per insert statement. You're just rigging the insert statements to sort...
"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
April 5, 2009 at 3:03 pm
Limiting parallel execution only eliminates deadlocks if the deadlocks are being caused by parallel execution. There are plent of instance where it's not.
In addition to use MAXDOP on the 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
April 5, 2009 at 3:02 pm
Right! Time to bring in the HR department.
"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
April 3, 2009 at 4:35 pm
Viewing 15 posts - 17,806 through 17,820 (of 22,226 total)