Post reply

SQL mirroring poor performance.

  • May 18, 2011 at 9:51 pm

    #1326876

    We don't have to setup a DSN on the workstations so it's not ODBC. There is no Java involved in the system so it's not JDBC. The application is developed in CS.NET and it communicates with the database through the Microsoft SQL Native Client. Does that mean it's SNAC?

    Unfortunately I can't provide a connection string. The connection details are specified in a custom XML file that the client reads. I guess it builds the connection string dynamically. That is why I have contacted the developer (to find out exactly what it is that the client app is doing internally).

    Cheers,

    David

  • May 18, 2011 at 11:14 pm

    #1326888

    That's correct. SNAC = SQL Server Native Client

    My blog: SQL Soldier[/url]
    SQL Server Best Practices:     SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply