MS Sql 2000 vs. Pervasive SQL

[Chuy]

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]

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

[Chuy]

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]

[pheonix1t]

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.

[Chuy]

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]

[pheonix1t]

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.

http://www.atechbusinesssolutions.com

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]