Viewing 15 posts - 346 through 360 (of 22,219 total)
Microsoft has a couple of good examples. I'd strongly suggest you use option 2.
But!!!
The bigger question is, how did that happen in the first place? Cleaning it up is...
"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 8, 2023 at 3:56 pm
Share a little history, the compare engine in Visual Studio was licensed from Redgate years ago. Now, we've been tuning our engine since then. I don't think Microsoft has shown...
"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 7, 2023 at 12:53 pm
ddltbl
I promise, you'll never guess what that means. Never, ever, never. It was part of a naming standard at my old company that I raged against until it went 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
November 6, 2023 at 2:39 pm
So, probably not going to have a single book that explains "each topic in full depth".
I have two books that I've written, totaling about 1,300 pages between the two of...
"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 6, 2023 at 2:33 pm
It can be a weird line here.
At my previous job, we were moving our entire data center from one building to another. As part of it, we wanted to, just...
"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 6, 2023 at 2:26 pm
The lack of a response is pretty sus too.
"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 6, 2023 at 1:54 pm
Why are you duplicating this question? I don't see a link suggesting this is spam, but the answers to that almost identical question are going to be what you...
"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 5, 2023 at 1:37 pm
Hello ,
The SQL Server Windows NT - 64 bit" in Task Manager: memory high 10 gp , the overall server memory is now 95 % kindly advise the solution.
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 5, 2023 at 1:36 pm
Yeah, it's as @Ant-Green has it. You have to have the live data window open first. It only shows active events. However, you can directly open the file, and it...
"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 3, 2023 at 12:50 pm
A whole bunch more functionality available in Extended Events. Here's a blog post showing how to use them to troubleshoot timeouts. There's also other events mentioned in the post...
"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 2, 2023 at 1:58 pm
Just realized this is a six year old post. I still stand by what I said 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
November 2, 2023 at 1:55 pm
Extended Events!
I know, I know. It's sometimes all I talk about.
The issue is simple. Extended Events, the core underlying architecture, is pretty amazing and clearly used by all the different...
"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 2, 2023 at 1:50 pm
Here's an example. Probably best to trim some of the events away, and obviously you'll want a different set of filter criteria.
"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 1, 2023 at 12:20 pm
Extended Events, with causality tracking, can show you exactly when & how statistics get updated.
"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
October 31, 2023 at 1:04 pm
You've got the basics mostly right. Async updates will occur after, not query execution, but after the compile process is complete. This is why, you may still see almost instantaneous...
"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
October 31, 2023 at 1:02 pm
Viewing 15 posts - 346 through 360 (of 22,219 total)