
Case Study: 1
Background
You manage the Microsoft SQL Server environment for a company that manufactures and
sells automobile parts.
The environment includes the following servers: SRV1 and SRV2. SRV1 has 16 logical cores
and hosts a SQL Server instance that supports a mission-critical application. The application
has approximately 30,000 concurrent users and relies heavily on the use of temporary tables.
The environment also includes the following databases: DB1, DB2, and Reporting. The
Reporting database is protected with Transparent Data Encryption (TDE). You plan to
migrate this database to a new server. You detach the database and copy it to the new server.
You are performing tuning on a SQL Server database instance. The application which uses
the database was written using an object relationship mapping (ORM) tool which maps tables
as objects within the application code. There are 30 stored procedures that are regularly used
by the application.
Exhibit
评论