|
|
-
|
|
Currently working on a Webspere Business Monitor application integrating with DB2
9.5 on Linux. I've made a few observations.One
that is interesting, particuarly as Webspere Business Monitor uses BLOBs\CLOBs,
relates to HADR and BLOB\CLOB replication.
Database logs are us......
|
|
-
|
|
SQL Server Books online defines LOGMGR as "Occurs when a task is waiting for any outstanding log I/Os to finish before shutting down the log while closing the database"
Depending on what other waits are occurring – this could indicate an IO bottleneck. For example, if ASYNCH_IO_COMPLETION, IO......
|
|
-
|
|
SQL Server Books online defines IO_COMPLETION as “Occurs while waiting for I/O operations to complete. This wait type generally represents non-data page I/Os. Data page I/O completion waits appear as PAGEIOLATCH_* waits”
As with ASYNC_IO_COMPLETION it is a symptom of an IO bottleneck......
|
|
-
|
|
SQL Server Books online defines Async_io_completion as “Occurs when a task is waiting for I/Os to finish “
Mainly a symptom of an IO bottleneck. Cross check by identifying other wait stat indicators such as: IO_COMPLETION, WRITELOG,PAGEIOLATCH_X. The appearance of at least one of these......
|
|
-
|
|
Normally, if I’m doing some general health checks – I’ll issue a trace with some designated conditions- depending on the application. For example, it may be looking at Duration of queries on a specific database. This will give me some hints at what to analyse.
Once identifying th......
|
|
-
|
|
On the SQL Server performance stack one of the potential performance bottlenecks is the read-ahead rate at the Cache level.
The relational engine manages the method of access and the buffer manager. The methods of access relates to table scans & index scans. The buffer manager accesses and u......
|
|
-
|
|
Download the SQL Server 2008 R2 from the image library. This may take awhile as it’s a 5.5 GB. I prefer to do it from a local copy of files, as over the network it can take awhile.
From the command line run the following command.
C:\[SQLImagesPath]\setup.exe /ACTION=INSTALL /QUIET /FEAT......
|
|
-
|
|
Some thoughts on analyzing whether virtualization is a viable alternative to physical
servers.The general conclusion is that it offers very good management flexibility
particularly around DR – and for most applications I’ve tested on is acceptable.
The whole perfor......
|
|
-
|
|
These are the metrics I use in acceptance tests for a new implementation of a database server. I’ve got specific tests within each acceptance test
1)Maximum Rate – Defined as the ability of SQL Server to process data for a standard CPU \ Server Combination and SQL Query.It is important......
|
|
-
|
|
In the spirit of lists that seek to define habits practised by effective individual – I decided to list a generalised list for DBAs.
These are based on obseravations I’ve made of some excellent DBAs I’ve met over the years. The intention is to abstract some patterns – to enc......
|
|