Thursday, December 08, 2005

To MSDE or Not MSDE...That Is The Question

Within the last several weeks, I've taken action to address a problem with Virtual Center 1.3. When I upgraded from VC 1.2 to 1.3, I aggravated an issue regarding the performance graphs. For a while now, I've been experiencing gaps in graphed data. With the upgrade, it became a real issue (see picture).

Working with our support vendor, they determined that running MSDE as our SQL backend must be the problem. However, I remain unconvinced.

First, there is much debate about whether this configuration is supported or not (see discussion threads here and here) I maintain that MSDE is SQL lite and so I am running SQL for Virtual Center. I know about the limitations but I'm nowhere near meeting those. I don't think you should be required to spend money on a full-blown SQL license just to run Virtual Center. Products from Cisco's Security Agent Management Center to NetIQ management products use MSDE as their database.

Second, there was no exploration of the database content itself to see if it was "corrupt" as the support engineer claimed based on the graphs. More investigation would need to be made before identifying MSDE as the cause.

Lastly, we made another change which addressed the issue. We changed the number of samples taken and time interval. This seemed to do the trick. Changing the time interval from 5 minutes to 10 minutes and samples from 288 to 144 fixed the graphs. I don't believe I should have to do this and I already have a gripe about the lack of real-time averages to gauge real performance but it's resolved for now.

Is it MSDE? I won't know without a more thorough investigation if it happens again.


At Mon Dec 19, 10:37:00 PM 2005, Anonymous Alessandro Perilli said...

Go for SQL Server 2005 Express Edition. It simply rocks and has the new GUI for simplified management (SQL Server 2005 Management Studio Express).


Alessandro Perilli

At Tue Feb 10, 03:30:00 AM 2009, Blogger uiyui said...

Youth is not wow gold a time of life;world of warcraft gold it is a state of mind; cheap wow gold it is not a Maple Story Accounts matter of rosy cheeks, red lips and supple knees;mesos it is a matter of the will, a quality of the imagination,wow gold kaufen a vigor of the emotions; it is the freshness wow geld of the deep springs of life.maple story mesos Youth means a tempera-mental predominance of courage over timidity, of the appetite for adventure over the love of ease. This often exists in a man of 60 more than a boy of gold farmen Nobody grows old merely by a number of years.maple story money We grow old by deserting our mesos Years may wrinkle the skin, but to give up enthusiasm wrinkles the soul. Worry, fear, self-distrust bows the heart and turns the spring back to dust. Whether 60 or 16, there is in every human being’wow powerleveling s heart the lure of wonder, the unfailing childlike appetite of what’s maple story money next and the joy of the game of living.powerlevel In the center of your heart and my heart there is a wireless station: so long as it receives messages maplestory powerleveling of beauty, hope, cheer,world of warcraft power leveling courage and power from men and from the Infinite, so long are you young. When the aerials are down, and your spirit is covered with snows of cynicism and the ice of pessimism, then you are grown old, even at 20, but as long as your aerials are up, to catch waves of optimism, there is hope you may die young at 80!


Post a Comment

<< Home