|
|
-
|
|
Data compression allows more rows to be stored in a page, but the maximum row size
of a table or index does not change.
Compressed data is stored on fewer pages therefore less pages to read therefore
less IO intensive. The cost is increased CPU to compress and ......
|
|
-
|
|
The /var folder on a Red Hat Linux server was reported as only 1% space left.
The DB2 binaries and data\ log files were on their own drive space.
Normally, I search for the Linux largest files and assess whether they require pruning. Occasionally I use the command:
yum clean all
Firstly, what ......
|
|
-
|
|
I use Powershell for standardised scripts across the server inventory such as running a job collection, security audit or performance statistics collection. Powershell to HTML is another option of displaying data and distrinuting to users.
Normally, I either save out the results in an Excel sprea......
|
|
-
|
|
The SQL Server memory management Address Windowing Extensions (AWE) is not supported in the next version of SQL Server.
It remains available in SQL Server 2008 R2, but avoid using in current development work.
For me, this means adjusting build scripts for Standard Edition 32 bit installations. ......
|
|
-
|
|
I use ADMIN_DROP_SCHEMA to drop a schema and its objects. The main advantage of
using the procedure, instead of writing a customised script is there could be routines
such as stored procedures or UDFs with cross dependencies and require to be dropped
in a certain......
|
|
-
|
|
Designing Redundancy for SQL Server is critical for High Availability (HA) and Disaster Recovery (DR) strategies.
General areas in considering the HA and DR stack.
Physical locations (buildings,geography)
Electricity
Network
Storage
Load Balancers
Servers
Web Layer
Database Layer
Manag......
|
|
-
|
|
As part of the Performance Tuning series – Performance Stack , this section looks at Operating System tuning. The purpose of the series is a general approach to Performance Tuning – independent of database server platform. A large proportion of DBAs support more than one type of datab......
|
|