Hi Girish,
You can perfectly use a SQL Server Database as backbone of your Mendix application, this works fine performance wise. Keep in mind that you also need to take care of the Mendix deployment on-premises as well (see documentation here), as you cannot connect an app in the Mendix cloud with your on-premise MS SQL.
Good luck!
Johan