Thursday, 15 April 2010

sql server - Identify individual sql user in SQL profiler And activity monitor -


We are using SQL 2005 and we want to identify individual users so that we know the performance of our SQL But we can use SQL 2005 with connection pooling so that every user's activity monitor should be the same user. The name of their NT user is not set - perhaps because we are not using SQL Server users, we are also using CITRX so that no IP address is set. How can you identify a different user in this (very common) environment?

If all the same users are using the same username and come from the same IP you tell them different MSSLQL will not even be told if the user is not using the authentication of windows, then what is the name in the user's connected windows?

Have you considered changing your setup so that it uses Windows authentication? It seems like a logical solution to the problem either, or setting up different logs for everyone on SQL, but it must duplicate your Active Directory user list ...


No comments:

Post a Comment