Thinking inside the box™
When running multiple SQL instances on one server it is vital that critical instances are able to gain priority access to system resources when required. This is necessary to prevent requests being timed out and ensure Service Level Agreements are met. SmartPeak Workload Management (WLM) can be implemented on servers or clusters running Microsoft SQL Server 2000/2005 to guarantee the allocation of system resources to individual instances or services within SQL Server.
The use of SmartPeak WLM ensures that critical SQL Server applications will never be denied access to system resources due to a resource conflict caused by heavy utilization by other SQL Server instances or other applications running on the same machine.
“SmartPeak WLM enabled resources to be allocated to the critical application
when required in order to process 68% more transactions per second. Transactions
were completed, on average, in just 40% of the time taken without SmartPeak WLM.”
Read the white paper ‘Testing SmartPeak WLM in a Microsoft SQL Server environment’
The Benefits:
1. Save on license cost
The Benefits:
2. Improved performance
Scenario 1: Environment without SmartPeak WLM
Without WLM, The only way to guarantee that one SQL instance does not impact the performance of another is to use CPU Affinity.
 |
|
Scenario 2: Consolidated environment with SmartPeak WLM
WLM dynamically manages access to all four CPUs for maximum performance, utilization and service integrity.
 |
|