Strategies of better SQL Management and Cost Saving RRS feed

  • Question

  • Our company has nearly 50 SQL server engines and 250 database instances running, the business applications data in the databases vary greatly in their subjects. Due to lack of expertise and good management strategies, we do not have good knowledge about our SQL server environments, from licensing, data security, disaster recovery plan, basic database management(backup, tuning, account management), applications usage and BI reporting,  to data directory and contents. We are looking for grand strategies aimed at better management and cost saving with the following goals in mind:

    1. Our SQL servers have multiple versions from 2005 version to 2017 versions with different editions,  what are the good strategies to manage such diverse server environments?

    2. We are exploring possibilities to have centralized architectures to management our SQL server databases, would  SQL clustering or SQL farm, or SQL cloud reduce, at least partially, our database management burden?  what are the criteria to decide whether some applications can be based on clustered SQL servers vs dedicated SQL server?  any recommendations?

    3. We are looking for better licensing management strategies given our diverse and complex SQL server environments to reduce overhead on duplicate licensing costs, upgrade costs, and maintenance costs.

    4. What are the considerations we should give to the better SQL server management from applications and reporting perspective? any recommendation to our complex business applications and data usage?

    5. We are looking for efficient and possible 'smart" approaches to categorize, index or build directories of our business data in our SQL server databases, so that we have better understanding our business data for better management purposes. 

    We know each subject above covers wide range of topics and details, we are looking for help to start with a roadmap to achieve our goals. Any suggestions and recommendations are greatly appreciated.


    Tuesday, June 30, 2020 2:55 PM

All replies

  • I suggest you contact a MS representative or reseller for help with your questions for your environment.

    For detailed information about the license issue, please call 1-800-426-9400, Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time) to speak directly to a Microsoft licensing specialist. For international customers, please use the to find contact information in your locations.

    Tuesday, June 30, 2020 3:33 PM