Challenge: Modern data warehouse solution vs traditional data warehouse

Hi rajkm42 

> How can I move to azure synapse analytics workspace to save costs and performance.

Not neccererily moving will lead to save costs and gain performance. There are a lot of advantages in migrating to cloud solutions and not less disadvantages according to the scenario and your specific case.

You should test it well to be sure. It is highly recommend to get some estimated about manage costs for serverless SQL pool and check the Azure Synapse Analytics pricing calculator here.

Not any service fit any scenario. It is up to you to check the limitations and cost according to your specific case.

> I am very confused, How a serverless pool is best for me?

Who told you that it is better for your specific case?!? Why do you assume that it is better for scenario?!? There is a good reason for other services and products to exists 

You question based on assumptions and as such makes small sense.

Without examine your specific case and get a lot more information, I cannot advise you what fits for you, but in first glance i would recommend you to check the option of using azure synapse dedicated sql pool as a database warehouse solution.