You are here: Re: Audit Logon / Audit Logoff problem with SQL 2K « MsSQL Server « IT news, forums, messages
Re: Audit Logon / Audit Logoff problem with SQL 2K

Posted by Jack Vamvas on 10/01/36 11:37

What connection type is used , is it ODBC or DSN Less?
Also, which version of SQL server are you using?




--
Jack Vamvas
__________________________________________________________________
Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
New article by Jack Vamvas - SQL and Markov Chains -
www.ciquery.com/articles/art_04.asp
"Oscar Santiesteban Jr." <o_santiesteban@bellsouth.net> wrote in message
news:xmgzf.6634$Ea3.1451@bignews2.bellsouth.net...
> I need help...here is the problem.
>
> Last weekend, the servers in our datacenter where moved around. After
this
> move, and maybe coincidental, 1 server is performing very poor. After
> running a trace with SQL Profiler, I saw the problem which was later
> confirmed with another tool for SQL server performance monitoring. It
seems
> that all connections to the SQL server (between 200 - 400) are doing a
login
> / logout for each command that they process. For example, the user's
> connection will login, perform a SELECT, and then logout. This is not a
> .NET application. The client software was not changed, it is still the
> same. The vendor has said that it is not supposed to do that, it is
> supposed to use 1 connection that log's on in the morning and logs off at
> the end of the day or whenever the user exits. 1 user may have several
> connections to the database.
>
> At times, the server is processing over 250 login / logouts (avgeraged for
> 30 second period). Has anyone seen this problem? I have the server in
> AUDIT FAILUREs only. The server has become very unresponsive, things that
> took 3 seconds now take over 15 seconds.
>
> Any ideas???
>
>

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация