sql-server-profiler

how can i turn off lines from "Report Server" on my SQL Server Profiler?

It\'s my first time using SQL Server Profiler and I\'m wondering how can i turn off event lines from the application \"Report Server\" on my SQL Server Profiler? I just want certain activities to be l[详细]

2023-04-12 16:08 分类：问答

SQL Server Profiler - Column Meanings

Can anyone point to a ref开发者_运维知识库erence which describes what is being returned in the IntegerData and IntegerData2 columns. I am particularly interested in their meaning for SQL:StmtCompleted[详细]

2023-04-10 03:27 分类：问答

How can I use SQL Server Profiler to view the TSQL ran in a CLR trigger?

How can I user SQL Server Profiler to view the TSQL ran in a CLR trigger? I have a CLR trigger in the a MS SQL Server 开发者_运维百科DB, that checks the Inserts, Updates, Deletes on a table and then[详细]

2023-04-09 10:22 分类：问答

Compare two SQL Server Profiler traces

I want to compare two SQL Server profiler t开发者_如何转开发races, any tool does this? Thanks,[详细]

2023-04-09 05:58 分类：问答

Reading SQL deadlock graph

Can someone please help me to read/understand this deadlock graph? I don\'t understand why process 75 is requesting a lock on an object that he has a lock on already?[详细]

2023-04-01 14:36 分类：问答

SQL Profiler 2008 Deadlock Graph ToolTip Not Showing actual statements

In a deadlock graph, hovering over the deadl开发者_如何学运维ock ovals should produce the SQL statement. However, in SQL Profiler 2008, the ToolTip is either showing \"Statement\" or \"Statement Proc\[详细]

2023-04-01 12:13 分类：问答

is it possible that SQL Profiler trace does not show calls done within a trigger?

I am just suspicious that the SQL Profiler does not show the calls done within by one of the triggers I have.[详细]

2023-03-11 20:44 分类：问答

How can I write a message to SQL profiler from Sql a query?

I am troubleshooting for some SQL issue and I use SQL Profiler in order to diagnose some problem. Is it pos开发者_StackOverflowsible to write some messages into SQL Profiler by adding some lines in a[详细]

2023-03-11 02:28 分类：问答

How to see the SQL queries generated by NHibernate

开发者_Go百科I\'m using SQL server express edition with ASP.NET MVC, there is not a profiler in express editions so I can\'t see the queries generated by NHibernate. I\'m concerned about the performan[详细]

2023-03-05 20:14 分类：问答

sql profiler filters: stored procedure where parameter value = X

I want to profile a stored procedure but only when the input parameter is equal to a specific value. I\'m currently doing an RPC: Starting with a filter on ObjectName for the stored procedure which wo[详细]

2023-03-01 08:43 分类：问答