Indetifying views in profiler

20 Sep 2006 11:31 AM

Buk Usu

Does anyone know of a way to identify views from profiler ?

I have poorly performing views on a large system and no direct way to point
back to one particular one

Thanks

20 Sep 2006 12:11 PM

Hilary Cotter

As far as I know, there is no way to do this other than looking in textdata
for direct references to the view.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

Show quote

"Buk Usu" <buk***@gmail.com> wrote in message
news:ObHoJhK3GHA.5024@TK2MSFTNGP02.phx.gbl...
> Does anyone know of a way to identify views from profiler ?
>
> I have poorly performing views on a large system and no direct way to
> point back to one particular one
>
> Thanks
>

21 Sep 2006 7:10 AM

John Bell

Hi

Any query that is poorly performing would show up with high cpu/reads/writes
or duration, therefore if you analyse the worst performing queries in general
you should be able to decide improvements needed in general and not just one
specific view.

John

Show quote

"Buk Usu" wrote:

> Does anyone know of a way to identify views from profiler ?
>
> I have poorly performing views on a large system and no direct way to point
> back to one particular one
>
> Thanks
>
>
>

3 Oct 2006 10:45 PM

Simon Sabin

Hello Buk,

A view is not a structure unless indexed, it is only a means by which code
can be simplified/abstracted.

What happens is that whe a query is run with a view, the views query is combined
into the main query and that is then optimised. So the view isn't something
that exists in the compilation/execution process.

As already has been said. If looking for poor performance then look for high
cpu, reads, writes or duration

Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons

Show quote

> Does anyone know of a way to identify views from profiler ?
>
> I have poorly performing views on a large system and no direct way to
> point back to one particular one
>
> Thanks
>