|
|
-
|
|
Baseline SQL Server and Benchmarking is an important aspect of troubleshooting Disk
Storage Performance problems. Not considering certain factors in the planning phase
causes problems. Initial analysis assists in this problem. Following are some general
areas to consider
......
|
|
-
|
|
DB2 9 Fundamentals Certification is completed.After a few years of avoidance, I decided to attain some DB2 certifications. I’d always placed greater emphasis on self study and experience. But having completed the first certification, I was pleasantly surprised about the level of detail requi......
|
|
-
|
|
To analyse SQL Server IO requirements and decide on RAID levels for different applications is complicated – with some expensive decisions. As the DBA I have to make recommendations with analytics to justify decisions.
Firstly, my approach is end-to-end – look at everything from tuning,......
|
|
-
|
|
Data Center Migration, Database Servers and data migration planning is critical to a successful migration. Enterprise architects tend to categorise database servers part of the shared services layer.
I’ve been involved in a few very large Data Center migrations as the Senior DBA for DB2 and ......
|
|
-
|
|
Outsourcing DBA tasks to an Offshore IT company is complicated task. In a major reshaping of staffing policies last year , I sourced 2 SQL server DBAs – from an offshore IT oursourcing company .
I’m based in the UK – working with the recruitment agent of the offshore IT outsourci......
|
|
-
|
|
Database size in DB2 - Find 3 methods I use to find the database size in DB2
METHOD 1 - GET_DBSIZE_INFO
============================
db2 connect to
db2 "CALL GET_DBSIZE_INFO (?, ?, ?, -1)"
METHOD 2a (in MB) snapshot_tbs_cfg
===============================
db2 connect to
db2 "select (sum(......
|
|
-
|
|
SQL Server xp_msver is a SQL Server system stored procedure, returning general sql server information I find it useful for gathering basic server build and server information. Run it as EXEC master..xp_msver
I use it when I need gather information for a SQL Server Inventory audit. I use the process......
|
|
-
|
|
SQL Server Database Size and Free Disk Space reporting is critical in high volume databases.
One of the modelling applications I manage, maintains a large SQL Server database inventory on one SQL Server 2005 Enterprise Edition instance. The application generates a database per modelling request. An......
|
|
-
|
|
DB2 get snaphshot for dbm displays the database manage level information.
Scanning the information available, you’ll notice instance monitor switches.
I use the Database manager status value to get the status. If no value is returned,
then I assume the instance is unavailable.
Repu......
|
|
-
|
|
SQL Server Automation is one of the best ways for a DBA to achieve more in less time. If a task is repeatable – then why run it manually?
A word of warning! There are automated jobs out in the SQL Server world that are causing more damage then help. I have seen plenty of Daily Shrink Databas......
|
|