|
|
-
|
|
Find bottlenecks in DB2 performance is part of maintaining good response times. Here's a useful approach to locating slow query response times. Focusing on scans
1) Run a “user level” workload and check “get snapshot for database” . Add “Rollback statements attempted” and “Commit statements at......
|
|
-
|
|
Network card teaming or NIC teaming are networking terms describing methods of combining multiple parallel network connections . The main purposes are 1) increasing throughput beyond a single connection and 2) redundancy.
The three main teaming configurations
Network Fault Tolerance (NFT)
1) ......
|
|
-
|
|
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......
|
|
-
|
|
Sometimes end users interchange the terms : C2 auditing and Traces. They server different purposes.
c2 auditing records all attempts (successfull and failed) on objects and statements. Typically a SQL Server DBA will use a c2 audit to monitor security compliance .
A trace will will monitor an even......
|
|
-
|
|
While troubleshooting a DB2 performance problem for Websphere Portal 6.1.0 using DB2 9.5 Enterprise Edition , one of the DB2 tuning recommendations from the Portal Tuning guide was to set MAXFILOP = 512 or higher
MAXFILOP is the Maximum database files open per application configuration para......
|
|
-
|
|
I was creating a Powershell script for a SQL Server checkout procedure after a reboot , and used the state_desc column in sys.databases view to report on the database status.
The descriptions, courtesy of BOL are:
ONLINE - Database is available for access
RESTORING – One or more files are......
|
|
-
|
|
The Environment Variable DB2_RR_TO_RS enables\disables the Repeatable Read attribute. I's enabled for DB2 performance purposes
DB2 registry parameter DB2_RR_TO_RS is used to:
Set a default isolation level for user tables to Read Stability (RS) isolation level. The RS level is not dissimilar to......
|
|
-
|
|
Latency is the time delay measure in the system. SQL Server can only be as fast as the slowest component in the system.
Database servers are particularly sensitive to disk IO speeds. For example, introducing an SVC system may speed up writes, but will add a cost to Reads.
Latency is about benchm......
|
|
-
|
|
To make the T-SQL function DATEADD more dynamic use variables. The example below, accepts an input parameter, in this case “4”.
All events older than 4 months from now will be deleted.
DECLARE @months int
SET @months = 4
DELETE FROM [Events] WHERE [EventDate]
Republished from http://www......
|
|
-
|
|
An XA transaction is a global transaction usually covering multiple resources.
Use the Microsoft SQL Server JDBC Driver to support the Java Platform based distributed transactions
Steps to enable XA transactions
1) Enable MSDTC
On Windows 2003 > Start > Run > “dcomconfg” > Expand Componen......
|
|