Results 1 to 11 of 11
  1. #1
    Join Date
    Aug 2003
    Posts
    328

    Unanswered: Performance Issues

    How can I check to see how views I created are affecting the performance of the database?
    Thanks.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Do a showplan on the sql that the view is based on....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Aug 2003
    Posts
    328
    Thanks for all your help today and everyday!!

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    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...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Aug 2003
    Posts
    328
    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 16:31.

  6. #6
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    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?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  7. #7
    Join Date
    Aug 2003
    Posts
    328
    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.

  8. #8
    Join Date
    Feb 2002
    Posts
    2,232
    Are your views indexed ?

  9. #9
    Join Date
    Aug 2003
    Posts
    328
    No.

  10. #10
    Join Date
    Feb 2002
    Posts
    2,232
    If the performance in your views is the issue, I would index the views (if possible).

  11. #11
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •