BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  How to prevent Audit login and Audit logout          BorlandTalk.com Forum Index -> Delphi Databases (SQL Servers) View previous topic :: View next topic   Author Message bill Guest Posted: Fri Apr 29, 2005 8:32 am    Post subject: How to prevent Audit login and Audit logout Hi, I am using Delphi5.0 + MSSQL2000. I have an multi-user AP. Sometimes the AP is very slowly. I used the Sql Profiler to trace: I found there are som event class-- Audit Login and Audit Logout. The events took a long duration: 60000 --- 300000. (mm Seconds) So the reason of slowly is the Audit login and Audit logout event. I just know the event is Implicit Connection of SQL Server But I don't know how to avoid the event. Please help me. Thanks bill PS: I use Delphi5.0 (TADOConnection + TDgADOQuery) -----> + MSSQL2000 Back to top Lee-Z Guest Posted: Fri Apr 29, 2005 12:25 pm    Post subject: Re: How to prevent Audit login and Audit logout Are you also DBA for this MSSQL server? In that case check out the Security settings from the server (in EM: SQL Server properties -> Security tab -> Audit Level)... If auditing is enabled on the Sql Server I don't think you can work around it (that would kinda defeat the purpose.....) regards, Lee-Z "bill" <bill (AT) dingey (DOT) com.tw> wrote Quote: Hi, I am using Delphi5.0 + MSSQL2000. I have an multi-user AP. Sometimes the AP is very slowly. I used the Sql Profiler to trace: I found there are som event class-- Audit Login and Audit Logout. The events took a long duration: 60000 --- 300000. (mm Seconds) So the reason of slowly is the Audit login and Audit logout event. I just know the event is Implicit Connection of SQL Server But I don't know how to avoid the event. Please help me. Thanks bill PS: I use Delphi5.0 (TADOConnection + TDgADOQuery) -----> + MSSQL2000 Back to top bill Guest Posted: Fri Apr 29, 2005 12:48 pm    Post subject: Re: How to prevent Audit login and Audit logout Yes, I am a DBA. You mean if auditing is disabled I can work around it . Is it true? Thank you. bill "Lee-Z" <Lee-Z.spam (AT) zonnet (DOT) nl> ¦b¶l¥ó news:427227d1 (AT) newsgroups (DOT) borland.com ¤¤¼¶¼g... Quote: Are you also DBA for this MSSQL server? In that case check out the Security settings from the server (in EM: SQL Server properties -> Security tab - Audit Level)... If auditing is enabled on the Sql Server I don't think you can work around it (that would kinda defeat the purpose.....) regards, Lee-Z "bill" <bill (AT) dingey (DOT) com.tw> wrote in message news:4271f0e4$1 (AT) newsgroups (DOT) borland.com... Hi, I am using Delphi5.0 + MSSQL2000. I have an multi-user AP. Sometimes the AP is very slowly. I used the Sql Profiler to trace: I found there are som event class-- Audit Login and Audit Logout. The events took a long duration: 60000 --- 300000. (mm Seconds) So the reason of slowly is the Audit login and Audit logout event. I just know the event is Implicit Connection of SQL Server But I don't know how to avoid the event. Please help me. Thanks bill PS: I use Delphi5.0 (TADOConnection + TDgADOQuery) -----> + MSSQL2000 Back to top Lee-Z Guest Posted: Fri Apr 29, 2005 1:31 pm    Post subject: Re: How to prevent Audit login and Audit logout Yes, I assume that if you choose Audit level "None" SQL won't audit the logins (and you should only see the login activity itself in SQL profiler...not the auditing stuff) good luck, Lee-Z "bill" <bill (AT) dingey (DOT) com.tw> wrote Quote: Yes, I am a DBA. You mean if auditing is disabled I can work around it . Is it true? Thank you. bill "Lee-Z" <Lee-Z.spam (AT) zonnet (DOT) nl> ¦b¶l¥ó news:427227d1 (AT) newsgroups (DOT) borland.com ¤¤¼¶¼g... Are you also DBA for this MSSQL server? In that case check out the Security settings from the server (in EM: SQL Server properties -> Security tab - Audit Level)... If auditing is enabled on the Sql Server I don't think you can work around it (that would kinda defeat the purpose.....) regards, Lee-Z "bill" <bill (AT) dingey (DOT) com.tw> wrote in message news:4271f0e4$1 (AT) newsgroups (DOT) borland.com... Hi, I am using Delphi5.0 + MSSQL2000. I have an multi-user AP. Sometimes the AP is very slowly. I used the Sql Profiler to trace: I found there are som event class-- Audit Login and Audit Logout. The events took a long duration: 60000 --- 300000. (mm Seconds) So the reason of slowly is the Audit login and Audit logout event. I just know the event is Implicit Connection of SQL Server But I don't know how to avoid the event. Please help me. Thanks bill PS: I use Delphi5.0 (TADOConnection + TDgADOQuery) -----> + MSSQL2000 Back to top bill Guest Posted: Sat Apr 30, 2005 3:50 am    Post subject: Re: How to prevent Audit login and Audit logout But I already have chosen "None", It still has the auditing event. Thank you. bill "Lee-Z" <Lee-Z.spam (AT) zonnet (DOT) nl> ¦b¶l¥ó news:42723725$1 (AT) newsgroups (DOT) borland.com ¤¤¼¶¼g... Quote: Yes, I assume that if you choose Audit level "None" SQL won't audit the logins (and you should only see the login activity itself in SQL profiler...not the auditing stuff) good luck, Lee-Z "bill" <bill (AT) dingey (DOT) com.tw> wrote in message news:42722ce7$1 (AT) newsgroups (DOT) borland.com... Yes, I am a DBA. You mean if auditing is disabled I can work around it . Is it true? Thank you. bill "Lee-Z" <Lee-Z.spam (AT) zonnet (DOT) nl> ¦b¶l¥ó news:427227d1 (AT) newsgroups (DOT) borland.com ¤¤¼¶¼g... Are you also DBA for this MSSQL server? In that case check out the Security settings from the server (in EM: SQL Server properties -> Security tab - Audit Level)... If auditing is enabled on the Sql Server I don't think you can work around it (that would kinda defeat the purpose.....) regards, Lee-Z "bill" <bill (AT) dingey (DOT) com.tw> wrote in message news:4271f0e4$1 (AT) newsgroups (DOT) borland.com... Hi, I am using Delphi5.0 + MSSQL2000. I have an multi-user AP. Sometimes the AP is very slowly. I used the Sql Profiler to trace: I found there are som event class-- Audit Login and Audit Logout. The events took a long duration: 60000 --- 300000. (mm Seconds) So the reason of slowly is the Audit login and Audit logout event. I just know the event is Implicit Connection of SQL Server But I don't know how to avoid the event. Please help me. Thanks bill PS: I use Delphi5.0 (TADOConnection + TDgADOQuery) -----> + MSSQL2000 Back to top Lee-Z Guest Posted: Fri May 13, 2005 11:52 am    Post subject: Re: How to prevent Audit login and Audit logout Okay....for once I decided to try this myself before sending a reply ) and, you're right, it doesn't have to do with the audit level....next time I'll try first... so back to your problem of slow audit logon and logoff's, there must be reason for this... Does your database have the auto_close option on? (if yes, turn it off, it's performance-hell ) ) Which Servicepack from SQL are you using? Lee-Z "bill" <bill (AT) dingey (DOT) com.tw> wrote Quote: But I already have chosen "None", It still has the auditing event. Thank you. bill "Lee-Z" <Lee-Z.spam (AT) zonnet (DOT) nl> ¦b¶l¥ó news:42723725$1 (AT) newsgroups (DOT) borland.com ¤¤¼¶¼g... Yes, I assume that if you choose Audit level "None" SQL won't audit the logins (and you should only see the login activity itself in SQL profiler...not the auditing stuff) good luck, Lee-Z "bill" <bill (AT) dingey (DOT) com.tw> wrote in message news:42722ce7$1 (AT) newsgroups (DOT) borland.com... Yes, I am a DBA. You mean if auditing is disabled I can work around it . Is it true? Thank you. bill "Lee-Z" <Lee-Z.spam (AT) zonnet (DOT) nl> ¦b¶l¥ó news:427227d1 (AT) newsgroups (DOT) borland.com ¤¤¼¶¼g... Are you also DBA for this MSSQL server? In that case check out the Security settings from the server (in EM: SQL Server properties -> Security tab - Audit Level)... If auditing is enabled on the Sql Server I don't think you can work around it (that would kinda defeat the purpose.....) regards, Lee-Z "bill" <bill (AT) dingey (DOT) com.tw> wrote in message news:4271f0e4$1 (AT) newsgroups (DOT) borland.com... Hi, I am using Delphi5.0 + MSSQL2000. I have an multi-user AP. Sometimes the AP is very slowly. I used the Sql Profiler to trace: I found there are som event class-- Audit Login and Audit Logout. The events took a long duration: 60000 --- 300000. (mm Seconds) So the reason of slowly is the Audit login and Audit logout event. I just know the event is Implicit Connection of SQL Server But I don't know how to avoid the event. Please help me. Thanks bill PS: I use Delphi5.0 (TADOConnection + TDgADOQuery) -----> + MSSQL2000 Back to top Guest Guest Posted: Tue May 17, 2005 6:06 pm    Post subject: Re: How to prevent Audit login and Audit logout Hi, I am having exactly the same problem: SQL stop to serve on one database, and the profiler sen a lot of audit logon and audit logout messages. Have you find how to cope with this? Christophe Tricaud Paris, France Quote: Hi, I am using Delphi5.0 + MSSQL2000. I have an multi-user AP. Sometimes the AP is very slowly. I used the Sql Profiler to trace: I found there are som event class-- Audit Login and Audit Logout. The events took a long duration: 60000 --- 300000. (mm Seconds) So the reason of slowly is the Audit login and Audit logout event. I just know the event is Implicit Connection of SQL Server But I don't know how to avoid the event. Please help me. Thanks bill PS: I use Delphi5.0 (TADOConnection + TDgADOQuery) -----> + MSSQL2000 User submitted from AEWNET (http://www.aewnet.com/) Back to top bill Guest Posted: Sun May 22, 2005 4:45 am    Post subject: Re: How to prevent Audit login and Audit logout I am using SP3 for SQL. Thanks again. bill "Lee-Z" <Lee-Z.spam (AT) zonnet (DOT) nl> ¼¶¼g©ó¶l¥ó·s»D :42849512 (AT) newsgroups (DOT) borland.com... Quote: Okay....for once I decided to try this myself before sending a reply ) and, you're right, it doesn't have to do with the audit level....next time I'll try first... so back to your problem of slow audit logon and logoff's, there must be reason for this... Does your database have the auto_close option on? (if yes, turn it off, it's performance-hell ) ) Which Servicepack from SQL are you using? Lee-Z "bill" <bill (AT) dingey (DOT) com.tw> wrote in message news:4273004e$1 (AT) newsgroups (DOT) borland.com... But I already have chosen "None", It still has the auditing event. Thank you. bill "Lee-Z" <Lee-Z.spam (AT) zonnet (DOT) nl> ¦b¶l¥ó news:42723725$1 (AT) newsgroups (DOT) borland.com ¤¤¼¶¼g... Yes, I assume that if you choose Audit level "None" SQL won't audit the logins (and you should only see the login activity itself in SQL profiler...not the auditing stuff) good luck, Lee-Z "bill" <bill (AT) dingey (DOT) com.tw> wrote in message news:42722ce7$1 (AT) newsgroups (DOT) borland.com... Yes, I am a DBA. You mean if auditing is disabled I can work around it . Is it true? Thank you. bill "Lee-Z" <Lee-Z.spam (AT) zonnet (DOT) nl> ¦b¶l¥ó news:427227d1 (AT) newsgroups (DOT) borland.com ¤¤¼¶¼g... Are you also DBA for this MSSQL server? In that case check out the Security settings from the server (in EM: SQL Server properties -> Security tab - Audit Level)... If auditing is enabled on the Sql Server I don't think you can work around it (that would kinda defeat the purpose.....) regards, Lee-Z "bill" <bill (AT) dingey (DOT) com.tw> wrote in message news:4271f0e4$1 (AT) newsgroups (DOT) borland.com... Hi, I am using Delphi5.0 + MSSQL2000. I have an multi-user AP. Sometimes the AP is very slowly. I used the Sql Profiler to trace: I found there are som event class-- Audit Login and Audit Logout. The events took a long duration: 60000 --- 300000. (mm Seconds) So the reason of slowly is the Audit login and Audit logout event. I just know the event is Implicit Connection of SQL Server But I don't know how to avoid the event. Please help me. Thanks bill PS: I use Delphi5.0 (TADOConnection + TDgADOQuery) -----> + MSSQL2000 Back to top Lee-Z Guest Posted: Wed May 25, 2005 3:24 pm    Post subject: Re: How to prevent Audit login and Audit logout Never looked in to it, but according to MSDN: Audit Login, which collects all new connection events since the trace was started. Audit Logout, which collects all new disconnect events since the trace was started. These counters seem to be some sort of recapitulation of other events.... To be honest, I don't think the slow performance has to do with these events at all....What did the other events you used with profiler show? For instance: how long do stored procedures take? Do you use a lot of views? Usually, slow performance in SQL-Server is solvable by tuning your indexes and looking at the way your views and stored procedures are constructed... Lee-Z "bill" <bill (AT) dingey (DOT) com.tw> wrote Quote: I am using SP3 for SQL. Thanks again. bill "Lee-Z" <Lee-Z.spam (AT) zonnet (DOT) nl> ¼¶¼g©ó¶l¥ó·s»D :42849512 (AT) newsgroups (DOT) borland.com... Okay....for once I decided to try this myself before sending a reply ) and, you're right, it doesn't have to do with the audit level....next time I'll try first... so back to your problem of slow audit logon and logoff's, there must be reason for this... Does your database have the auto_close option on? (if yes, turn it off, it's performance-hell ) ) Which Servicepack from SQL are you using? Lee-Z "bill" <bill (AT) dingey (DOT) com.tw> wrote in message news:4273004e$1 (AT) newsgroups (DOT) borland.com... But I already have chosen "None", It still has the auditing event. Thank you. bill "Lee-Z" <Lee-Z.spam (AT) zonnet (DOT) nl> ¦b¶l¥ó news:42723725$1 (AT) newsgroups (DOT) borland.com ¤¤¼¶¼g... Yes, I assume that if you choose Audit level "None" SQL won't audit the logins (and you should only see the login activity itself in SQL profiler...not the auditing stuff) good luck, Lee-Z "bill" <bill (AT) dingey (DOT) com.tw> wrote in message news:42722ce7$1 (AT) newsgroups (DOT) borland.com... Yes, I am a DBA. You mean if auditing is disabled I can work around it . Is it true? Thank you. bill "Lee-Z" <Lee-Z.spam (AT) zonnet (DOT) nl> ¦b¶l¥ó news:427227d1 (AT) newsgroups (DOT) borland.com ¤¤¼¶¼g... Are you also DBA for this MSSQL server? In that case check out the Security settings from the server (in EM: SQL Server properties -> Security tab - Audit Level)... If auditing is enabled on the Sql Server I don't think you can work around it (that would kinda defeat the purpose.....) regards, Lee-Z "bill" <bill (AT) dingey (DOT) com.tw> wrote in message news:4271f0e4$1 (AT) newsgroups (DOT) borland.com... Hi, I am using Delphi5.0 + MSSQL2000. I have an multi-user AP. Sometimes the AP is very slowly. I used the Sql Profiler to trace: I found there are som event class-- Audit Login and Audit Logout. The events took a long duration: 60000 --- 300000. (mm Seconds) So the reason of slowly is the Audit login and Audit logout event. I just know the event is Implicit Connection of SQL Server But I don't know how to avoid the event. Please help me. Thanks bill PS: I use Delphi5.0 (TADOConnection + TDgADOQuery) -----> + MSSQL2000 Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         BorlandTalk.com Forum Index -> Delphi Databases (SQL Servers) All times are GMT Page 1 of 1   Jump to: Select a forum C++ Builder Newsgroups----------------C++ BuilderC++ Builder (ActiveX)C++ Builder (Announcements)C++ Builder (Command Line Tools)C++ Builder DatabasesC++ Builder Databases (ADO)C++ Builder Databases (Desktop)C++ Builder Databases (InterBase Express)C++ Builder Databases (Multi-Tier)C++ Builder Databases (SQL Servers)C++ Builder (Graphics)C++ Builder (IDE)C++ Builder (Internet)C++ Builder (Internet Socket)C++ Builder (Internet Web)C++ Builder (Jobs)C++ Builder (Language)C++ Builder (Language C++)C++ Builder (Compatibility with MFC)C++ Builder (Native API)C++ Builder (Non-Technical)C++ Builder (Students)C++ Builder (Third Party Tools)C++ Builder (Upgrade)C++ Builder (VCL)C++ Builder (VCL Components Usage)C++ Builder (VCL Components Development)C++ Builder (VCL Usage)C++ Builder (WinAPI)C++ Builder Installation Delphi Newsgroups----------------Delphi (General)Delphi ActiveX Controls UsageDelphi ActiveX Controls DevelopmentDelphi As400Delphi DatabasesDelphi Databases (ADO)Delphi Databases (dbExpress)Delphi Databases (Desktop)Delphi Databases (InterBase Express)Delphi Databases (Multi-Tier)Delphi Databases (SQL Servers)Delphi DeploymentDelphi GraphicsDelphi IDEDelphi InternationalizationDelphi InternetDelphi Internet Isapi-WebBrokerDelphi Internet WebSnapDelphi Internet WinsockDelphi JobsDelphi Language BASMDelphi Language ObjectPascalDelphi Model Driven Architecture (General)Delphi Model Driven Architecture (Third Party)Delphi MultimediaDelphi Native APIDelphi Non-TechnicalDelphi ObjectPascalDelphi OLE AutomationDelphi OO designDelphi OpenToolsAPIDelphi Reporting-ChartingDelphi RTLDelphi StudentsDelphi TeamSourceDelphi Thirdparty ToolsDelphi Thirdparty Tools (General)Delphi Thirdparty Tools (IntraWeb)Delphi Thirdparty Tools (RaveReports)Delphi UpgradeDelphi VCLDelphi VCL ComponentsDelphi VCL Components UsingDelphi VCL Components WritingDelphi WebServices SOAPDelphi WinAPIDelphi XMLDelphi Installationcomp.lang.pascal.delphi.components.misccomp.lang.pascal.delphi.components.usagecomp.lang.pascal.delphi.components.writingcomp.lang.pascal.delphi.databasescomp.lang.pascal.delphi.misccomp.sources.delphi JBuilder Newsgroups----------------JBuilderJBuilder AnnouncementsJBuilder Applet IssuesJBuilder As400JBuilder CompilerJBuilder CORBA/RMIJBuilder DatabasesJBuilder DB SwingJBuilder DebuggerJBuilder DeploymentJBuilder DocumentationJBuilder EnterpriseJBuilder HandheldJBuilder IDEJBuilder JavaJBuilder JavaAPIJBuilder Java LanguageJBuilder Java SwingJBuilder Java BeansJBuilder Java Beans UsageJBuilder Java Beans DevelopmentJBuilder JBCLJBuilder JDataStoreJBuilder JobsJBuilder LinuxJBuilder MacintoshJBuilder & MobileSetJBuilder MultiLingual AppsJBuilder Non-TechnicalJBuilder OpenToolsJBuilder Servlets (JSP)JBuilder StudentsJBuilder Team DevelopmentJBuilder Thirdparty ToolsJBuilder UpgradeJBuilder Installation InterBase Newsgroups----------------InterBaseInterBase Bug DiscussionInterBase GeneralInterBase IBConsoleInterBase OpenSourceInterBase ReplicationInterBase SQLInterBase ThirdpartyInterBase Installation Miscellaneous Borland Newsgroups----------------AppCenterAppServerEnteraVisiBroker  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.