Context
SQL Server database rationalization study
Challenge
To assess the feasibility of consolidating several SQL Server instances on a single machine that already contains dozens of databases, an audit mission of MSSQL servers and instances was conducted. The objective is to rationalize SQL license costs and simplify maintenance.
Technologies used
DBMS: MSSQL Server 2008R2 Standard and Enterprise Edition • ETL: SAP BODS + T-SQL scripts and stored procedures • Reporting: NA
Methodology and implementation
In this study, our methodology for consolidating applications and databases is applied.
First, setting up probes and traces. Then studying hardware and software configurations. Finally, analyzing traces and functionalities allows us to conclude the study.
After several dozens of days of traces, the data is consolidated in a database to be analyzed.
Here are the results of these analyses:
The first thing that catches the eye is the very high disk impact of the xxxTELx1 server (hosting telephony data). To get a clearer picture, a detailed analysis is then conducted on this server to learn more.
Results
The study showed the feasibility of consolidation without major risk. It detected that one application had a major impact on SAN storage.
Visualizations
Instance activity simulation by cumulating probe measurements