Knowledgebase
SQLNitro? Is it Hot or Not...
| Posted by Landho, 04-05-2007, 11:41 PM | | I saw a booth for a product called DBLaunch at DevConnections... digging in to their website http://www.dba24hrs.net, I see they have some other product called SQLNitro which claims the following...
"Whereas the native protocol would transfer one packet of 4096 bytes into a single TCP buffer, SQLNitro packs 15 or more packets into a single buffer. It is not uncommon for a 4K packet to be reduced to a mere 300 or 400 bytes. "
Anyone here used this? Have any comments on it??
|
| Posted by Landho, 04-16-2007, 10:55 AM | | In answer to my own post... I was able to play with this and did actually see some difference (improved page load times, improved response times to queries). I am still trying to find what others see, so if you get bored and test it out - please let me know what you thought of it.
|
| Posted by jackieD, 04-30-2007, 10:10 AM | | Landho,
In order to control the bandwidth and traffic in/out of SQL Server, you can tune one switch on the server instead of buying third party products.
Log on to the server, go to the master database, and run
EXEC sp_configure
You will see some config options for SQL server. Now look for the config option called Network Packet Size. If it's not there, then advanced options are not shown. You can unhide them by running
EXEC sp_configure 'show advanced options', 1
RECONFIGURE WITH OVERRIDE
Now, the byte and packet size are tuned according to the configuration option
"network packet size (B)". You can reduce this number to achieve better throughput from SQL Server based on your needs. I think that this product does the same thing- just tunes the packet size, which you can already do in SQL server. To answer your original question- we running a pretty large data center and web infrastructure and I am not familiar with anyone using this product.
|
| Posted by mwright78664, 05-02-2007, 04:00 PM | | Actually, SQLNitro compresses the TDS protocol between SQL Server and its clients, greatly reducing the amount of data transmitted and improving response times.
|
|
 Add to Favourites
 Print this Article
|
Also Read
Reseller deal (Views: 585)
