How do you turn off an instance of Azure?

Question

Post reply

How do you turn off an instance of Azure?

Doctor Who 2

SSCrazy Eights

Points: 8177
More actions
July 20, 2016 at 10:04 pm

#309414

I'm still struggling with getting my SQL Server database into Azure. Most of it is my own misunderstanding, some of it is because I don't know the steps and feel like I've walked into the middle of a conversation.
Anyway, right now its too late, but I've had a logical server running for 4 days. I've heard that its best to turn things off in Azure when you're not using them, then turn the back on later when you're ready to do more work or use them. OK, that sounds nice. Only, I don't see any light switch anywhere. So how do you turn things off in Azure and then turn them back on again? Through the Portal?
Rod

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1003863 More actions · Answer 1

How do you turn off an instance of Azure?

Nukes? 😛

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 2

Turning the Azure SQL Databases on and off is not an option but you can throttle it down to a basic tier when not using it. The on/off option applies to virtual machines but not the SQL Databases.

😎

BLOB EATER SSChampion Points: 14609 More actions · Answer 3

For Azure VMs you can do it via the portal. see the attached screen shot.

I Don't think you can switch off a logical server.

Grant Fritchey SSC Guru Points: 398690 More actions · Answer 4

Even if you delete all the databases, the "server" will still be there. You don't pay for them, only the databases that are running on them.

"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

Jeff Moden SSC Guru Points: 1003863 More actions · Answer 5

So... Like I said... "Nukes". 😀

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)