September 19, 2011 at 8:47 pm
How can I determine sql server view utilization. My compyan uses alot of views and I'm trying to determing how often the views are executed.
September 19, 2011 at 10:05 pm
Views are more like tables than stored procedures. To find out the usage, you will need to run a trace.
Alternatively, only allow access to views via stored procedure. Then the stored procedure execution can be tracked.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 20, 2011 at 6:36 am
Thanks. Yes I have some sql that will tell me the last time a stored procedure was executed. That's a good practice to have only allow views in a stored procedure. Unfortunately, I'm not that lucky. They use stored procedures, dynamic sql. This all occurred way before I came on board.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply