My head hurts from hitting it against a wall–SSMS log viewer
Every time I go to a client to do a review I find I’m looking in the event log trying to find information. Every time I feel like I’m hitting my head against a wall as the process is awful and painful.
Given SQL is a relational database production the error log makes its best to hide that fact. You can’t sort results. You can filter them but only to find stuff you can’t exclude messages.
Features I would like to see include the following
1. a means to exclude messages
2. more categorisation
3. sortable columns
4. Exclude filters not just include ones
5. Time filtering using a slide bar.
I’ve raised a connect item to see if we can get improved https://connect.microsoft.com/SQLServer/feedback/details/671840/improve-the-log-viewer-to-aid-monitoring-and-manaagement