Viewing 15 posts - 361 through 375 (of 22,227 total)
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
As Jeff says, I've learned not to argue with him, you can do it all in SQL Server. I've had bad experiences though.
So, yeah, you could do any combination 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
October 27, 2023 at 6:20 pm
Connection settings, others. It's something.
"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 27, 2023 at 5:54 pm
I'd need to see the execution plans to understand what's going on. Further, two different databases means, possibly, two different sets of data, two different sets of statistics, two 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
October 27, 2023 at 1:02 pm
Also, one thing to REALLY think about is backup and recovery. Storing files in the database means restoring those files with the database. That becomes a huge headache and can...
"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 25, 2023 at 3:18 pm
Sure sounds like someone tried to enable Azure Arc or something similar. You sure you don't have anything going there?
"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 25, 2023 at 2:21 pm
Strong, strong suggestion.
Don't.
Can you store files within SQL Server? Yes.
Is SQL Server good at storing and retrieving files? No.
However, if you're going to insist on doing it, then I'd focus...
"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 25, 2023 at 2:19 pm
Yes, great article and great comments, and a neat quote from Jeff. When recognition and praise is given where it is due, everyone benefits.
And getting upset when others do well...
"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 25, 2023 at 1:38 pm
Viewing 15 posts - 361 through 375 (of 22,227 total)