![]() ![]() I found a related question here (albeit from the other side), but that went unanswered.Īt this point I'm tempted to disable the user so I can capture some failed logins in the SQL errorlog, but I don't imagine the application team will be happy with that. Run a trace (Profiler or Extended Events) filtered on Application Name 'Microsoft SQL Server Management Studio'. The user is a SQL account that happens to be a SYSADMIN (yes, I know.).The query that an application runs is : SELECT. Nothing captured for program_name either I am new to the DBA side, but activity montior shows a high plan clount of 23438.To open the Job Activity Monitor, expand SQL Server Agent in Management Studio Object Explorer, right-click Job Activity Monitor, and click View Job Activity. sys.dm_exec_sessions shows the client_interface_name is ODBC If the SQL Server Agent service fails unexpectedly, you can determine which jobs were in the middle of being executed by looking at the previous session in the Job Activity Monitor.WHAT IS BATCH REQUESTS/SEC Batch Requests/sec is a performance counter that tells us the number of T-SQL command batches received by the server per second. I'd be fine with an IP address, too, but don't see any way to determine that from within SQL either. Batch Requests/sec is one of the data points that is used to measure how busy a server is. I've tried all the normal built-in and 3rd-party tools (, sys.dm_exec_sessions, sp_who2, sp_WhoIsActive, the SSMS Activity Monitor, even SQL Profiler and Idera Diagnostic Manager), none of them can give me the hostname of the server/client behind these connections, presumably because they all use the same underlying system tables/views. I stopped the SQL Advanced threat protection traffic extended event session and killed the SQL ATP for Queries process in the Activity Monitor but it. You can play the activity monitor on one side and this script in another window and verify the output. You can also sort the job information by clicking on a column heading in the Agent Job Activity grid. You can view all jobs on the server, or you can define filters to limit the number of jobs displayed. I have a busy SQL 2012 server where connections to one particular database (using the same SQL login) don't show a "hostname", and I need to find out which box (of several) these connections are coming from. I have modified the given script as follows. The Job Activity Monitor allows you to view the sysjobactivity table by using SQL Server Management Studio. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |