Re: Slow performance with windows authentication

From: Ian Cox (Ian1971_at_newsgroup.nospam)
Date: 01/17/05 

Date: Mon, 17 Jan 2005 18:13:08 -0000

Thanks Sophie. I will try and run some tests, as soon as I can. I'll get
back to you

Cheers
Ian
"Sophie Guo [MSFT]" <v-sguo@online.microsoft.com> wrote in message
news:J0zo6Di%23EHA.644@cpmsftngxa10.phx.gbl...
> Hello Ian,
>
> After connecting to SQL server, both authentications should have the same
> effect. Since you can connect to SQL server when logging on as Windows
> user, the issue may be a performance issue instead of a connectivity
> issues.
>
> Please understand that identifying the causes of a performance issue is
> typically very time consuming, and you may spend several days evaluating
> the collected information. The complexity of the performance analysis is
> not specific to a particular database product or operating system. All
> applications are subject to performance constraints because of resource,
> design, or usage factors.
>
> To narrow down the issue, I suggest you perform steps below to narrow down
> the issue:
>
> 1. Make sure both users have the same permissions on the database in SQL
> server, then run a simple query on the sample database Northwind to see if
> you can reproduce the problem.
>
> If you are unable to reproduce the problem, it indicates that the problem
> is special to the query you run before; if you can reproduce the problem,
> you need perform further steps to narrow down the issue.
>
> 2. Collect the information in the following article when logging on as
> Windows and SQL server user. Then analyze the output files.
>
> HOW TO: Troubleshoot Application Performance Issues
> <http://support.microsoft.com/?id=298475>
>
>
> If the issue still exists after you have used the troubleshooting steps
> above, to efficiently troubleshoot a performance issue, we recommend that
> you contact Microsoft Product Support Services and open a support incident
> and work with a dedicated Support Professional.
>
> To obtain the phone numbers for specific technology request please take a
> look at the web site listed below.
>
> http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS
>
> If you are outside the US please see http://support.microsoft.com for
> regional support phone numbers.
>
> I hope above information is helpful.
>
>
> Sophie Guo
> Microsoft Online Partner Support
>
> Get Secure! - www.microsoft.com/security
>
> =====================================================
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>

Relevant Pages

  • Re: Cannot connect a remote sql server
    ... I too have written quite a bit about connecting. ... Hitchhiker's Guide to Visual Studio and SQL Server ... such as the server's firewall, SQL Server's remote connection setting, ... Microsoft MSDN Online Support Lead ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Cannot connect a remote sql server
    ... connecting a SQL Server 2005 instance from a certain client box,correct? ... Generally for SQL Server connecting issue, ... Microsoft MSDN Online Support Lead ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Virtual SQL Server times out.
    ... what is your general hardware layout and what SQL server build are you ... Microsoft SQL Server MVP ... I support the Professional Association for SQL Server ... I understood that when connecting your virtual SQL ...
    (microsoft.public.sqlserver.clustering)
  • SQL 2008 Upgrade Bug
    ... I had a similar situation and after calling MS support it turns out there is a bug in the SISS that will prevent the upgrade of an expired evaluation edition. ... I am not sure if you have unintalled the SQL Server and then reinstalled it. ... In this case I recommend that you contact Microsoft Customer Support Services ...
    (microsoft.public.sqlserver.setup)
  • Until Lydia replaces the strangers commonly, James wont cater any wrong ventilators.
    ... They are swelling once again the ladder now, ... You won't haul me connecting as to your alone ... support and invoke it in connection with its trial. ... It expected, you modifyed, yet Sue never newly sumed sort of the ...
    (sci.crypt)