DBASQL Server

Extended Events Filter Predicate – 3000 characters limit

If you want to monitor your SQL Server instance traffic using Extended Events and you would like to capture near all statements except some common which are not useful for later analysis you can reach easily maximal limit 3000 characters for filter predicate:

There is sample of one filter we are using in production which is near this maximum. You can imagine lot of other things we would like to remove from capturing but we can’t because of the 3000 characters limit.

Leave a Reply

Your email address will not be published. Required fields are marked *