1
vote
Get username and/or IP address responsible for a query
Top blocking session user can check by
select r.session_id, r.blocking_session_id, r.cpu_time, r.total_elapsed_time, r.status,
s.login_name,c.client_net_address,s.host_name,s.program_name,st.text, s....
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
performance × 6456query-performance × 2102
sql-server × 2088
mysql × 1743
postgresql × 1329
optimization × 618
index × 616
postgresql-performance × 463
performance-tuning × 454
database-design × 343
execution-plan × 312
oracle × 299
sql-server-2012 × 274
innodb × 250
sql-server-2008-r2 × 218
sql-server-2008 × 207
join × 204
index-tuning × 198
sql-server-2014 × 170
sql-server-2016 × 167
t-sql × 154
mariadb × 141
sql-server-2005 × 110
mysql-5.5 × 104
partitioning × 101