|
|
-
|
|
Lazy writing , eager writing and checkpoint use asynchronous IO in writing pages to disk. The purpose of asynchronous IO is to release resources and for other tasks to progress.
i.e releases the thread to allow further threads.Usually this takes less than 10 ms – but under circ......
|
|
-
|
|
What if you had to create a script stack that installs SQL Server from an image library? And customisations – such as adding the SQL Server Start up account to the Lock Pages in Memory Local Policies?
If this needs to be rolled out quickly across hundreds of servers, or just one, then there ......
|
|
-
|
|
The Storage manager asks the DBA questions about SQL Server Storage suggestions. As the DBA you will need to answer or advise the recommendations. This could happen when a) a new storage array is under consideration b) Performance analysis c) Data Centre migrations.
These are questions I&rsqu......
|
|
-
|
|
I document the CPU Count for SQL Server inventory management.
Using a powershell script , iterate through all the SQL Servers and capture the CPU count with the following t-sql.
----Returns the logical cpu count on server
SELECT cpu_count FROM sys.dm_os_sys_info
----Ratio of the number of lo......
|
|
-
|
|
This DB2 error message SQL2219N reason code 9 appeared in the db2 db2diag file.
The DB2 documentation details for reason code 9 are “START is not allowed as a prior paused table reorganization has not been stopped”.
I discovered there was a s...
|
|
-
|
|
Nmon is a tuner and benchmark tool on Linux. Capture disk, cpu, memory , filesystem, resource usage, virtual memory
As a DB2 DBA it's a very effective method of capturing different types of in data in one interface.
nmon is useful ...
|
|
-
|
|
After you’ve installed the DB2 server – there may be a situation where you need to uninstall DB2.
These notes will help
db2_deinstall -F - Removes a feature from a DB2 database product in the current location. Execute the command from the DB2...
|
|
-
|
|
To return only severe messages
db2diag –merge db2diag.1.log db2diag.2.log -level severe ? Merge 2 dlog files filtering on severe
...
|
|
-
|
|
This article describes some methods of checking DB2 is running on a Linux Server
Method 1
Log onto the server and execute db2start as the instance owner. If the instance is running you’ll see , something like:
02/10/2012 23:36:14 0 0 SQL1026N The database manager is already active......
|
|
-
|
|
To copy a table from another SQL Server Instance is easy. Create a Linked Server on the destination server and reference the Linked Server in the SELECT statement.
1) Create linked server
/****** Object: LinkedServer [SERVER1\SQL_SERVER_INSTANCE_1] Script Date: 02/02/2012 09:29:33 ******/
EX......
|
|