Viewing 15 posts - 2,221 through 2,235 (of 22,227 total)
This is not a parallelism issue. Don't go messing with MAXDOP.
No, you're hitting a classic deadlock problem. You need to follow the link to that article I provided. What's going...
"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
December 19, 2019 at 8:06 pm
Statements can certainly be the same. The question is, what the SPID of the two processes? If they're the same, you're experiencing parallelism deadlocks. If they're different, it's just 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
December 19, 2019 at 6:02 pm
As to the last film. How long have they known that they could launch a ship into space warp or whatever they're calling it and destroy every single thing in...
"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
December 19, 2019 at 4:54 pm
I think they had an opportunity with this new Star Wars film. They could have opened right at the moment the last one closed. Everyone is celebrating their "victory". Suddenly,...
"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
December 19, 2019 at 4:49 pm
I've not worked with Dynamics... is that one of those MS applications/databases that uses random GUIDs for keys?
Yes!
With database designs that would make Codd break down weeping. They practically...
"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
December 19, 2019 at 2:41 pm
In mean time i have found solution.
Tnx guys
BR
I assume a script (powershell or t-sql) and SQL Agent? That's how I'd do it.
Posting the solution would be helpful for anyone...
"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
December 19, 2019 at 1:24 pm
Thanks John, I was just starting to type a long screed.
Let me reinforce what John says. In SQL Server 2008 and better, you no longer need to implement trace flags...
"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
December 19, 2019 at 1:20 pm
If you're not seeing page latch waits as your number one wait type, by an enormous margin, then you should not be using the In-Memory tables & indexes. Period. They...
"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
December 19, 2019 at 1:17 pm
I don't know Dynamics well at all, so I did a quick search. Based on this, there are three possible timeout settings that you may need to adjust. I'd...
"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
December 19, 2019 at 1:04 pm
Happy Yuletide! Merry Christmas! Happy New Year!
Star Wars sucks (not the first two, chronological, films, just all the rest)!
Looking forward to going to see 1917 though.
"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
December 19, 2019 at 12:44 pm
RESTORE DATABASE name
WITH REPLACE, --if it's there already
MOVE 'file' TO 'x:\newfile.mdf',
MOVE 'log' TO 'z:\newlogfile.ldf'
Automate this.
However, I think Phil pointed out an excellent question, should development be occurring on a production...
"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
December 18, 2019 at 1:44 pm
Not necessarily replication. I'm very hesitant to ever suggest using that technology because it just doesn't get adequate support from Microsoft. No, instead, if you can write once and then...
"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
December 18, 2019 at 1:35 pm
Grant,
what would be a short checklist
of 1,2,3,... of things that DEFINITELY qualify a table for turning it into Memory Optimized and a list of COUNTERINDICATIONS against turning it 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
December 17, 2019 at 6:54 pm
Grant,
what would be a short checklist
of 1,2,3,... of things that DEFINITELY qualify a table for turning it into Memory Optimized and a list of COUNTERINDICATIONS against turning it 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
December 17, 2019 at 6:45 pm
In most cases, performance issues are in the actual code. If you post the ACTUAL execution plan, we might be able to see where the pain points are.
It 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
December 17, 2019 at 12:55 pm
Viewing 15 posts - 2,221 through 2,235 (of 22,227 total)