here is the table

CREATE TABLE [dbo].[TBL_REPORT_COLLECT_USERS_CONNECTION](

[RUN_TIME] [datetime] NOT NULL,

[USERS_COUNT] [int] NOT NULL,

[CONNECTION_COUNT] [int] NOT NULL

here is the insert every hour

INSERT INTO TBL_REPORT_COLLECT_USERS_CONNECTION(RUN_TIME,USERS_COUNT,CONNECTION_COUNT)

SELECT GETDATE()AS 'RUN_TIME',COUNT(DISTINCT loginame) AS 'USERS_COUNT',count(spid)AS 'CONNECTIONS_COUNT'

FROM master.sys.sysprocesses

WHERE...

my problem is right there,when i clean the buffer on both server the first run take 1.5min in both of them.

but on the second run without the buffer clean the...

OK.

and the difference in the sql server machine while the database are the same,can i check anything on that matter?

no physical reads on the new server on the second run.

if i remove the (ltrim(rtirm()) the results are very good.

why the ltrim rtrim do that?

no i can't change the query.

this is the weird thing i run the query a lot of time in the slow server and the results are the same 1.5 min...

execution plans attached.

THX

hi

i upload the database to new server (more stronger CPU,MEM,DISK I/O).

and i see strange results when i run the same query.

is there any explanation to that kind of results while...

thanks for the replay.

what are my other options if i can't use HINT on the query because i can't mess with the query that come out from the ERP?

what i meant is if the user successfully made the logon but failed in the trigger because something is wrong with the trigger (the table was delete or no permission...

how i can write this logon trigger that if i the user have an error in the trigger his logon processes will still be successfully but i will be notified...

yes this is one of my thought.

the question is when working with the profiler for logon and logout event,

how i can calculate to actual time that the user spent in...

thanks for your help.

i'm looking on different approach and i will update later.

why i can't filter the login to capture only users that use the erp.

we have a table with the erp users in database called system.

when i add the syntax to...

hi,

i need to know how much time the user spent in the erp program.so if the user enter to the program and then he open new windows from that program...

so how other counters work in the xp_cmdshell and other not?