Re: SQL 2008 vs 2005 performance issue

Named Pipes is third in the order of network protocols. Shared Memory is
first, TCP/IP is second. Why would it be resorting to #3?

"Patrick Jackman" <pjackman@xxxxxxxxx> wrote in message
news:eEuZV1VOJHA.4092@xxxxxxxxxxxxxxxxxxxxxxx
Ran profiler on both machines.

The SQL Server 2005 machine is using TCP/IP.
The SQL Server 2008 machine is using Named Pipes.

Would that be the source of the speed difference? If so, where do I change
it?

I used all the default settings for the 2008 machine setup.

Patrick.

"Patrick Jackman" <pjackman@xxxxxxxxx> wrote in message
news:uhyatNMOJHA.1164@xxxxxxxxxxxxxxxxxxxxxxx
I had SQL Server 2005 Standard installed on an older Toshiba Centrino laptop
with Win XP Pro SP3. It gave really great performance with an OLTP VBA
application.

I installed SQL Server 2008 Enterprise Eval on my new Toshiba Centrino Duo
with Win XP Pro SP3. With the same application it is 5 - 10 times slower
loading up a customer record from stored procedures.

Could I have set up 2008 incorrectly?

Connection string is:
ODBC;Driver={SQL Server};Server=(local);Database=ALIS;Trusted_Connection=Yes

Patrick
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Patrick Jackman
Vancouver, BC
604-874-5774




.

Relevant Pages

  • Re: Umstieg von Access auf SQL-Server
    ... > Bei Port 1433 sabber ich dann immer gleich Named Pipes. ... Nein, TCP/IP. ... How To Change SQL Server Default Network Library Without ... How To Set the SQL Server Network Library in an ADO Connection String ...
    (microsoft.public.de.vb.datenbank)
  • Re: I set: Local and remote connections/Using both TCP/IP and Named Pipes
    ... Using both TCP/IP and Named Pipes ... Go to configuration manager right click on SQL Server Express ... Local and remote connections/Using both TCP/IP and Named Pipes ...
    (microsoft.public.sqlserver.programming)
  • 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: 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: SQL 2008 vs 2005 performance issue
    ... 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)