Long time reader - first time poster - rookie for sure.
VC 2.0.1 build 32042 on Windows Server 2003 SP2, SQL 2000 and Mulitple ESX 3.0.1 hosts
Long story shortened - inherited my VM environment (just rebuilt from scratch when I got it), no previous experience. Have attended FastTrack. Lots of little issues, overallocated guest resources, etc., but pretty stable.
In looking into missing performance data (so I can allocate the resources better), I delved deeply into our SQL DB (no DB Admins at our little company, very little SQL experience on my part, just enough to be dangerous), followed steps for making sure NTP is setup correctly, etc. Further steps led us to issues with not knowing the DB password. I changed the user account password, which of course crashed the Virtual Center Server service. Changed the DB password from the command line and rebuilt the ODBC connector. Resolved the service issue. 1 old issue and 1 new issue:
Old issue: In looking at the performance data (still nothing but real-time available) I noticed that the entries in the DB are listed in UTC even though all my ESX hosts are set to UTC=FALSE and the proper time zone. The same for my VC server. Is this normal? I have seen that there are scripts that can convert the UTC, but it seems that SQL just stores that data in that format on purpose.
New issue: I am missing all new events since these changes on the VC. They show when I connect the VI client to the actual host, but not in the VC. The entries are in the DB. What should I be looking at to resolve this issue?
Have read many entries about resetting the DB (vpcd.exe -b) but am very concerned when it says I'll have to re-register the hosts. Will I experience downtime on my guests if I do this?
Any help would be appreciated, not looking for someone to solve the issue, just point me in a direction. Thanks much in advance.
One thing I can answer quickly - a host's configuration (or lack thereof) in VirtualCenter will have no effect on the guest. You can disconnect, reconnect, remove, re-add all day. It is architected that way on purpose.
If you want to see a great deal of information other than real-time, you have to change the Statistics Collection level.
Through VirtualCenter, click on Administration->VirtualCenter Managment Server Administration
Then, click on "Statistics", and change the "Collection Level" to "4" (I believe the default is "Level 2").
Once you make this change, from now on you'll be able to view information further-back than only "Real-Time".
This is the first place to start.