Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Learn about SQL Server DBA, SQL Server database performance,SQL Server optimisation,database tuning,t-sql,ssis
Browse by Tags · View All
DBA Scripts 51
performance 37
SQL Server 29
Object Management 24
#SQLServer 24
Backup and Restore 20
Security Management 20
Powershell 17
Indexes 14
DBA 14

Archive · View All
June 2011 38
January 2011 33
May 2011 32
August 2011 27
July 2011 26
January 2012 24
February 2011 19
April 2011 19
March 2011 17
March 2012 17

Jack Vamvas's Blog

DB2 SORTHEAP and pinned pages

Feb 27 2012 12:00AM by Jack Vamvas   

This post discusses SORTHEAP DB2 and pinned pages Information message in db2diag.log

FUNCTION: DB2 UDB, buffer pool services, sqlbKeepPagesPinned, probe:20
MESSAGE
: ADM6071I  The maximum number of pinned pages allowed concurrently was
          reached in buffer pool "MYBUF8K" (ID "2").  As a result performance
          may not be optimal. Increasing the SORTHEAP database configuration
          parameter may reduce the chances of this condition occurring in the
          future.

Notes

1)  The message refers to the  sqlbKeepPagesPinned  function.

2)  The message indicates the specified buffer pool is too small for current activity.

3)   This also points to high CPU usage

4) Recommend index analysis focusing on indexes using the sort heap.Including hash join buffers, in memory tables, dynamic bitmaps

5) If  SORTHEAP isn’t set at AUTOMATIC , increase the level if large sorts are used.

See Also

DBA Interview Questions and Answers – DB2 Server Operations  

 

Republished with author's permission. See the original post here.


Republished from SQL Server DBA [65 clicks].  Read the original version here [32134 clicks].

Jack Vamvas
5 · 27% · 8528
0
Liked
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

Your Comment


Sign Up or Login to post a comment.

    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]