Viewing 15 posts - 2,296 through 2,310 (of 22,219 total)
Thanks for posting those.
The test system is moving 9 rows on an estate of 1.3 million. Production is moving 6.7 million rows on an estimate of 9.3 million. I think,...
"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 27, 2019 at 7:14 pm
They never reported back what the issue was. Usually, it's down to data.
"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 27, 2019 at 3:08 pm
It's difficult for me to believe that such a table exists and no one knows anything about it. Find who does and ask them.
Very good point, as usual.
"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 27, 2019 at 2:21 pm
There's no way to index this that will improve performance. So, you could modify the structure and store a computed column instead of the FUNCAveMile function, which you 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
November 27, 2019 at 2:06 pm
Best way I can think of is to do a little data exploration so you better understand the table (500+ columns... <sigh>), then, on a TEST system, try creating a...
"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 27, 2019 at 2:02 pm
I'm not aware of a tool that will do the work for you. However, check out DBATools. This software will make the migration easier, if not easy. Here's...
"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 27, 2019 at 1:53 pm
Yep, something is different between the two machines. What? Not a clue. Post the plans. If you need to, use SentryOne's Plan Explorer to anonymize the plans before you 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 27, 2019 at 1:50 pm
Duration & rows returned are in rpc_completed and/or sql_batch_completed Extended Events. That's how I'd capture this data if required. To my knowledge, you're correct, this is absolutely not in 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
November 27, 2019 at 1:37 pm
Break it all down into pieces for testing. The easy part is the database name of course. But, next, test that you're capturing only statements with ALTER in them. See...
"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 27, 2019 at 1:34 pm
If you do a large scale data purge, you may also see a very empty database file.
Shrinking a file is not the end of the world. If you have, let's...
"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 26, 2019 at 12:57 pm
A timeout is caused when resources are unavailable, causing excessive waits. So, something is going south there. You've narrowed it down to the EMC backup solution running. What do 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
November 26, 2019 at 12:52 pm
Not sure I agree here. There is a lot of paperwork, and both your agent and the lender ought to be walking you through these items. There are checklists...
"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 25, 2019 at 7:20 pm
Spin up containers. Easier, faster. Or, a VM on Azure. Again, easier & faster. Especially just for testing stuff out.
"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 25, 2019 at 3:15 pm
Database or not, listen to me, listen to Jeff, listen to both of us, you should be able to access a file system and retrieve these objects for display without...
"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 15, 2019 at 2:02 pm
X,
You're not wrong. It's not the choices I would make, but the way you've laid it out, they're not bad choices.Others may not agree, but I'd say that others 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
November 14, 2019 at 3:37 pm
Viewing 15 posts - 2,296 through 2,310 (of 22,219 total)