Click here to monitor SSC
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
Right there with Babe
Right there with Babe (787 reputation)Right there with Babe (787 reputation)Right there with Babe (787 reputation)Right there with Babe (787 reputation)Right there with Babe (787 reputation)Right there with Babe (787 reputation)Right there with Babe (787 reputation)Right there with Babe (787 reputation)

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

Aunt Kathi
Linchpin People Teammate
SQL Server MVP
Author of Expert T-SQL Window Functions
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)

Group: Administrators
Points: 35976 Visits: 18726
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
SSC-Addicted
SSC-Addicted (476 reputation)SSC-Addicted (476 reputation)SSC-Addicted (476 reputation)SSC-Addicted (476 reputation)SSC-Addicted (476 reputation)SSC-Addicted (476 reputation)SSC-Addicted (476 reputation)SSC-Addicted (476 reputation)

Group: General Forum Members
Points: 476 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
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 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
Right there with Babe
Right there with Babe (787 reputation)Right there with Babe (787 reputation)Right there with Babe (787 reputation)Right there with Babe (787 reputation)Right there with Babe (787 reputation)Right there with Babe (787 reputation)Right there with Babe (787 reputation)Right there with Babe (787 reputation)

Group: General Forum Members
Points: 787 Visits: 341
Have you tried contacting the company?

Aunt Kathi
Linchpin People Teammate
SQL Server MVP
Author of Expert T-SQL Window Functions
Richard Hallman-383493
Richard Hallman-383493
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 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
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 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
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 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
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 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
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 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