|
|
-
|
|
Part of the Performance Tuning series – Performance Stack, this section looks at Access Path Tuning. How does the user access the data and how can the access be maintained. The purpose of the series is a general approach to Performance Tuning – independent of database server platform. A large ......
|
|
-
|
|
Use the script below to disable an index on a SQL Server table
ALTER INDEX MY_INDEX_NAME on MY_TABLE_NAME DISABLE;
Executing the code will prevent access to the index.
If it’s a CLUSTERED INDEX, the data remains intact on the table, but no DML can access the data. Drop the index or rebuild......
|
|
-
|
|
Tuning DB2 is critical if Websphere Portal is the main client. In larger Websphere Portal architectures, where load balancing is standard, this become obvious.
Follow these general guidelines to achieve faster response times on Portal requests. These guidelines don’t replace baselining\monitorin......
|
|
-
|
|
When a DB2 database starts the total memory required for the bufferpools must be available.
If this memory is not available when a database starts, the database manager will only start with system buffer pools (one for each page size) with a minimal size of 16 pages, and an SQL1478W (SQLSTATE0162......
|
|
-
|
|
Find bottlenecks in DB2 performance is part of maintaining good response times. Here's a useful approach to locating slow query response times. Focusing on scans
1) Run a “user level” workload and check “get snapshot for database” . Add “Rollback statements attempted” and “Commit statements at......
|
|
-
|
|
I was creating a Powershell script for a SQL Server checkout procedure after a reboot , and used the state_desc column in sys.databases view to report on the database status.
The descriptions, courtesy of BOL are:
ONLINE - Database is available for access
RESTORING – One or more files are......
|
|
-
|
|
The DB2 code set value defines the character encoding used by the database. Setting the appropriate value for translation, for example: Euro symbol and DB2 database codeset
To get the DB2 database code set value, use:
db2 get db cfg for MY_DB
--From a command line, such as Putty,
db2 get ......
|
|
-
|
|
For Tivoli Application Dependancy Discovery Manager (TADDM) to successfully discover DB2 instances, standardising OS and DB2 security access is the key, particularly for a large DB2 server inventory.
A non – standardised approach can lead to may hours of troubleshooting and false negatives.
Buil......
|
|
-
|
|
A sql reindex command was being blocked by two active transactions in MS DTC. Use
sys.dm_tran_active_transactions to report more detail on transactions
select * from sys.dm_tran_active_transactions where transaction_uow = '922D5B60-A5CA-4C96-8891-703021B40AD8'
/*Returns:
Transact......
|
|
-
|
|
To set a DB2 database cfg value to an empty value use NULL.
It’s case sensitive. Using “null” will not work.
An example:
update db cfg for MYDB using HADR_LOCAL_HOST NULL
Republished from http://www.sqlserver-dba.com.......
|
|