Database Reference
In-Depth Information
Figure 1.1
CPU hot-add.
A crisis is avoided, and unlike last year customers are not leaving your site due to slow
response times to shop elsewhere. Another hour goes by. You are watching database
performance, still anxious to avoid a repeat of last year. You then realize the database is
starting to become memory constrained, and it's starting to impact performance.
Hot-Add Memory
You go into the management console and you add more memory to the virtual machine
housing the database. As you can see in
Figure 1.2
, the SQL Server database is now
able to utilize the additional memory allocated to the virtual machine it is housed in.
The arrow represents where the memory was added, and you can see how SQL Server
is able to process substantially more transactions with the additional memory available
to the database. Another problem is averted. You hold the avalanche of performance
problems at bay once again.
