Monday, September 8, 2008

A Patch for Performance

DBArtisan 8.5.5 is out. This patch is great step for quality. We corrected over 125 customer issues ( and many more internally reported ). Plus we put a ton of effort into improving the performance of our new object management system. In fact I am going to list off the objects that we have worked on improving the performance of.

On Oracle: Table, Columns, Indexes, Materialized Views, Materialized View Logs, Privileges, Unique Key, Primary Key, Rollback Segment, Cluster, Packages and Package Bodies, Types and Type Bodies, Views, Procedures, Functions, Triggers

On ASE: Table, Column, Primary Keys, Unique Keys, Check Constraints, Indexes, Procedures, Functions, Views, Foreign Keys, Triggers

On SQL Server: Tables, Indexes, Foreign Keys, Procedures, Functions, Triggers, Views, Primary Keys, Unique Key

On DB2: Tables, Views, Primary Keys, Unique Keys

We are always listening to customers and always want to create the best tool for the job. This patch is just a small response to that but certainly contains enough performance improvements to justify a look. Enjoy! More great improvements soon to come.

Thursday, September 4, 2008

Sliding back in time

Isn't August supposed to be the down month? Everyone is on vacation? Well not for this guy. Apparently a few people decided it was change jobs month. I have never been one to shy away from change so I am excited about new beginning but filling the voids has been fun but exhausting. For one I am currently guiding the DBArtisan and Rapid SQL teams personally. These are great teams and they are anxious to put out great product. As such the team has rewarded the world and me with DBArtisan 8.5.5 which should be on the website tomorrow, and I will blog more about then.

Anyhow with all these distractions I haven't had a chance to blog about Performance Center 2.5. The first thing you will notice is it has that new car smell. Er it looks new all over. Some might say the move to 2.5 is like going from VW to a BMW. Marketing has done a great job on detailing the benefits of Performance Center so I won't repeat that. However when you start the Performance Center UI find the Zoom slider and "Current" button on the toolbar.



These two controls do amazing things that were not possible in previous versions. The Zoom actually lets you move around in the last few hours of activity. The graphs will all reflect this change. Clicking current lets you go back to any point in time and the information on the screens adjust to that time. So if someone asks you what was happening last night at 2am when my batch failed, then you can quickly check it out. You can then zoom around to see what lead up to problem as well. Possibilities are endless and if database performance awareness is important to you then this is a good time to test drive this tool.