CODEWITHSUNDEEP
sql-servermongodbmigratedatabase
amir mobarakian
amir mobarakian

Reputation: 19

Migrate SQL Server database with 100 million rows and 40g size to mongodb

We have a SQL Server database with 100 million rows and 40g size. Our server has 24 cpu and 150g ram. SQL Server uses 100% of cpu. The server is in critical situation.

What is the best solution for migrating to mongodb?

Are there any tools for doing this work?

Upvotes: 0

Views: 383

Answers (1)

Bogdan Sahlean
Bogdan Sahlean

Reputation: 1

Note: This is more an extended comment than an answer.

[ 1 ] 40 GB database isn't a big / huge database. It's more a medium size database (or small to medium database).

[ 2 ] At first sight I see no reason why I would migrate to mongodb a such DB with such hardware (24 core ?! CPU, 150 GB RAM).

[ 3 ] From my point of view, the most likely causes of low / slow performance of db server could be:

  • SQL Server missconfiguration (for example: see max memory) and or Win Server configuration,

  • cpu and/or memory pressure generated by external processes (for example: are you running IIS web server on the same machine),

  • Missing indexes ?

  • Poor programming T-SQL skills (for example: cursors).

[ 4 ] I would hire a consulting company to analyze this this SQL instance. See:

Brent Ozar Limited https://www.brentozar.com/sql-critical-care/ and/or

SQLSkills https://www.sqlskills.com/services/ and/or

Steve Stedman http://stevestedman.com/consulting/ and/or

google for "sql server consulting"

@ontopic:

Source: http://www.commitstrip.com/en/2014/06/03/the-problem-is-not-the-tool-itself/enter image description here

Upvotes: 4

Related Questions