May 3, 2023 at 6:32 pm
Hello,
Can you please suggest some of the useful db maintenance tasks which can be run against the database hosted in the AZURE Managed instances?
Thanks.
May 4, 2023 at 9:21 am
same as with an on-prem Sql server instance
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
May 4, 2023 at 1:15 pm
Just remember, Managed Instance is a SQL Server instance. The server aspects are gone, so no worries about that. However, all the internals are still there. So, database consistency, that's on you. Microsoft is doing backups, but, boy, I'd make sure what they're backing up is good. Statistics maintenance. Monitoring. Any & all database internals. If you're still a fan of defragging indexes, again, that's on you (personally, I'd follow Jeff Moden's guidance on this and stop doing it). It's a PaaS service, like Azure SQL Database, but one step up so that it makes it easier to lift & shift (cross database queries being the big, big, win).
"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
May 4, 2023 at 1:26 pm
Thanks Johan, Thanks Grant. Can you please share the link containing Jeff Moden's guidance regarding not to do the index maintenance in the Azure MI?
Can you please provide the equivalent suggestions for the Azure SQL DB mentioning the required maintenance which should be scheduled on a daily basis?
Thanks.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply