|
|
You're in the
sql server (alternate)
group:MS Sql 2000 vs. Pervasive SQL
sql server (alternate):
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
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. [quoted text, click to view] "pheonix1t" <pheonix1tAThoustonDOTrrDOTcom@com.com> wrote in message news:am5rd.25232$fC4.11701@newssvr11.news.prodigy.com... > Chuy wrote: > >> 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 > 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 > > > > >
[quoted text, click to view]
Chuy wrote: Tell us more about your environment. How big is the database?> 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 > > 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
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 [quoted text, click to view] "pheonix1t" <pheonix1tAThoustonDOTrrDOTcom@com.com> wrote in message news:BKprd.39445$Al3.17911@newssvr30.news.prodigy.com... > Chuy wrote: >> 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. >> >> > 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. > >
[quoted text, click to view]
Chuy wrote: sounds like you may just need to do some performance tuning.> 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. > > 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.
[quoted text, click to view]
Chuy wrote: > 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. 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. http://www.atechbusinesssolutions.com Oskar my cell is 832-212-2675 [quoted text, click to view] >
> Jesus > > "pheonix1t" <pheonix1tAThoustonDOTrrDOTcom@com.com> wrote in message > news:BKprd.39445$Al3.17911@newssvr30.news.prodigy.com... > >>Chuy wrote: >> >>>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. >>> >>> >> >>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. >> >> > >
Don't see what you're looking for? Try a search.
|
January 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
| home · blog · groups | Questions? Comments? Contact the dn |