Advanced Search

Return to Snippet

Revision: 25605
at April 2, 2010 04:54 by tvanzele
Initial Code 
SELECT login_name, COUNT(session_id) AS [session_count] 
FROM sys.dm_exec_sessions 
GROUP BY login_name
ORDER BY COUNT(session_id) DESC;
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Get current users and # sessions

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
sql

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL