Search sqlserver-dba.com
Follow sqlserver-dba.com
*Use the Comments section for questions
SQLServer-DBA.com Links
Recent Posts
- sys.dm_server_services - How to check if SQL Server service is running or not?
- Msg 3023, Level 16, State 2 Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed.
- Can we restore a database to an older version in SQL Server?
- How do I save all SQL Agent Jobs
- How to view SQL Server mount point space without access to server
- DBCC SHRINKFILE: page could not be moved because it is a work table page.
- SQL Agent Last Modified explanation
- Sql certificate chain was issued by an authority that is not trusted
- sqlserver-dba.com switching from feedburner to follow.it
- Taking transaction log backup and full back at the same time
Database Virtual Server Candidacy Criteria
13 July,2011 by Tom Collins
Migrating database servers, often requires decisions on whether to virtualize. There are plenty of tests, criteria and documentation on metrics for testing on virtualized database servers.
I’m working on a large data centre migration. One of the objectives is to list out database servers (DB2 and SQL Server) which satisfy the criteria.
Some quick formulas are useful. They do not substitute considerations for the performance stack, but act as a rule of thumb.
These formulas are for Windows and Linux. A colleague uses these formula to create candidacy lists for large server farms.
Processor
Information required
Number of processors
Processor speed
Average Utilization % of Processor
Formula
No.Processors x Processor Speed x CPU Utilisation % = CPU score
<= 4096 = Good Candidate
> 4096 = Possible Candidate
Memory
Information required
Physical Memory
Memory utilise
Formula
Total Memory x Memory Utilisation % = Memory Score
<=4096 = Good Candidate
> 4096 and <=6144 = Likely Candidate
> 6144 = Possible Candidate
Disk IO
Information required
Daily Average Total IO rate (4K pages per second)
Formula
Daily Average Total IO rate(4k pages per second) = Disk IO score
<=1000 IO per second = Good candidate
>1000 IO per second and <= 3000 per second = Likely candidate
> 3000 IO per second = Possible Candidate
Related posts
Virtualization – and database servers
SQL Server – virtualization - is it a viable alternative
Author: Tom Collins (http://www.sqlserver-dba.com)
Share:
Verify your Comment
Previewing your Comment
This is only a preview. Your comment has not yet been posted.
As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.
Having trouble reading this image? View an alternate.
Posted by: |