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 extend database server capacity

Jan 19 2011 7:48AM by Jack Vamvas   

A quick solution for extending capacity on a database server is normally a) add more memory b) add disk space and expand containers C) additional processors d)add partitions.

If adding more procesors and system is SMP the processors will automatically share storage resources and memory. Consider any changes that may need to occur to the following parameters:

Default degree (dft_degree)

Default degree configuration parameter Default value = 1 and is equivalent to no intra-partition parallelism. If -1, the optimizer decides n level of intra-partition parallelism.

Maximum degree of parallelism (max_querydegree)

(Maximum degree of intra-partition parallelism )If -1, the optimizer decides otherwise set relevant value.

Enable intra-partition parallelism (intra_parallel)

Defiines whether the database manager can use intra partition parallelism.

Dont necessarily make changes to the parameters prior to a proper review and testing of the impact of these changes.

If adding more partitions and the database manager is currently on a partitioned database environment then storage resources# memory can be increased by adding either single or multi processor partitions.. Each partition manages its own resources. The main advantage of this approach is that data and user audit can be balanced over different systems. Keep in mind that this could cause other problems so some planning and testing is required.

Republished from

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

Jack Vamvas
5 · 26% · 8528


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]