Hi all,
I have a question for you, as some move into the cloud and on Prem SQL databases become SQL Azure DB's I wonder what housekeeping jobs are required in SQL Azure DB's (by that I mean single db's, elastic pools and serverless - NOT Managed Instances or VM's running SQL in Azure.
With a standard VM (or on Prem) we would do the following
CHECKDB
BACKUPS (DB and Logs)
INDEX, STAT Maintenance
LOG WAIT STATS - for reporting purposes
CYCLE ERROR LOGS
OTHER SCRIPS - Such as health check scripts - i.e Brent Ozar's scripts.
I wondered what people thought to doing these in Azure, for example our backups are done using Azure so they would be pointless, as would check db but what about the others and have I missed any.
Thanks,
Nic
Everything except OS and backup related.
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
October 19, 2021 at 1:48 pm
Yep, what @johan says.
Think internal and external to the database. External to the database, server and OS level stuff, no. It's not there to worry about. Internal to the database, statistics, indexes, code, structures, yes. So, minimum, some statistics maintenance is probably in order. Index defrags... meh. I lean away from those more and more as I've seen the work done by Jeff & others. But that's the dividing line, internal vs. external.
"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
October 27, 2021 at 1:29 pm
Thanks for the replies on this, makes total sense, follow up question, how would you go about calling the code to do these, I'm personally thinking some stat maintenance, perhaps a little index maint for some of my more funky tables where I know I have some fragmentation issues and the vendor has no plans to resolve them anytime soon.
Thanks,
Nic
October 27, 2021 at 1:56 pm
There are like 20 different scheduling tools in Azure. Pick one. Any one. Use that.
"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
October 27, 2021 at 1:58 pm
Thanks Grant, thats what threw me, looking round I saw about 10 different ways of doing it.
As you say I'll pick one and get it done.
Thanks again.
Nic
October 27, 2021 at 2:18 pm
yeah, on the one hand, they make it easy. On the other hand, which damned one is best? I'm not sure there's a perfect answer.
"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
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply