Viewing 15 posts - 2,176 through 2,190 (of 22,232 total)
p.s. And stop using REORGANIZE for your index maintenance.
With the noted exception of columnstore indexes, but only when working in 2016 SP1 or greater.
"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 15, 2020 at 11:57 am
Actually a little shocked I got it right.
"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 14, 2020 at 2:40 pm
I was thinking more about hardware style solutions. Pure Storage has an internal snapshot mechanism that is fully transactionally aware. It would be worth pursuing, depending on your functional needs....
"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 14, 2020 at 1:22 pm
First, AlwaysOn is marketing speak. You want to talk about Availability Groups. That's the technical implementation that you'll be working with. Just knowing that will help all your web searches,...
"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 13, 2020 at 1:50 pm
If the database is sitting there, not being accessed, not being connected to, zero activity, nah, it's not hurting performance. It can't. It will affect storage of course, but again,...
"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 13, 2020 at 1:42 pm
In 2016 Sp2(?) or greater, that just means parallelism is occurring. What else?
"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 10, 2020 at 4:13 pm
If it's SQL Server, it has to be a query. Something has to be running there. Otherwise, it might not be SQL Server. However, I'd go with the Extended Events...
"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 10, 2020 at 2:55 pm
Do you have any favorite links on the subject of pulling rather than pushing?
Hmmmm ...
Nah thought I had one but no luck retrieving it.
I get better luck when...
"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 10, 2020 at 2:23 pm
Honestly, I thought we had pulled this from the product, but I was wrong. Here you go, object level recovery in Redgate SQL Backup.
"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 10, 2020 at 2:12 pm
Yes, I am replacing TRUNCATE with DELETE. There are around 150 tables in total & for around 80 tables I have to reset the identity. Rest, of 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 10, 2020 at 2:05 pm
Availability Groups will be an easier solution I'd think. Replication is just a big ball of trouble, without going into the fact that they have tables without primary keys (<sigh>)....
"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 10, 2020 at 2:01 pm
If it's SQL Server, then it's caused by queries. So, go and look at query behavior. There are three ways to do this, in order to accuracy and detail: DMVs...
"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 10, 2020 at 1:54 pm
In SSMS go to the first operator in the plan. Right click it. Select "Properties" from the list. A tab will open on the side. Pin that in place by...
"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 10, 2020 at 1:30 pm
What about using extended events to look for specific queries successfully completing?
"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 9, 2020 at 1:21 pm
Sure. Just not straight forward. On SQL Server 2014, you have really two good options. One will give you a general understanding of the behavior. The other will give 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
January 9, 2020 at 1:20 pm
Viewing 15 posts - 2,176 through 2,190 (of 22,232 total)