Azure Pricing, SQL Server seems pretty high?

Question

Azure Pricing, SQL Server seems pretty high?

keven11

Valued Member

Points: 63
More actions
June 28, 2022 at 2:17 pm

#4056105

Hi, I'm really new to this and I think I've got this wrong, wondering if you can help me.
I've got an SQL database I'm wanting to put in Azure. It's 32gb and would be accessed by maybe thirty staff avg 20 times a day during normal working hours by a locally installed program. What kind of price should I expect on a monthly basis? If we went for this set up we could sign in for up to 3 years. Looking at the calculator it's giving me figures of over £12k a year which is going to be a hard sell given we've already got it up and running on local servers.
August 2, 2022 at 2:52 pm

This was removed by the editor as SPAM

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

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

Grant Fritchey SSC Guru Points: 398913 More actions · Answer 1

Are you looking at servers, VMs, or are you looking at Azure SQL Database? How big are the VMs you're looking at, memory, cpu, disk, etc? For such a small system as you're describing, I'd skip over the VMs and go for the SQL Database. Guarantee, it'll be cheaper.

"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: 1004434 More actions · Answer 2

keven11 wrote:

I've got an SQL database I'm wanting to put in Azure.

WHY? What problem are you trying to solve and why do you think Azure is going to help?

--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)

Jeff Moden SSC Guru Points: 1004434 More actions · Answer 3

Heh... I get that same response (none) to that question a whole lot. 😀

--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)