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....

• This reply was modified 5 years, 9 months ago by Grant Fritchey.

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...

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...

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...

Not sure what you uploaded, but it's not a .sqlplan...

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...

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...

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....

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...

• This reply was modified 5 years, 9 months ago by Grant Fritchey.

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...

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.

I think I got rid of Stanley.

No idea how to ban someone, but I discovered...

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...

If you have individual queries, and you can edit them, it...