Viewing 15 posts - 706 through 720 (of 22,220 total)
SQL Server 2022 Forum on SQLServerCentral
"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 8, 2022 at 1:28 pm
All set. I tested to make sure posts can go up, so you should be ready to go. Ask away!!
"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 8, 2022 at 1:28 pm
Good point. I'll see what I can do.
"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 8, 2022 at 1:18 pm
Make sure you turn on blocked process report in Extended Events. It'll be a lot easier to KNOW what's going on rather than relying on some random people on...
"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 8, 2022 at 1:14 pm
It's not traditional ghost rows. Those are from a simple delete and you'd never see what you're seeing (I stand by my very first post in this thread on that...
"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 6, 2022 at 8:16 pm
You didn't indicate schema in your pseudocode. Did you use schema name in your query? (Recommend you always do to avoid ambiguity) Any tables, views, or synonyms w/ 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
December 6, 2022 at 2:19 pm
Also, the code didn't include the clustered index that is clearly there in the plan and the picture of the table.
"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 6, 2022 at 2:17 pm
Ah, so RCSI and Availability Groups. That changes things.
So, yeah, what's happening is, because you have RCSI, it has to keep those version records. Normally, those get cleaned up, but,...
"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 6, 2022 at 2:16 pm
If there are 50k reads, there's some data somewhere. Without seeing the query, your structures, the execution plan, nothing but the version of SQL Server, which, sorry, communicates just almost...
"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 6, 2022 at 9:49 am
I have a magic phrase I've memorized and you can have it too.
"I don't know, but here's how I'd find the answer..."
Now, you have to have a plan for finding...
"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 6, 2022 at 9:44 am
Just guessing here, but if the data was ordered first, so that you're doing your batches in the same order that the data is already stored in, you'll likely see...
"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 6, 2022 at 9:40 am
Piling on a little. It's truly dependent on the load of the system, data size, number of transactions, transaction size, database design, statistics, indexes, code, code, code, system settings, version,...
"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 2, 2022 at 9:18 am
They will tell you right up front if you have to pay for anything, and what that cost is. Just go straight to the source.
"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 1, 2022 at 11:25 am
In addition to @Ant-Green's excellent answer, after you get the backups working, practice doing restores. Do a full restore, then do point in time restores with the logs. Make sure...
"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 1, 2022 at 11:22 am
Again, we're talking theoretical. I don't have a specific answer I can give you on this question. Either could work. Either could work well. Testing is your best friend. This...
"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
November 30, 2022 at 10:13 am
Viewing 15 posts - 706 through 720 (of 22,220 total)