var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Performance Issues
How can I check to see how views I created are affecting the performance of the database?
Do a showplan on the sql that the view is based on....
Thanks for all your help today and everyday!!
Do you know how to find showplan?
It's in QA under the menu item Query
Or just do [CTRL]-K
It's really called Show Execution Plan..
Look for scans of any kind....in some cases it's ok, in most it's bad...
I see it. Thanks. If I try set showplan on I get an error message that 'showplan' is not a recognized option. What does this mean? Is it because set showplan on is not recognized by SQL Server 2000?
Last edited by exdter; 01-14-04 at
You doing this QA? Are you in the correct database?
In the QA window, you have the view's sql.. Hit [CTRL]-K
And you get an error?
The ctrl K works. I was trying it by doing set showplan on go set noexec on go... but it only works in older versions. I got it the way you said. Thanks.
If the performance in your views is the issue, I would index the views (if possible).
Before doing SELECT * FROM VIEW_NAME right-mouse-click on the QA where the statement is typed and pick Current Connection Properties. There you can check Set statistics time and Set statistics io on. This way you can see CPU time, reads, writes, and scans.