Database Reference
In-Depth Information
system, you will need to configure your VM with as many vCPUs as you
have CPU threads on your physical platform.
Database Application Performance
When you are recording your SQL Server baselines and benchmarks, you should be
capturing application-level performance metrics that give a valid representation of
acceptable performance for the system. These are the types of metrics that will have a
direct and immediate impact on your users if there is a problem. Some items to consider
monitoring are as follows:
Transactions per second or per minute
Concurrent users and sessions
Transaction latency average and peaks
End-user experience and end-user response times for business transactions
Batch job duration
Report duration
You should also make use of the SQL Server 2012 Performance Dashboard Reports.
This is a quick and easy way to get an understanding of how your database is
performing.
SQL Server 2012 Performance Dashboard Reports can be found at this URL:
Table 10.2
outlines specific SQL Server Perfmon and SQL Profiler counters and
metrics that are useful for your baselining and benchmarking process. These will allow
you to perform a valid comparison before, during, and after virtualization of your SQL
Server systems.
