We're trying to pull performance info directly from the VCenter db (SQL 2005), and the numbers we're getting from the db don't match what the VIC reports. Or we're using the wrong fields.
Below is a chart, with the first four fields from the VIC, and the rest pulled with a SQL query. We're trying to get Memory Reservation, Limit, Overheard, and CPU Reservation.
Anybody know what's going on?
Thanks!
-David
Cluster | Name | Reservation - MB | Limit - MB | MEM_SIZE_MB | MEMORY_RESERVATION | CPU_RESERVATION | MEMORY_OVERHEAD | STATIC_MEM_OVERHEAD |
2 | vm 1 | 364 | Unlimited | 2048 | NULL | NULL | 120496128 | 95637504 |
1 | vm 2 | 512 | 896 | 1024 | NULL | NULL | 112226304 | 81944576 |
2 | vm 3 | 256 | 512 | 1024 | NULL | NULL | 114196480 | 81944576 |
2 | vm 4 | 280 | 512 | 1024 | NULL | NULL | 108486656 | 81944576 |
1 | vm 5 | 0 | Unlimited | 1024 | NULL | NULL | 112697344 | 81944576 |
1 | vm 6 | 312 | 512 | 1024 | NULL | NULL | 107966464 | 81944576 |
2 | vm 7 | 0 | Unlimited | 4096 | NULL | NULL | 163323904 | 123023360 |