Viewing 15 posts - 1,651 through 1,665 (of 22,227 total)
Good luck on it.
One point, document the time you spend on building & maintaining monitoring. Time absolutely is money. It's time you could be spending elsewhere on much more important...
"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
August 26, 2020 at 10:27 am
Ah, cool.
No, I'm not aware of any way you can do anything with data within the VMs other than what is normally provided. You'd have to move to RDS to...
"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
August 25, 2020 at 2:53 pm
To "get around licensing"?
No. You either have a licensed instance installed on a VM, or, you use the AWS RDS SQL Server instance, and the cost of RDS includes 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
August 25, 2020 at 11:34 am
If that's all you want, set up an Agent job that polls the servers to see if they're online or not. It won't be much work. You can store 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
August 25, 2020 at 11:30 am
I answered this over on stackexchange too. I'd use AZCopy to move the backups up to Azure Blob Storage, specifically where your VM has defined it's storage. Then, it's 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
August 25, 2020 at 11:20 am
Oh great point. Check for triggers. Secret little turkeys will get you every time.
"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
August 24, 2020 at 2:56 pm
Agreed. Please post the execution plan. It's just not possible to say what's going on without 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
August 24, 2020 at 12:45 pm
Out of the box, by default, Redgate SQL Data Compare will find tables with the same name to compare, as you noted. However, you can map tables with completely 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
August 24, 2020 at 12:43 pm
Without seeing the full structures, it's hard to say for certain. As was already stated, a normal view would not in any way affect this. Only the materialized/indexed views will....
"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
August 24, 2020 at 12:35 pm
In theory, it really is as simple as getting the production server back online, wait for the logs to get moved over, and then fail over back to production. 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
August 21, 2020 at 5:02 pm
Imagine the lady in Poltergeist: ALL ARE WELCOME!
Come on in. The water is fine. This is just the local water cooler (bubbler/fountain/whatever your local vernacular is for 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
August 21, 2020 at 1:11 pm
Generally, the way to recover this would be to bring the AG back online and let it sort itself out. In fact, you should be seeing ever growing log sizes...
"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
August 21, 2020 at 12:40 pm
The dots are part of the three part naming. They're supplying the database name, TEZ_BDW_TUT, skipping the schema name, '..', and supplying the table name, sor_ar_x_cl. The assumption is, 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
August 21, 2020 at 12:37 pm
As a (mostly) lurker on this esteemed forum for around five years, I've only recently come across this thread.
I've not managed to consume all 4000+ pages to find 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
August 21, 2020 at 11:46 am
Thanks, I also heard complex logic should handle in business layer not on database layer. Is that just some people's preference?
Don't get caught in absolutes. Put the logic where...
"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
August 20, 2020 at 4:54 pm
Viewing 15 posts - 1,651 through 1,665 (of 22,227 total)