|
|
-
|
|
Specialise or a generalise? It all depends on how you define these terms.
A SQL Server DBA may be considered to be a specialist by a Enterprise Architect but a generalist by a SSIS expert.
The DBA is currently in great demand and based on predictions re: User Devices and Database Servers<a ......
|
|
-
|
|
When log records remain active for a long time – truncation can be delayed. The delays can cause the transaction logs to fill. This can lead to a Error 9002
In the Full Recovery mode , a Log Backup will delete the commited transaction log records. In the Simple Recovery , it’s after a......
|
|
-
|
|
On a routine scan of Event Viewer System, Logs I found this message on 4 different servers hosting SQL Server installations
The kerberos client received a KRB_AP_ERR_MODIFIED error from the server MYCOMPUTER$. This indicates that the password used to encrypt the kerberos service ticket is differe......
|
|
-
|
|
To display network connections and various network interface statistics – netstat is a handy command – line based tool.
Why is it useful for the DBA ?
Execute netstat –an to view all active connections (TCP and UDP ports) on a server. The DBA has a quick overview of networ......
|
|
-
|
|
1) SQL Server 2008 R2 Reporting Services doesn’t support Windows 2003 (or R2) Itanium based servers
2) SQL-DMO support is stopped in SQL Server 2008 Express
3) Cannot enable Web Assistant with sp_configure. MS recommend using Reporting Services
4) Surface Area Configuration Tool is disconti......
|
|
-
|
|
Q.What are the contents of a DB backup ?
A. The items contained are dependant on the backup method , such as database or TABLESPACE
Use the backup utility : db2ckbkp to interrogate the contents of a DB2 backup. db2ckbkp checks integrity and displays meta information
For example, if you use the......
|
|
-
|
|
Common reasons for query time-outs are :
1) The application starts using a query not optimal for the index
2) Hardware changes\ Configuration changes
3) Increased load
If you suspect the query time-out is due to memory issue , continue reading.
Debugging a query-timeout is tricky. I......
|
|
-
|
|
Managing a large SQL Server inventory requires an efficient management processes.
Following on from DBA productivity and less is more , this post outlines the system I use to manage the DBA scripts across the database server environment
1) Develop a script library covering the essentials ......
|
|
-
|
|
To list a SQL Server Agent Job Steps use the T-SQL example below.
This example displays the step id, SQL Server Agent Job name, Step name.
The code has 1 input parameter - @job_name
DECLARE @job_name VARCHAR(128)
SET @job_name = 'My SQL Server Agent Job'
SELECT js.step_id ,j.name,js.step_name F......
|
|
-
|
|
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 r......
|
|