Looking for feedback: logical process managerI am working on a future version of ASE and am interested in hearing about your experiences with the logical process manager (LPM). LPM consists of engine groups and execution classes, as well as the ability to set spid priority in an ad-hoc manner via sp_setpsexe. This functionality is sometimes referred to as application queues.
If you have used this feature I’d like to know:
- What was the use case (in other words, why did you use it)?
- What elements did you use? How did you use it?
- Did it meet your needs? Did you run into problems?
- Any shortcomings or requirements that weren’t met?
- What was your overall impression?
If you evaluated the functionality but chose not to use it, please let me know what you were trying to accomplish and why you decided against using LPM. Finally, if you have use cases or requirements around managing multiple applications in a single ASE server, or managing the priority / resources of specific spids, please pass those along. Unaddressed use cases are extremely useful to hear about. Please provide your feedback directly to me at david.wein@sybase.com, and include “logical process manager feedback” in the mail subject (I get a lot of mail and this will help make sure I don’t miss your mail!). Please be as detailed and specific as you can about your use cases and results. Thanks a bunch,
Dave
Did you know there is a /proc inside of ASE?Okay, there isn’t really a /proc, but there is something pretty close and getting more like it all the time… (More...)
Minnesota ISUG Event on June 18thThere will be a meeting of the Minnesota Sybase User Group (MNSUG) on June 18th. The meeting is being held in downtown St. Paul at the Landmark Center which is a really nice venue. We are doing a full day session with data management covered in the morning, a lunch (free food!), and tools in the afternoon. Getting both the DBA group and the developer group together can be a little tough, and we hope this is a good format to bring the two groups together, at least for lunch. (More...)
Learn about Cluster Edition at TechwaveAugust may seem far away, but for those of us developing content for Techwave, it is right around the corner. This year’s Techwave conference has a lot of cluster related content, so if you’ve been curious about ASE Cluster Edition I recommend making the trip to Vegas. Naturally the content is subject to change - but as of now I see five breakout sessions covering Cluster Edition as well as full-week, in-depth education seminar. It appears the education seminar will also be offered as a pre-conference course. If you sign up for a pre-conference course you can take a different full length class during the week. One of the breakouts I’ll be doing will show you how to setup a cluster on a laptop using VMware….should be fun!
ASE Cluster Edition Featured on Sun's HomepageI just found out that ASE Cluster Edition is being featured on the sun.com homepage. Pretty sweet!
Here is a link to the featured story.
Cheers,
Dave
glibc Compatibility Problem SolvedI am happy to say that we have fixed a nuisance compatibility issue. As many of you know ASE has trouble getting along with glibc 2.4 or newer. This has led to the oft referenced LD_POINTER_GUARD environment variable solution to get ASE to boot on SLES 10 and RHEL 5. It has also caused ASE to simply not work on many of the bleeding edge distros. I am happy to say that this is now solved. The work was done under CR 479363 and is available in 15.0.2 ESD #4 and 15.0.1 Cluster Edition ESD #2. The LD_POINTER_GUARD workaround is no longer necessary and Chris Brown has posted that he has finally been able to upgrade to Ubuntu Hardy. Read more
Thinking About ClustersIt’s been quite a while since you’ve heard from me - almost a year. It has been some year...most notably due the four releases of ASE Cluster Edition that we’ve done. (Beta, Beta Refresh, GA, and ESD #1 for those keeping score). Before I joined engineering, I didn’t have a good appreciation for the amount of work that goes into doing a release - I’ve got a pretty good idea now. :)
Alas, this post is supposed to be about clusters, not sleep deprivation, so here we go…
As you’ve no doubt heard we released a shared disk cluster version of ASE known as Cluster Edition. There is a lot of be discussed under the umbrella of Cluster Edition and database clusters in general. I’d rather not blog about what is already out there, so I’ll provide a few links as a jumping off point:
- The official Sybase cluster site:
- At the above link you will find links to some webcasts, a podcast, along with some other overview stuff.
The documentation is under the ASE 15.0.1 doc set at: A video of me running a demo at Techwave 2007: (for the keen viewers, I mention a bug in the beta jConnect driver to be fixed before GA. Yes, the issue was fixed, although it turned out to be in ASE and not the driver…oops). I am moderating a cluster newsgroup: sybase.public.ase.cluster at forums.sybase.com, which is also web accessible at (More...)
Red Hat PartnershipRed Hat and Sybase announced a partnership yesterday to deliver the first enterprise data management appliance for RHEL 5. (More...)
Chris - you are right about virtualizationChris Brown recently posted about virtualization. I am a huge proponent of virtualization. I've been using VMWare Workstation for a couple of years and really like it. (More...)
P&T Podcast with Stefan KarlssonAs I mentioned in my first post, Stefan Karlsson has been hosting a great P&T podcast series. He’s had some of the Sybase "greats" on, such as Peter Thawley, Rob Verschoor, Jeff Tallman, and Steve Bologna. Given the caliber of his guests, I was honored when I got the call from Sweden and Stefan invited me to join him for a discussion of ASE kernel architecture. (More...)
The future of raw i/o on LinuxI’ve spent most of my posts so far talking about disk i/o with a heavy Linux slant. I might as well address one topic that comes up again and again: what is the future of raw i/o on Linux? (More...)
Device option follow up: Direct I/OIn my last post I wrote about DSYNC i/o and promised to write about direct i/o. So, without further delay, here we go. (More...)
Some Musings on Device OptionsIn ASE 12.0 we introduced official file system device support via the device-level dsync flag. Since then, many a DBA have pondered "to dsync, or not to dsync?" This tends to be part of the larger question of file vs. raw. Like just about anything related to performance, there is not really a yes or no answer that fits all cases. In this post I'll try to further your understanding of this and other device options. (More...)
The Real Deal with ASE and Linux Disk I/O, Part TwoIn my last post I discussed some of the background on ASE and Linux asynchronous disk i/o. We are finally to the part of the story where true KAIO support in ASE comes in. (More...)
The Real Deal with ASE and Linux Disk I/O, Part OneOkay – so perhaps you administer ASE on Linux and were lured in by the title. Maybe you are Linux curious and want to learn more. Maybe you couldn't care less about Linux but you find ASE disk I/O highly exciting. Perhaps you are really into Frisbee and found this post because it uses the work 'disk' a lot. Regardless, you've come to the right post (well, except for the Frisbee people – try again in your search engine). (More...)
The ASE Blogs are HereAs this is my first blog post, it's only appropriate that I tell you a little bit about who I am, what I do, and so forth. My name is David Wein and I've been with Sybase (and the Adaptive Server Enterprise product) in some technical capacity for around a decade. (More...)
|
