Re: Slow performance with windows authentication

From: CGoodspeed (CGoodspeed.1jaklz_at_mail.mcse.ms)
Date: 01/23/05 

Date: Sat, 22 Jan 2005 20:25:15 -0600

Sophie Guo [MSFT] wrote:
> *Hello Ian,
>
> thanks for your update.
>
> If you have any questions or concerns, don't hesitate to let me know.
> We
> are always here to be of assistance!
>
>
> 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. *
Ian and Sophie:

I have experienced the same problem with queries in "SQL Analyzer only"
as Ian as in using Windows authentication.

Here is the sequence of events.
1. Nomal installation of SQL Server 2K - Security mode set to Windows
only.

Results: performance in as expected for all queries run.

2. Install or create an application that requires SQL Server
authentication.
a) Open properties on server and change authentication to both Windows
and SQL Server

Results: Initial performance of queries run in either mode is
identical

3) Began using the application the required the SQL Authentication
(Crystal Enterprize accessing a stored procedure or NET ADO adapter
calls to queries or stored procedures.

Results: At some point in time 2-3 days or less after heavy use...you
will notice that performance in SQL Analyzer degrades signigficantly
when using windows authentication. This is TRUE of ALL commands
including admin cals like sp_who or attach and detach databases.
Enterprize manager does not experience these problems.

REMEDY:

(4)Change the properties of the authentication of the server back to
windows only.

RESULTS: The same queries limping minutes beforeunder windows
authentication no perform appropriately again.

(5)Change the properties of the server back to both properties again.

Results: The queries will perform in SQL Analyzer equally for another
few days.

THIS IS A BUG SOPHIE!

Chuck 

--
CGoodspeed
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message1350372.html

Relevant Pages