Viewing 15 posts - 3,331 through 3,345 (of 22,219 total)
Monitoring and observing the system will certainly tell you more than I can remotely. The one thing I'll say is that doing a differential every two hours, those differentials at...
"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
January 26, 2018 at 9:40 am
No way to say for 100% certain without at least the execution plan, but, best guess, those LEFT functions on the columns are going to lead to index scans. Same...
"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
January 26, 2018 at 4:27 am
System processes and other threads.
"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
January 25, 2018 at 12:12 pm
AlexSQLForums - Thursday, January 25, 2018 10:10 AMDid you do the following after migration
Use DB;
DBCC UPDATEUSAGE(DB);
GO
EXEC sp_updatestats;
GO
Why would you immediately run sp_updatestats on slow...
"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
January 25, 2018 at 12:11 pm
No. It's not the same as measuring threads. It's just the users connected to the database. Generally, there's probably a 1:1 correlation a lot of the time. However, it won't...
"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
January 25, 2018 at 10:09 am
The best way to monitor this in 2012 would be using Extended Events. However, it does require that you set it up and maintain it. There's nothing automatic that does...
"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
January 25, 2018 at 9:00 am
Good Morning Experts,
We had a database on SQL Server 2012. INSERTS were running fine....
"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
January 25, 2018 at 8:58 am
"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
January 24, 2018 at 1:40 pm
Also, you have to have a way of identifying the user. This means one of three options. One, everyone has an independent login on the database. Two, everyone is using...
"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
January 24, 2018 at 1:00 pm
"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
January 24, 2018 at 5:35 am
"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
January 24, 2018 at 4:39 am
"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
January 24, 2018 at 4:37 am
So, collective wait stats, everything since the dawn of time, are somewhat interesting, but not terribly useful really. They will tell you where the principal waits are on your system...
"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
January 24, 2018 at 4:32 am
Oh, and since everyone and their brother will shortly be correcting me, saying that they're uncommitted isn't strictly speaking true. They were committed, but are not yet transmitted, hence they're...
"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
January 23, 2018 at 5:36 am
Has the Availability group processed the changes between the databases (Primary to secondary) when you do the backup? It's going to retain changes as uncommitted until they go through 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
January 23, 2018 at 5:34 am
Viewing 15 posts - 3,331 through 3,345 (of 22,219 total)