-
High Page Reads
SQL 6.5 - 5.5 Gig
NT
Hello,
Throughout the day our Document Management application generates high busts of physical page reads when users query the database.
What SQL configuration parameter(s) should I check/modify to insure that the database is performing at it's optimun during these bursts?
Thank You in advance.
-
High Page Reads (reply)
Before modifying the Configuration options, You should use SQL Trace,
capture and identify the statements that cause these execssive physical reads
and check wheter you can add Indexes, must manage statistics or reindex etc.
Especially check whether Your clustered indexes can be used better.
------------
rpowid at 1/17/2002 11:22:26 AM
SQL 6.5 - 5.5 Gig
NT
Hello,
Throughout the day our Document Management application generates high busts of physical page reads when users query the database.
What SQL configuration parameter(s) should I check/modify to insure that the database is performing at it's optimun during these bursts?
Thank You in advance.
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
|
|