Viewing 15 posts - 691 through 705 (of 22,224 total)
Ordering by a function is just going to kill you more and more as the data grows. Best suggestion I can make is to not do that. Nothing will make...
"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
December 16, 2022 at 1:22 pm
Nothing marks a table as being "used" by queries. You can look at sys.dm_db_index_usage_stats, assuming the table in question has indexes. That will tell you something of the access...
"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
December 16, 2022 at 1:18 pm
Create a file group in a different location and move those indexes to that file group.
"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
December 16, 2022 at 1:14 pm
Your best bet to see missed connections is setting up an Extended Event session and capturing the even connectivity_ring_buffer_recorded. That's the one mechanism I know that captures stuff like timeouts....
"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
December 16, 2022 at 12:47 pm
Does Red Gate SQL Monitor use Profiler traces or Extended Event traces?
By default, neither. It supports both. Extended Events is first though. We have several metrics that are taking...
"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
December 14, 2022 at 7:22 pm
OOps. Sorry. And yeah, that's really odd.
"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
December 14, 2022 at 7:11 pm
Another one?
Test
"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
December 14, 2022 at 1:43 pm
Post 16 in test
"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
December 14, 2022 at 1:43 pm
Sounds like you have encrypted connections enabled, but haven't set up certificates for those connections. How do you resolve it after the reboot currently?
"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
December 14, 2022 at 1:43 pm
Not one I've personally hit, but it looks like it's likely to be a permissions issue based on this article from Microsoft.
"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
December 14, 2022 at 1:42 pm
Latency?
I mean, if we assume everything else being equal, latency. Otherwise, it was something else, good, or bad, at one of the locations. Nothing else makes sense.
It 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
December 13, 2022 at 3:31 pm
First time I've hit. Just a little test, since I'm only running on a local machine with a container for a database, turning off Encrypt and you don't need the...
"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
December 13, 2022 at 2:15 pm
Latency?
I mean, if we assume everything else being equal, latency. Otherwise, it was something else, good, or bad, at one of the locations. Nothing else makes sense.
"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
December 13, 2022 at 2:12 pm
I have a magic phrase I've memorized and you can have it too.
"I don't know, but here's how I'd find the answer..."
Now, you have to have a plan...
"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
December 13, 2022 at 12:47 pm
Since you're talking non-production environments, I'd suggest doing side-by-side installs so you can be more assured of your results. Upgrading, and downgrading, are always fraught with potential issues. You 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
December 12, 2022 at 1:58 pm
Viewing 15 posts - 691 through 705 (of 22,224 total)