High Page Reads

[rpowid]

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.

[Juergen Leis]

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.