SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Turbo for SQL Server


Turbo for SQL Server

Author
Message
Kathi Kellenberger
Kathi Kellenberger
SSCertifiable
SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)

Group: General Forum Members
Points: 5472 Visits: 358
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/kKellenberger/turboforsqlserver.asp

Aunt KathiLinchpin People TeammateSQL Server MVPAuthor of Expert T-SQL Window Functions
Steve Jones
Steve Jones
SSC Guru
SSC Guru (329K reputation)SSC Guru (329K reputation)SSC Guru (329K reputation)SSC Guru (329K reputation)SSC Guru (329K reputation)SSC Guru (329K reputation)SSC Guru (329K reputation)SSC Guru (329K reputation)

Group: Administrators
Points: 329038 Visits: 20109
As an FYI, Turbo is powering the search at SQLServerCentral.com.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
deden
deden
Mr or Mrs. 500
Mr or Mrs. 500 (536 reputation)Mr or Mrs. 500 (536 reputation)Mr or Mrs. 500 (536 reputation)Mr or Mrs. 500 (536 reputation)Mr or Mrs. 500 (536 reputation)Mr or Mrs. 500 (536 reputation)Mr or Mrs. 500 (536 reputation)Mr or Mrs. 500 (536 reputation)

Group: General Forum Members
Points: 536 Visits: 1

I don't want to say that sql Turbo is a bad product, we are very happy with the speed, but found some issues with it:

- Memory management issues, as with everything using sp_OA... it runs in the "executable code" memory zone and not the "Memory pool". That forced us to buy more memory because Executable code memory zone has a fixed size (that could be set through a startup parameter) and increasing it reduced the buffer available for the "standard" queries with a negative impact on performances...

- Security issues (I like to remove sp_OA... from all my production servers)

- Troubles mixing standard sql indexes and Sql Turbo indexes...

- This forced us to created a Sql Turbo index on a bit column, resulting in "strange" behaviour.

Best Regards

Douglas

p.s. sorry for the bad English it's not my mother tongue





Richard Hallman-383493
Richard Hallman-383493
SSC-Enthusiastic
SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)

Group: General Forum Members
Points: 123 Visits: 35
Has anyone any idea what's happened to SQL Turbo? It appears that Quest (who were distributing it) have wiped all mention of it from their website.

Frustrating, as we're using SQL Turbo on a server, and I was looking at the options for running SQL Turbo on a dedicated server, as we've found that the rebuilding of the indexes is sucking performance from the database server. It appears you need a separate version (SQL Turbo Server) for this, but it's disappeared from sight.

Any other suggestions?
Kathi Kellenberger
Kathi Kellenberger
SSCertifiable
SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)

Group: General Forum Members
Points: 5472 Visits: 358
Have you tried contacting the company?

Aunt KathiLinchpin People TeammateSQL Server MVPAuthor of Expert T-SQL Window Functions
Richard Hallman-383493
Richard Hallman-383493
SSC-Enthusiastic
SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)

Group: General Forum Members
Points: 123 Visits: 35
Yes, since my post I've been doing some more digfging, and have been in contact with Quest, who bought Imceda.

It transpires that they have "sunsetted" the product, and no longer sell it.

However they have passed my query on to techie so maybe I'll get some assistance.
zac everett
zac everett
SSC-Enthusiastic
SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)

Group: General Forum Members
Points: 136 Visits: 16
As Quest have pulled the plug on SQL Turbo are you likely to reconsider a new index service provider?

I really liked Turbo and was waiting for a 64 bit release, which will now never come.
Richard Hallman-383493
Richard Hallman-383493
SSC-Enthusiastic
SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)

Group: General Forum Members
Points: 123 Visits: 35
Well for the moment it's doing its job, so I'll continue using it. Maybe the "enhanced" features on SQL2008 or whatever will make it redundant? Who can tell.
zac everett
zac everett
SSC-Enthusiastic
SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)SSC-Enthusiastic (136 reputation)

Group: General Forum Members
Points: 136 Visits: 16
I hope sql2008 iFTS has some good features too.

When using Turbo it can return total number of matches found extremely quickly even searching millions of rows. I struggle to see how SQL using fts will be able to do this without having to return back all the rows in the query and then counting them etc. I hope Microsoft will prove me wrong but i'm not holding up much hope.

I did find on the web that Microsoft have purchased a Scandinavian Enterprise class search tool so may be they will bring this in line in a few years.
Richard Hallman-383493
Richard Hallman-383493
SSC-Enthusiastic
SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)

Group: General Forum Members
Points: 123 Visits: 35
Yes, the "page at a time" features of SQLTurbo are great, aren't they.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search