Login
Enter your username and password to login. If you do not have a username you can register one.

Username: 
Password: 
Remember Me



Forgotten Password?

Online
16 guests have been online with in the last 10 minutes.

Hot Topic
No posts have caught fire as of yet.

Third Party Application >> Others

BArmstrong
member


Reged: 02/07/05
Last on: 08/08/13
Posts: 7
PatWel ObjectBrowser is an excellent product
      #173429 11/30/11 09:06 AM

I've had the good fortune to beta test the next release of PatWel's ObjectBrowser. This came about clear out of the blue:

Ours is a smallish shop and developers wear many hats, including the CNC and DBA flavors. Not having a dedicated DBA, some aspects of db maintenance have gone without the proper attention, so recently we obtained IDERA's Defrag Manager to help out.

Here's the thing: we have noticed in the past that sometimes the SQL schemas for tables and indexes can get out of sync with the OW table specs. ...So, our manager has made this stipulation: before a defrag (reindex) window is run on a production database, first the OW spec must be compared to the SQL table schema. Then, after the maintenance window, the 'after' SQL spec must be compared to the 'before' SQL spec to assure no indexes were lost.

Now, I've been a long-time user of Everest Software's OneAssist, which is an excellent product. However, I discovered that (at least, in our system) it occasionally misreported some minor aspects of the OW table specs, namely that sometimes the ascending or descending sort was not reported correctly. Too minor to worry about? Not in my case, because I also discovered a cute little undocumented feature of OW: the SQL Primary Key created by OW ALWAYS has all columns sorted ascending. But, if the defined Primary Key in OW has a mixture of ascending and descending sorted columns, OW creates a second extra index in SQL Server with the sort mixture. (BTW if all columns are descending, there is no extra index. Go figure.) So, with my requirement of matching index counts before the defrag operation can be turned loose, I had to have an accurate analysis, allowing for the occasional extra index situation.

Figuring I had little to lose by asking, I emailed PatWel (contact@patwel.com) to see if a command-line feature was in their future plans for ObjectBrowser. It was less than half an hour when Craig Welton of PatWel replied: "Thanks for your feedback. You are the second person this week to ask for the same thing. It will be the next thing I work on. Would you be willing to help test it?"

I really felt that here was a guy that cared about the users. I immediately replied that I would be honored to do so, and it wasn't long before he sent me his first pass. Because he had added this feature, I was able to develop a little VB.NET program that calls his program and then reads that output, counting the indexes and creating a SQL script file with which to load into a SQL table. Then, with other SQL stored procedures, I gather the SQL index counts, and compare them to the OW index counts by table.

What could have been a recurring drudge of a manual job can now be totally automated.

Kudos and thanks to Craig Welton and PatWel.

Post Extras Print Post   Remind Me!     Notify Moderator

Entire thread
Subject Posted by Posted on
* PatWel ObjectBrowser is an excellent product BArmstrong 11/30/11 09:06 AM
. * Re: PatWel ObjectBrowser is an excellent product Alex_Pastuhov   12/01/11 02:31 AM
. * Re: PatWel ObjectBrowser is an excellent product BArmstrong   12/01/11 07:42 AM
. * Re: PatWel ObjectBrowser is an excellent product Alex_Pastuhov   12/02/11 12:56 AM

Extra information
0 registered and 0 anonymous users are browsing this forum.

Moderator:  ekempter, Christian Audet, jdecnc, Sef 



Forum Permissions
      You cannot start new topics
      You cannot reply to topics
      HTML is disabled
      UBBCode is enabled

Rating:
Thread views: 3234

Rate this thread

Jump to

JDELIST Support | Privacy statement JDELIST.com

*
UBB.threads™ 6.4.1

 .: IIP 5.4.5 by David Lozier ©2003 :. 
Distributed by ThreadsDev.com

The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither
endorsed nor approved by JD Edwards® & Company, Oracle or Peoplesoft.

This page best viewed with Netscape 4 or Microsoft Explorer 4 or above in 800 x 600 resolution.