Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)

  • RE: SQL Server 2008 delay in connection

    Thanks for your reply!

    i_amhers (9/11/2014)Shared Memory Protocol is going to be default/best practice IF and ONLY IF the application and database is on the same server

    Yes, this part is obvious....

  • RE: SQL Server 2008 delay in connection

    Thanks for your feedback!

    Yes, I've used a lot of sniffing tools. Weird part about it was that no tool was showing any outgoing packets, except for netstat, which was showing...

  • RE: SQL Server 2008 delay in connection

    I managed to solve the problem... kinda...

    The TCP port setting was blank in SQL Server Configuration Manager -> SQL Server Network Configuration -> Protocols for SQLEXPRESS -> TCP/IP -> IP...

  • RE: SQL Server 2008 delay in connection

    I think I'm on to something. I tried connecting to my local sql server using (local) while running netstat. Consecutive refreshes (1 second intervals) of netstat show the following active...

  • RE: SQL Server 2008 delay in connection

    So, I tried connecting using "." as server name and the results are the same as for "(local)" - slow and painful.

  • RE: SQL Server 2008 delay in connection

    Thanks for the suggestion!

    I will try connecting using "." tomorrow and report back.

    What would you recommend to trace traffic? I've used wireshark/ethereal and iptraf on numerous occasions in the past,...

Viewing 6 posts - 1 through 6 (of 6 total)