XPrime Database Accelerator

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Shawn Denogeon SSChasing Mays Points: 634 More actions · Answer 1

Angela,

We'll know next week when XPrime allows us to demo onsite. From a

pre-sales standpoint, I'm very impressed by the professionalism of the

XPrime technical and sales team. They have taken time to understand our

issues, our database schema and stored procedures. I'm looking forward

to proving their system and they seem to have high expectations.

If it was just more memory and more CPUs, then, I don't think they'd

have a product. If the intelligent co-processing of scattering and

gathering the data and the query works as advertised, then, it's a great

solution to a difficult problem. Our schema and data is definitely not

perfect and solving it through rearchitecting will certainly cost more

in time, money and lost weekends and vacations...

More later once we've started the demo.

Shawn

rone Newbie Points: 7 More actions · Answer 2

I have been doing some looking at XPrime recently. I was just wondering how the demo went?

Thanks,

Ron

Shawn Denogeon SSChasing Mays Points: 634 More actions · Answer 3

Take advantage of their demo.

Some possible issues could be: (1) every table involved in a

query / sp must be delegated to xprime, otherwise, sql server's query

plan may decide to submit a large intermediate result set back to itself

for further filtering or sorting, causing a longer running query; (2) if

you reboot your sql server, the tables have to be delegated back to the

xprime units, which could take hours; and (3) even though we allocated a

consultant to help manage and test XPrime during the demo period, in

retrospect, he may have been the wrong choice in skill level and

application expertise.

What may have challenged XPrime is that unlike every other SQL

Server implementation I worked on, this one uses as many as 250+ columns

per table, UNIONS, and SQLXML extensively.

Also, we likely did not spec our demo system to the correct

size. XPrime has replied with solutions to all our issues and are

continually improving their firmware. Unfortunately, at the moment,

even though XPrime offered us more demo units, a longer demo period and

a new strategy to implement their system, we currently cannot allocate

more time due to other pressing issues.

In conclusion, in my personal opinion, as time permits, we may

still further pursue an XPrime solution for certain facets of our

application.

N Cook SSC Eights! Points: 981 More actions · Answer 4

Hello,

Has anyone else used XPrime (or any other database accelerator)?

Nate