Re: Shared Memory from older app SQL Server 2005

The network layer should not make that much of a difference. What is this program supposed to do? You did not answer any of the questions about the other applications competing for attention on the server or the amount of RAM on the server.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

<djouungk@xxxxxxxxxxx> wrote in message news:1186971804.710422.283810@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Aug 12, 5:25 pm, "William Vaughn" <billvaNoS...@xxxxxxxxx> wrote:
Okay, that means it's COM-based ADO which does not need to use MDAC to
access SQL Server--the app can be changed to use the SQL Server
2005-specific OLE DB "SNAC" provider (which has no MDAC dependency). Look
for "SQL Server Native Client" on the MS site. Simply changing the
ConnectString should help. I expect that it does have a shared memory
interface when accessing SQL Server locally, but this assumes that the
ConnectionString does NOT force ADO to look up the server name in the DNS
over the network. That is, it must have "." or "(local)" as the server
name--not the actual name.

Well, this program is a purchased program so I have no idea if it's
being forced or not. It was written in some SQL language and
compiled. It's really awful. I changed the config file to read both
"." and "(local)" and it still is connecting via named pipes. I guess
i'm out of luck on this point.

All that said, consider that SQL Server is no better at making an
application that's not written correctly work any better. It also cannot
make up for the fact that the newly installed database has not been properly
configured, does not have indexes, has not had the statistics updated, or
the server does not have enough (dedicated) RAM and CPU time or a long list
of other issues. Is the server being shared with other services like a print
spooler, Reporting Services or Analysis Services? Are there other
applications running on the server that compete with SQL Server?

Like I said, it is a horribly written program. We have a Quad core
2.66 GHz CPU with 16GB of ram. We are using Windows 2003 x64 R2
Enterprise with SQL 2005 x64 Std. (Test box atm, SQL Server is all
that's installed)

When I use SQL Server 2000 with Windows 2003 R2 (both 32 bit) the
process takes around 3.5 hours for one test and 11 hours for a
different test. When I run it with the Enterprise/2005 it takes
around 6 hours with named pipes and 8 hours with TCP/IP, while the
other test runs 20 hours on the named pipes with SQL 2005, and 29
hours with TCP/IP on SQL 2005. We'd like to be able to run this
process overnight, but I don't think I will be able to if I'm pigeon
holed into using SQL 2005.


.

Relevant Pages

  • Re: SQL 2008 vs 2005 performance issue
    ... Named Pipes is third in the order of network protocols. ... The SQL Server 2005 machine is using TCP/IP. ... The SQL Server 2008 machine is using Named Pipes. ... I installed SQL Server 2008 Enterprise Eval on my new Toshiba Centrino Duo ...
    (microsoft.public.sqlserver.setup)
  • RE: [ODBC SQL Server Driver][Shared Memory]ConnectionWrite (send()
    ... the ODBC source using named pipe, but I don't know how to enable named pipes ... If it is not working I am going to use ado to connect to sql server. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.connect)
  • Re: Connect to SQL Sererv thru Named Pipes
    ... to acced SQL Server via Named Pipes from VB 6. ... The DBMSSOCN tell the OLEDB driver to use TCP/IP instead of the default ... There are pros and cons as normal for which protocol to use however IMO ...
    (microsoft.public.vb.general.discussion)
  • Re: Connect to SQL Sererv thru Named Pipes
    ... >> Ijust wanted to know how to configure the SQL Server to use Named Pipes ... In order to use TCP/IP protocols you need to ... > There are pros and cons as normal for which protocol to use however IMO ...
    (microsoft.public.vb.general.discussion)
  • Re: SQL2K WIN2K3 CONNECTION SECURITY
    ... My own benchmarking indicates that TCP/IP is faster than named pipes. ... the benchmark stats as the starting point... ... Perfmon and SQL Server Profiler along with SQL Server Query Analyser. ... encrypted on the web server. ...
    (microsoft.public.security)
Loading