MS Sql 2000 vs. Pervasive SQL

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Chuy

    MS Sql 2000 vs. Pervasive SQL

    I am using Maximizer Enterprise 8.0 as my companies CRM solution. Currently
    we are using the included Pervasive SQL that shipps with the product. Is
    there someone out that who could tell me if there are any performance
    benefits to switching the Pervasive Engine with a Microsoft SQL engine.

    Regards

    Jesus


  • pheonix1t

    #2
    Re: MS Sql 2000 vs. Pervasive SQL

    Chuy wrote:
    [color=blue]
    > I am using Maximizer Enterprise 8.0 as my companies CRM solution. Currently
    > we are using the included Pervasive SQL that shipps with the product. Is
    > there someone out that who could tell me if there are any performance
    > benefits to switching the Pervasive Engine with a Microsoft SQL engine.
    >
    > Regards
    >
    > Jesus
    >
    >[/color]
    Tell us more about your environment. How big is the database?
    If I had to guess, i'd say it's not that big if you're running a CRM
    package on it.
    Pervasive is a really nice SQL database, especially for the price.
    It's very reliable, I've seen them running for many years with no
    problems. For most small/medium sized businesses, Pervasive is just
    fine. Performance is close to if not better in some respects to MS-SQL.

    So, what do you need? What features do you require?

    It all depends.....

    If it works, don't fix it.....rule #1





    Comment

    • Chuy

      #3
      Re: MS Sql 2000 vs. Pervasive SQL

      I currenlty have about 50 users accessing the Pervasive Database. The
      database is really just a glorified address book with notes, so it's really
      not doing a lot of crunching. I do notice though that at peak usage times
      certain larger fields (ie notes filed) takes a while to populate. Also we
      have a couple of applications that are currently using MSDE and we would
      like to consolidate those with one SQL dbase.


      "pheonix1t" <pheonix1tAThou stonDOTrrDOTcom @com.com> wrote in message
      news:am5rd.2523 2$fC4.11701@new ssvr11.news.pro digy.com...[color=blue]
      > Chuy wrote:
      >[color=green]
      >> I am using Maximizer Enterprise 8.0 as my companies CRM solution.
      >> Currently we are using the included Pervasive SQL that shipps with the
      >> product. Is there someone out that who could tell me if there are any
      >> performance benefits to switching the Pervasive Engine with a Microsoft
      >> SQL engine.
      >>
      >> Regards
      >>
      >> Jesus[/color]
      > Tell us more about your environment. How big is the database?
      > If I had to guess, i'd say it's not that big if you're running a CRM
      > package on it.
      > Pervasive is a really nice SQL database, especially for the price.
      > It's very reliable, I've seen them running for many years with no
      > problems. For most small/medium sized businesses, Pervasive is just fine.
      > Performance is close to if not better in some respects to MS-SQL.
      >
      > So, what do you need? What features do you require?
      >
      > It all depends.....
      >
      > If it works, don't fix it.....rule #1
      >
      >
      >
      >
      >[/color]


      Comment

      • pheonix1t

        #4
        Re: MS Sql 2000 vs. Pervasive SQL

        Chuy wrote:[color=blue]
        > I currenlty have about 50 users accessing the Pervasive Database. The
        > database is really just a glorified address book with notes, so it's really
        > not doing a lot of crunching. I do notice though that at peak usage times
        > certain larger fields (ie notes filed) takes a while to populate. Also we
        > have a couple of applications that are currently using MSDE and we would
        > like to consolidate those with one SQL dbase.
        >
        >[/color]
        sounds like you may just need to do some performance tuning.
        which version of pervasive are u running?
        Have you ever tuned this database for your environment?
        Do you know how to do performance tuning on your version of Pervasive?

        As far as the MSDE, I'm sure there are methods for intergrating that to
        pervasive. Have you tried reading their docs or looking at the btrieve
        newsgroup? comp.databases. btrieve
        it's a pretty flexible database... as all good quality databases should be!

        You can also try calling their sales people, they may be able to find
        that out for you. It may be as simple as running the newest version.
        I know for a dual-CPU license on Netware 6.0, the license was around
        $3500 (last summer). It's price is very reasonable compared to MS-SQL.
        It's got clustering, replication and all that enterprise class stuff -
        if you need it.


        Comment

        • Chuy

          #5
          Re: MS Sql 2000 vs. Pervasive SQL

          I have limited experiences with Databases, so no I am not familiar with
          performance tuning. I have been in the Pervasive SQL management utility
          which allows for tweaking of all kinds of settings that I am not positive
          what they do. I dare not mess with it if I don't understand it. Do you
          have any recommendations for tweaking it, or are there any utils to sniff
          out the SQL Dbase access.

          Jesus

          "pheonix1t" <pheonix1tAThou stonDOTrrDOTcom @com.com> wrote in message
          news:BKprd.3944 5$Al3.17911@new ssvr30.news.pro digy.com...[color=blue]
          > Chuy wrote:[color=green]
          >> I currenlty have about 50 users accessing the Pervasive Database. The
          >> database is really just a glorified address book with notes, so it's
          >> really not doing a lot of crunching. I do notice though that at peak
          >> usage times certain larger fields (ie notes filed) takes a while to
          >> populate. Also we have a couple of applications that are currently using
          >> MSDE and we would like to consolidate those with one SQL dbase.
          >>
          >>[/color]
          > sounds like you may just need to do some performance tuning.
          > which version of pervasive are u running?
          > Have you ever tuned this database for your environment?
          > Do you know how to do performance tuning on your version of Pervasive?
          >
          > As far as the MSDE, I'm sure there are methods for intergrating that to
          > pervasive. Have you tried reading their docs or looking at the btrieve
          > newsgroup? comp.databases. btrieve
          > it's a pretty flexible database... as all good quality databases should
          > be!
          >
          > You can also try calling their sales people, they may be able to find that
          > out for you. It may be as simple as running the newest version.
          > I know for a dual-CPU license on Netware 6.0, the license was around $3500
          > (last summer). It's price is very reasonable compared to MS-SQL.
          > It's got clustering, replication and all that enterprise class stuff - if
          > you need it.
          >
          >[/color]


          Comment

          • pheonix1t

            #6
            Re: MS Sql 2000 vs. Pervasive SQL

            Chuy wrote:[color=blue]
            > I have limited experiences with Databases, so no I am not familiar with
            > performance tuning. I have been in the Pervasive SQL management utility
            > which allows for tweaking of all kinds of settings that I am not positive
            > what they do. I dare not mess with it if I don't understand it. Do you
            > have any recommendations for tweaking it, or are there any utils to sniff
            > out the SQL Dbase access.[/color]

            At this point, I'd suggest you don't mess with it.
            You need a good programmer or database consultant (with Pervasive
            experience) to work on your database. It should be a quick visit, most
            of the time performance tuning for a small environment doesn't take long
            (50-users is relatively small for a RDMBS).
            It could be something as simple as rebuilding your indexes - but that's
            just a guess. You'd need to gather information like what version of
            Pervasive you're running on as well as what patch level (if any), what
            OS the database is running on, available disk space, amount of RAM on
            that database server, stuff like this.

            Where are you located? I do IT consulting - we do have remote access
            DBA services too.




            Oskar

            my cell is 832-212-2675



            [color=blue]
            >
            > Jesus
            >
            > "pheonix1t" <pheonix1tAThou stonDOTrrDOTcom @com.com> wrote in message
            > news:BKprd.3944 5$Al3.17911@new ssvr30.news.pro digy.com...
            >[color=green]
            >>Chuy wrote:
            >>[color=darkred]
            >>>I currenlty have about 50 users accessing the Pervasive Database. The
            >>>database is really just a glorified address book with notes, so it's
            >>>really not doing a lot of crunching. I do notice though that at peak
            >>>usage times certain larger fields (ie notes filed) takes a while to
            >>>populate. Also we have a couple of applications that are currently using
            >>>MSDE and we would like to consolidate those with one SQL dbase.
            >>>
            >>>[/color]
            >>
            >>sounds like you may just need to do some performance tuning.
            >>which version of pervasive are u running?
            >>Have you ever tuned this database for your environment?
            >>Do you know how to do performance tuning on your version of Pervasive?
            >>
            >>As far as the MSDE, I'm sure there are methods for intergrating that to
            >>pervasive. Have you tried reading their docs or looking at the btrieve
            >>newsgroup? comp.databases. btrieve
            >>it's a pretty flexible database... as all good quality databases should
            >>be!
            >>
            >>You can also try calling their sales people, they may be able to find that
            >>out for you. It may be as simple as running the newest version.
            >>I know for a dual-CPU license on Netware 6.0, the license was around $3500
            >>(last summer). It's price is very reasonable compared to MS-SQL.
            >>It's got clustering, replication and all that enterprise class stuff - if
            >>you need it.
            >>
            >>[/color]
            >
            >
            >[/color]

            Comment

            Working...