Forum Discussion

Daniele's avatar
Daniele
Frequent Visitor
9 years ago

General dissatisfaction and performance issues

Hi All,     After having our tech guys setting up a PostgreSQL database for me to build our datawarehouse on it, i have done all the automation that dumps the data from our main MongoDB to the dataw...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

It sounds like you are spinning up an Azure SQL Server via Infrastructure as a Service (IaaS). What I am suggesting is that you spin up an Azure SQL DB instance instead. This is more of SQL Server database as a Service so more SaaS based. Much less expensive than running a server in the cloud.

 

I didn't realize that you were running your PostgreSQL box in Amazon. There could definitely be latency issues there going from on-premises to the the Amazon cloud or from Azure to Amazon. The nice thing about Power BI and using Azure SQL DB is that you can potentially have all of it in essentially one data center or at least all within Azure with fast connections between Azure data centers.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Listening to Greg_Deckler is indeed a good plan!

 

I just looked -- and have a client w/ an S1 instance in Azure ($30/mo), with 23 million rows of data using only 5gb of 250gb available... and I suck them all into power bi w/ no probs.