We're using SQL Server 2000 and we'd like to be able to track our view
usage to tell which of our views get used most often. This will help
us determine which views we need to concentrate on first for
optimizing, indexing, etc... Does anybody know if there's a way to
tell when a view is opened?

Thanks,

Gary

Gary DeRousse (garyderousse@yahoo.com) writes:
> We're using SQL Server 2000 and we'd like to be able to track our view
> usage to tell which of our views get used most often. This will help
> us determine which views we need to concentrate on first for
> optimizing, indexing, etc... Does anybody know if there's a way to
> tell when a view is opened?

I would guess the Profiler is your best bet.

--
Erland Sommarskog, SQL Server MVP, sommar@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Thanks for the answer. I had briefly thought of the Profiler but not
knowing much about it, didn't know if it's suitable for this length of
tracking, which would probably be anything from a couple of months, to
a permanent type of thing. But I'll look into it more.


Erland Sommarskog <sommar@algonet.se> wrote in message news:<Xns93F321C532A4Yazorman@127.0.0.1>...
> Gary DeRousse (garyderousse@yahoo.com) writes:
> > We're using SQL Server 2000 and we'd like to be able to track our view
> > usage to tell which of our views get used most often. This will help
> > us determine which views we need to concentrate on first for
> > optimizing, indexing, etc... Does anybody know if there's a way to
> > tell when a view is opened?
>
> I would guess the Profiler is your best bet.

Gary DeRousse (garyderousse@yahoo.com) writes:
> Thanks for the answer. I had briefly thought of the Profiler but not
> knowing much about it, didn't know if it's suitable for this length of
> tracking, which would probably be anything from a couple of months, to
> a permanent type of thing. But I'll look into it more.

Yeah, I agree that it is not the most optimal tool for the task, but this
the standard reply to this sort of question.

It takes some elaborate filtering to get some useful data.


--
Erland Sommarskog, SQL Server MVP, sommar@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp