Viewing 15 posts - 1,801 through 1,815 (of 22,232 total)
Heh... sounds almost as bad as the default trace. We blow through that in about 10 minutes.
Ha! Yeah, it is.
However, you can edit the system_health session if you want...
"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 12, 2020 at 10:02 am
Unless someone has explicitly turned it off, and since most people don't even know it's there, on every single server, 2012+, you have an Extended Events session running called system_health....
"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, 2020 at 11:10 am
Hi Guys ,
I have a very basic question regarding comparing 2 execution plans .
While comparing the execution plan i usually see Estimated sub tree cost of the left most...
"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, 2020 at 4:58 pm
However, the most likely culprit here is not that you defragmented the index. The most likely culprit is that, as part of defragging the index, the statistics were...
"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, 2020 at 3:12 pm
First up, defragging indexes isn't a great way to go about enhancing performance. In fact, the argument can be made that defragging hurts performance. If the index is fragmenting due...
"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, 2020 at 1:28 pm
I was able to attached the plan, please look at the actual plan and let me know your thoughts. Thanks!
Not sure what you uploaded, but it's not a .sqlplan...
"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 8, 2020 at 11:50 am
Great, Thanks!! yes, I was able to do SP call in the test environment and generate the actual plan. Attached. Please let me know your thoughts, I do not...
"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 5, 2020 at 8:07 pm
Welcome to the party! I hope you come back.
Yeah, you got it. If you have additional information you'd like to add as part of the insert, just plug it 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
June 5, 2020 at 2:22 pm
So, you're looking at the markers that SQL Server creates when you ask for an execution plan for Data Definition Language (DDL). There are no execution plans created for DDL....
"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 5, 2020 at 12:57 pm
Jeffrey:
Thanks for your patience. I will review the procedures for posting questions and the code you submitted to help me. About the joining ID to ID...I guess I wanted...
"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 5, 2020 at 12:51 pm
It'd be so much easier if you showed stuff in T-SQL since that's how we have to do all the work. However, let me take a stab at a pass...
"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 5, 2020 at 12:45 pm
Although, I might not have done it the right way. I deleted the account. I'm now wondering what the data cascade is looking like... Oops.
"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 3, 2020 at 11:30 am
I think I got rid of Stanley.
"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 3, 2020 at 11:29 am
Any admins about to ban https://www.sqlservercentral.com/forums/user/james500 ? He's spammed over 50 topics in the last hour with advertisements for counterfeit documents.
No idea how to ban someone, but I discovered...
"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
May 29, 2020 at 12:26 pm
Thanks Grant .. Can you suggest any tool to reduce the RTO?
The exact reason is the BC team want to reduce the RTO from 100 minutes we mentioned 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
May 27, 2020 at 5:53 pm
Viewing 15 posts - 1,801 through 1,815 (of 22,232 total)