Results 1 to 10 of 10
  1. #1
    Join Date
    Dec 2002
    Posts
    1,245

    Unanswered: Dell OpenManage and SQL Server

    Anyone ever use Dell OpenManage with SQL Server extensions? We're in the process of rolling out an OpenManage solution. The documentation which accompanies OpenManage is, um, sparse.

    The management here would like to see a common monitoring model for all our servers (web, app, database and support/misc). OpenManage seems to provide some promise, but I have no experience with it and I am trying to learn it quickly (along with a "crash" course in Oracle!).

    Thanks in advance,

    hmscott
    Have you hugged your backup today?

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Crash course in Horacle? All you need to know is how to declare cursors That's what Horacle is running on...and on 1.5mil worth of HW
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Dec 2002
    Posts
    1,245
    I'm beginning to see the picture. And the more of it I see....


    Regards,

    hmscott

    Quote Originally Posted by rdjabarov
    Crash course in Horacle? All you need to know is how to declare cursors That's what Horacle is running on...and on 1.5mil worth of HW
    Have you hugged your backup today?

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I know Oracle bashing is a whole lot of fun....

    BUT, there's a reason it has such big market share....

    The big thing is that you need to supply refrence cursors for the result set...

    so what?

    It only delivers that data to the calling application when it asks for it...not before....unlike sql server....

    There is no physical movement of data, until it's required....

    There are A LOT of powerful AND Cool things about Oracle....

    HELL, the ability to do hierarchal queries alone....

    But the thing about DELL doing admin...across platforms?

    Thanks...but no thanks....

    What's wrong with Artisan?

    How much does this DELL product cost?

    And you know what...you'd be MUCH better servered by building (or stealing) your own code for each platform so you can learn how the sh-t works...

    OK, now a big MOO...

    PS When do you start your DB2 OS/390 exposure?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Dec 2002
    Posts
    1,245
    Brett,

    Sorry, I must have missed this one some time ago...

    Actually, I already had my exposure to DB2 / AS400. Not in an administrative way, mind you, but I still got to know quite a bit about the ins and outs (I even got to look at some RPG code, ugh!). One thing I really did not like about the AS400 (at least as it was explained to me by our admins) was the need to correctly identify the specific logical file (kinda like a view) to use for a specific query. As it was explained to me, IBM couldn't or didn't use a query cost estimator to correctly choose which index to search on. Instead, the developer had to use the appropriate logical file based on the statements in the WHERE clause.

    As for your take on Oracle; you are absolutely right; it is a great product. It's still a struggle to learn, though. I did get my management to pay for a 1-week training course; I'm supposed to start in early October. I finally found a short, 18-page executive summary of the chief advantages Oracle has over SQL server. It was an eye-opener, even though it was heavily biased in Oracle's favor (it was written by Oracle marketing people). Some of the things that Oracle can do are definitely on my list of things I'd like to see in SQL.

    As for the Dell OpenManage stuff; I was only curious to see if others had any experience with trying to integrate it with SQL. The big advantage that I see in it is that it uses SNMP to continuously monitor all the nodes on the network. I can configure the same thing with SQL Agent, or purchase a 3rd party product, or design a custom solution; but my management is keen to leverage the OpenManage product as much as possible.

    Regards,

    hmscott

    Quote Originally Posted by Brett Kaiser
    I know Oracle bashing is a whole lot of fun....

    BUT, there's a reason it has such big market share....

    The big thing is that you need to supply refrence cursors for the result set...

    so what?

    It only delivers that data to the calling application when it asks for it...not before....unlike sql server....

    There is no physical movement of data, until it's required....

    There are A LOT of powerful AND Cool things about Oracle....

    HELL, the ability to do hierarchal queries alone....

    But the thing about DELL doing admin...across platforms?

    Thanks...but no thanks....

    What's wrong with Artisan?

    How much does this DELL product cost?

    And you know what...you'd be MUCH better servered by building (or stealing) your own code for each platform so you can learn how the sh-t works...

    OK, now a big MOO...

    PS When do you start your DB2 OS/390 exposure?
    Have you hugged your backup today?

  6. #6
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    What version of Oracle?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  7. #7
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    OK-OK, let it be Oracle...Am I in the wrong forum again?

    As for monitoring, execs like standardization, they don't want to understand that what's effective for one platform may be awkward or inefficient for another. At USAA they chose BMC Patrol with Tivoli. After 3 years of implementation and false alerts in the middle of the night they're still with it, and the management loves it (that's because they don't have to go on-call!!!)
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  8. #8
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Whatever....sounds like a personal problem....

    Hey the more platforms the better....

    http://www1.us.dell.com/content/topi...555&l=en&s=biz

    But I'm not to sure about silver bullets....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  9. #9
    Join Date
    Dec 2002
    Posts
    1,245
    8.1.6 mostly. Some 8.1.7.

    We're still in the process of renewing our annual support contract; I've heard (but have not seen) that 8i is going off support in December of this year.

    ugh.

    Regards,

    hmscott

    Quote Originally Posted by Brett Kaiser
    What version of Oracle?
    Have you hugged your backup today?

  10. #10
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    8i bytes....

    No ANSI Join syntax....No CASE

    Lots of cool stuff that sql doesn't have though...

    Nested tables, CONNECT BY for hierarchal queries...no udf's though...

    great date manipulation...

    9i's the way to go...haven't touched, but looked through the manuals....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •