very custom filter in SQL Server Profiler 2012
-
2012년 7월 8일 일요일 오전 10:23
Hello, is it possible to insert my own custom filter to skip logging some events I'm currently not interested in? For example, I need to analyze only some stored procedure calls from limited set of users belonging to some windows role with arguments in some specific range. In other words, I need a filter that is more complex than simple LIKE, NOT LIKE.
Of course I can log all events and then write application that selects only rows that satisfy my criteria, but there are only about 0.01% such rows, so other will only waste space in HDD. Better sollution is to attach some custom filtering pluging (DLL) to prevent storing unnecessary rows, is it possible?
모든 응답
-
2012년 7월 9일 월요일 오전 6:16
You can filter the TextData column using wildcards %<searchterm>% which should allow you to filter to the stored procedure name and parameter names as you can add multiple wildcard filters, i.e. like %usp_GetProducts%, like %ProductID% etc, this is on top of filters by database name and login etc. If this is not sufficient can you give a more detailed example of what filters you require.
Thanks
/Neil Moorthy - Senior SQL Server DBA/Developer (MCITP (2005/2008), MCAD, ITILv3, OCA 11g) Please click the Mark as Answer button if a post solves your problem
- 답변으로 표시됨 Maggie LuoMicrosoft Contingent Staff, Moderator 2012년 7월 16일 월요일 오후 3:33
.png)
