Activity overview
Latest activity by GrantF
There isn't an easy to monitor just a table. Now, you could capture sql_batch_complete events and do a search inside the query text for your table name as a filter. However, it's going to be a somewhat poor filter and might put some load on the server. You'd want to experiment with this carefully. It won't show you any views accessing the table, because, as you say, SELECT * FROM MyView, doesn't show which tables are in the view. To capture views, you'd need to add an additional filter, again on the query, and look for the views, that you can look up on your own, that MIGHT access the table (the optimizer can eliminate tables from a view through part of the optimization process called simplification, where it determines if all tables listed in the query are needed in order to satisfy it). You would also need to walk through your stored procedures and identify which of those is hitting the table in question. Those are easy to filter since rpc_completed, the event you need, lists the object name. Simplest part of the equation here. I'm not sure how you'd do prepared statements though, if you have those. That would take some experimentation. But yeah, as you can see from all this, trying to monitor access to a table is very difficult. Why do you need to do that? Is there another way to satisfy the business need? / comments
There isn't an easy to monitor just a table. Now, you could capture sql_batch_complete events and do a search inside the query text for your table name as a filter. However, it's going to be a some...
Pretty much anything that's applicable to Log Shipping. I'm actually not that expert at it to suggest what to do. / comments
Pretty much anything that's applicable to Log Shipping. I'm actually not that expert at it to suggest what to do.
Just coming back in to try to bump this on to people's radar. I really could use some help here everyone. / comments
Just coming back in to try to bump this on to people's radar. I really could use some help here everyone.
Needed, Custom Metrics on Log Shipping
Hey all you beautiful and intelligent people!You too @ChrisYates I have a request. We don't have a single custom metric on our SQL Monitor Custom Metrics site on the topic of Log Shipping. If one, ...