DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Problem With a Query

Threaded View

  1. 07-26-2005, 04:20 AM #1
    tvrdileep
    tvrdileep is offline Member
    Join Date
    Oct 2001
    Location
    Doha, Qatar
    Posts
    103

    Problem With a Query

    Hai All.
    I have a Query that is showing about 456 consistent gets, using SQLTRACE, when I'm executing as a single user. But, when we are doing a Load Test, we are seeing lot of Logical Reads, about 95,233.0 Buffer Gets per single execution from Statspack. So, I would like to have your advices. The following are the details of the Query. Please help me.
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width