|
Home > Archive > MS SQL Server Tools > October 2006 > Indetifying views in profiler
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Indetifying views in profiler
|
|
| Buk Usu 2006-10-24, 6:45 pm |
| 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
| |
| Hilary Cotter 2006-10-24, 6:45 pm |
| 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
"Buk Usu" <bukusu@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
>
| |
| John Bell 2006-10-24, 6:45 pm |
| 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
"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
>
>
>
| |
| Simon Sabin 2006-10-24, 6:45 pm |
| 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
> 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
>
|
|
|
|
|