|
We are seeing periodic system slowdowns with our ODBC jobs that connect to our 570. When I get alerted to the slowdowns the first thing I look at is the WRKDSKSTS screen and our Internal drives on the system asp are running at 90+ %. Then when I look at WRKSYSSTS screen I see the following Current unprotect used . : 61314 M This seems really high to me. When the slowdowns stop that same thing shows 18316 M. I have run the DBMON and produced some reports that show some indexes that should be built. What else should I be looking at. We are getting into a very busy time of year for us and these slowdowns cannot continue. John Bresina Jr Sr Server Engineer - Midrange Team Allianz Life of North America 5701 Golden Hills Drive Minneapolis, Mn 55416 763 582 6761 ----------------------------------------- CONFIDENTIALITY NOTICE: The information in this message, and any files transmitted with it, is confidential, may be legally privileged, and intended only for the use of the individual(s) named above. Be aware that the use of any confidential or personal information may be restricted by state and federal privacy laws. If you are not the intended recipient, do not further disseminate this message. If this message was received in error, please notify the sender and delete it.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
