Viewing 15 posts - 571 through 585 (of 22,227 total)
Trying to get different perspectives! May be I am looking at the things might not be the right. Getting awareness from wise people will definitely make me think with...
"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 20, 2023 at 9:19 pm
Other thing is, SQL optimizer has not suggested any missing indexes in the actual execution plan.
We are on SQL Server 2017 EE.
The optimizers suggesting for missing indexes are, at...
"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 17, 2023 at 5:36 pm
Should be relatively straightforward. A check constraint will have to perform some action to validate the data, let's keep it simple and say all values have to be > 0....
"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 17, 2023 at 5:33 pm
So, performance comes down to identical behaviors. A similar query running on a similar structure with similar data sets may, yeah, perform wildly different. This is because every little thing...
"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 17, 2023 at 5:27 pm
Oh yeah, take a look at the execution plan. You can just get an estimated plan, you don't have to execute the query. That will show you all the activity...
"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 17, 2023 at 1:27 pm
Almost impossible to tell you exactly what is wrong without more data. It could be as simple as you didn't commit your transaction. It could be blocking. Assuming you have...
"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 16, 2023 at 1:56 pm
It's simple. COALESCE as part of filtering criteria, WHERE/ON/HAVING, means that statistics and indexes can't be used becuase you're making a calculation. That's going to slow things down, leading to...
"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 16, 2023 at 1:52 pm
It does. It's just not obvious when looking at the XML. You can open the blocked process report as a report which will resolve the values for you. However, to...
"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 15, 2023 at 5:15 pm
I once built a system that could query for query text and then execute that. It was a way to intentionally allow people to inject SQL code into the system...
"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 15, 2023 at 1:06 pm
It's going to be the same as the other stuff we've been talking about. You have to capture metrics that show where the slow points are. Extended Events are your...
"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 15, 2023 at 12:52 pm
It's going to be the same as the other stuff we've been talking about. You have to capture metrics that show where the slow points are. Extended Events are your...
"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 15, 2023 at 12:52 pm
You don't want any one session to do too much. It makes it harder to distinguish the information, search for what you want, etc.. Plus, you put more of a...
"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 14, 2023 at 10:32 pm
Oof. Trace. Not extended events. These are even more resource intensive than extended events. I'd turn them ALL off and go with XE, especially because your system is already under...
"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 14, 2023 at 9:02 pm
Is the blocked process report running as part of query collection? It shouldn't separate those out. One as one session. One as another. And, yeah, capturing query metrics, especially at...
"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 14, 2023 at 8:16 pm
Oh, super cool!!! I guess I'll look around for tutorials on it. You wouldn't happen to know any, would you? (Check learn.microsoft etc?)
I don't have one I can recommend,...
"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 14, 2023 at 6:05 pm
Viewing 15 posts - 571 through 585 (of 22,227 total)