Posts tagged: SQL

New technote: Splitting the WM2011 datastore

From the Technotes-R-Us dept. A new article has been added to the Technote Library. This time we’re popping the lid off good things to come, namely WorkSpace Manager 2011. In this article we will be looking specifically at a feature which may positively impact the way you set up your datastore infrastructure to cater for Workspace Managere 2011, namely the ability to move log data out of the primary datastore and move it to a secondary datastore.

If you’re new to RES products, here’s the deal: Speaking in reference to the architechture, there is no such thing as a Workspace Manager server. However a SQL DBMS of your choice is used to store things in. This database up until now, stored everything – including all the logs and the detailed user activity tracking module, called Usage Tracking. The resulting dataset has the potential to become quite massive.

By offering the ability to split the logs and Usage Tracking off to a secondary datastore, things are kept much more manageable. Depending of course of what you’ve put in there it is very rare to see the configuration part of a Workspace Manager datastore exceed 100 Meg, which for a regular DBMS is small potatoes. The logging (and especially usage tracking can generate Gigs worth of logs. This may be within your operating specs that you indeed want detailed logs and statistics, so now you will have the option of storing these things somewhere else.

Finally, please note that the described functionality is not available in PowerFuse 2010. It will be available January 2011 in the new Workspace Manager release.

To read the article RG02D, click here.

New technote: PowerFuse in the Cloud!

From the Technotes-R-Us dept. With the imminent release of PowerFuse 2010, here is an interesting tidbit for you. PowerFuse 2010 supports Microsoft SQL Azure cloud databases! You would be well in your right to have a few questions you would want answered, such as:

  • What the heck is Azure?
  • Why would I want to consider that?
  • What does it do for PowerFuse?
  • What would all this cost me then? Are there any savings?
  • Right, so how do I setup the darn thing then?

All these questions and more, are adressed in a brand-spankin’ new Technote RG021, which is available for your reading enjoyment in the library.

Click here to read the full article

Cache This! (Technote)

Animated, Gears, boxHere’s a solution to an annoying little problem which has been bugging more  than a few people out there recently. This was originally posted in the Guru’s Forum but it seemed to make sense to make an article out of it. Here’s the skinny: You’ve just installed PowerFuse 2008 for the first time and everything seems hunky-dory in the console. Then you try to log into a session as a user and get this little number (click it to enlarge):

cache-error

Click here to read the full article.