SQL 2014 Migration

Question

Hi,
I am reposting as the previous thread was closed.
Please clarify my list below and recommend changes

Realtime Refreshes with Parallel Jobs, Equivelant to MPP (PDW, Multiple Physical Servers with VM)

• Infrastructure 2 VM (Storage & Presentation)
VM Storage (Cube Process and copy after completion)
Hardware

• Windows 19 x64 with Hyper-V Enabled
  `` - 64 Bit Processors (A) 120 Win19, (B) 64 Win16 (Multiple Numa Nodes 4)
  CPU Speed (Fast), latest spec?
  Cores, How many?
  CPU Architecture, latest spec?
• SSD Storage (A) 7TB, (B) 5TB
• RAM (A) 3TB, (B) 2TB
  RAM Speed (Fast), latest spec?
  - Increase Netwrok Sockets/Speek in DataCenter between Storage VM & ERP (AS400), particular specs?
  Software
• VS2019/21 Community with SSDT
• SQL21 or SQL19 (DB, SSIS, MDS) for collumn store indexing, change all from rows (20% improvement)
• WINSCP, PKZip, 7Zip, Excel only for static Reports
• PowerPivot Rolled out as a Group "specific users"
• Not Increasing PBI licenses (decrease in usage)
• LiteSpeed (Object Recovery)

VM Presentation

• Hardware Requirements the same as Storage, but 3TB Hardrive & 64 Processors?
• SSAS,SSAS Tabular, PBI, PowerPivot

Innovation/Evolve

• PowerPivot, thoughts on innvovation please ? > Equivelant to Qlikview (Bridge gap between Excel and PowerBI)

Please Advise!

Answer 1

Hi @Ismail Cassiem ,

Which version and edition of SQL Server do you want to migrate to? Do you want to migrate to SQL Server 2019?
Did you encounter any issues during the migration?
You can use DMA (Data Migration Assistant) to migrate SQL Server. DMA will recommend performance and reliability improvements for your target environment and allows you to move your schema, data, and uncontained objects from your source server to your target server.

Best Regards,
Amelia

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
What can I do if my transaction log is full?--- Hot issues November
How to convert Profiler trace into a SQL Server table -- Hot issues November

Answer 2

Hi,

Thank You for assisting, i read that SQL2020 known as SQL16.0 is being developed
I want the latest version, when i go live in Feb/Mar
any idea when and the benifts ?
would the above architecture work?

regards

Answer 3

i read that SQL2020 known as SQL16.0 is being developed

There is no such/next version announced, yet; so no one of use can say, when the next version will be released.

Answer 4

Thank You very much!