SQL Server Performance Monitor Counters

Posted in SQL Server with tags , , , , , on January 1, 2012 by DBAWork

As we are aware SQL server has certain counters which can be monitored to have better performance using SQL server. We will try to elaborate on all counters. These are counters we need to monitor on regular basis.

We will see what is meaning of Batch Requests/Sec counter, how to read it from SQL server.

To get a feel of how eventful SQL Server is, observer this SQLServer counter. This counter processes the number of batch demands that SQL Server receives per second, and largely follows in step to how hectic your server’s CPUs are. Usually speaking, over 1000 batch requests per second specifies a very eventful SQL Server, and could mean that if you are not already suffering a CPU bottleneck, that server may very well soon. Unquestionably, this is a comparative number, and the higher your server hardware, the additional batch requests per second SQL Server can serve.

From a network traffic jam approach, a classic 100 Mbs network card is only able to handle about 3000 batch requests per second. If you have a server that is this demanding, you may need to have two or more network cards, or go to a Gbs network card.

Several DBAs use the Transaction/Sec Total to measure total SQL Server commotion, but this is  a bad idea. Transaction/Sec only processes action that is inside a transaction, not all movement, producing crooked results. In its place, continuously use the SQLServer: SQL Statistics: Batch Requests/Sec counter, which events all SQL Server commotion.

One by one we will see all these counters

DBAWorkDatabase support, Database services, Oracle ADF



Car Run on Air … Going to hit Indian Road by Aug 2012

Posted in General with tags , , , , , , , on November 26, 2011 by DBAWork

— 50 rupees per 100 KM
— top speed of 105 KM per hour
— around 300 km or 185 miles between refuels
— A fill up will only take two to three minutes
The Air Car, technologically advanced designed by ex-Formula One engineer Guy N. For Luxembourg-based MDI, uses compacted air to thrust its engine’s pistons and make the car go.

The Air Car, entitled the “Mini CAT” could cost around 365,757 rupees in India or $8,177 US.

The Mini CAT which is a simple, light urban car, with a tubular chassis, a body of fiberglass that is bonded not welded and motorized by compressed air. A Microprocessor is used to controller all electrical functions of the car. One tiny radio transmitter sends instructions to the lights, turn signals and every other electrical device on the car, which is not several.

The temperature of the clean air expelled by the exhaust pipe is between 0-15 degrees below zero, which makes it suitable for use by the internal air conditioning system with no need for gases or loss of power.

There are no keys, just an access card which can be read by the car from your pocket. According to the designers, it costs less than 50 rupees per 100 KM, that’s about a tenth the cost of a car running on gas. It’s mileage is about double that of the most advanced electric car, a factor which makes it a perfect choice for city motorists. The car has a top speed of 105 KM per hour or 60 mph and would have a range of around 300 km or 185 miles between refuels. Refilling the car will take place at adapted gas stations with special air compressors. A fill up will only take two to three minutes and costs approximately 100 rupees and the car will be ready to go another 300 kilometers.

This car can also be filled at home with it’s on board compressor. It will take 3-4 hours to refill the tank, but it can be done while you sleep.

Because there is no combustion engine, changing the 1 liter of vegetable oil is only necessary every 50,000 KM or 30,000 miles. Due to its simplicity, there is very little maintenance to be done on this car.

This Air Car almost sounds too good to be true. We’ll see in August. 2012

Database supportDatabase support, Database services, Oracle ADF

Why IE losing markets share?

Posted in General with tags , , , , , , , on November 5, 2011 by DBAWork

IE can no longer entitlement more than half of the web’s transportation, as of October, completion more than a decade era of the default Microsoft browser’s reign.

Safari’s hold on 62.17% of traveling traffic has reduced IE’s largely share of web surfing, even though still ask for 52.63% of desktop transportation, according to Netmarketshare.com.

The IE’s shrinking share (49.6%) echoes its near nonexistence from the realms of mobile and tablet, which now make up 6% of web transportation. Still, probabilities are, you gave up on IE long enough ago that this landmark makes you more probing as to who actually still uses the browser.

Does this mean the termination of IE as we discern it? Not at all. As specified, straight with it tumbling under the intermediate point in terms of norm, at 49.58 percent of the market share, IE still holds further users than the other listed browsers. According to the report from NetMarketShare, via FavBrowser.com, Internet Explorer’s two major challengers, Firefox and Chrome, have a collective market share of 37.8 percent. It’s only after you sum in the stretch of Safari, Opera and the ubiquitous other browser (8.54%, 1.49%, and 2.59%), does the entire figure conceal IE’s share.

As of Oct, Firefox is the subsequent further most widespread web browser, counting for 21.20% of traffic, charted by Google Chrome and Safari, which account for 16.60% and 8.72% individually.

Database SupportDatabase support, Database services, Oracle ADF

Wi-Fi System – Does it needs improvement?

Posted in Uncategorized with tags , , , , , , , , , , on October 29, 2011 by DBAWork

As the world is becoming small with more usage of internet, companies setup Wi-Fi system in their campus to have ready available of internet for their employee, guest.

With these Wi-Fi systems the campus of the company gets converted into work area. You can work while you are taking a cup of coffee in cafeteria. You don’t have to bother about the mail; because you can connect your Smartphone’s to Wi-Fi system and access them at any place. Vendor or visitors can access internet through the wi-fi system.

One survey was done to check the Wi-Fi status in upper management circle. Some of surprising things can be observed from this survey.

10% of companies don’t have Wi-Fi network.

Like companies are very careful while delegating the wi-fi access. They don’t want any other person to go into their network. One more thing which we need to understand is that, they feel it is not that secure to provide access.

25% companies have secured wi-fi network.

Companies provide guest access with secured authentication. For guest access as well you need to authenticate your self.

5% of companies don’t provide guest access

These companies have wi-fi but they don’t provide guest access. This means not guest or not secured authenticated network for the outsider.

These were problem with the older wi-fi system. The re-new Wi-Fi system can have separate guest network, which will be separated from corporate network. The mobile device are more ‘aggressive’ in usage of wi-fi system, rather than laptop.  In the university campus it is like one particular video needed to be accessed by many students. As the Wi-Fi system is not intelligent system, it goes to access each and every request.

Wi-Fi companies are working on these area, wi-fi is not just a wireless connectivity it has become more than that.

Database Support, DBAWorkDatabase support, Database services, Oracle ADF

World will go back to analog age

Posted in Uncategorized with tags , , , , , , , , , , on October 28, 2011 by DBAWork

As we know the digital equipments can hold only zero and one, which makes boundaries for its working in computer. Since the flash drive and RAM can’t hold the data after power failure, we need to let server come back to normal state. We can’t think of starting working when we have shutdown the system. Because of this ram and hard disk the computer are bulky in size.
Now there is a good news, a revolutionary news which will make your computer to fit in your pocket, still it will run 10 to 20 times faster than what we have. We don’t need to restart the computer after the computer is shut down because of some power failure. The technology we are talking about is very chip.

It is called as Memristor.

This is analog device. It can remember how much current has passed thought it. And by alternating the amount of current that passes through it, a memristor can also become a one-element circuit component with unique properties. Most notably, it can save its electronic state even when the current is turned off, making it a great candidate to replace today’s flash memory.

Memristors will tentatively be cheaper and far quicker than flash memory, and allow far superior memory densities. They could also substitute RAM chips as we know them, so that, after you turn off your workstation, it will remember accurately what it was doing when you turn it back on, and return to work immediately. This lowering of cost and consolidating of components may lead to inexpensive, solid-state computers that fit in your pocket and run many times quicker than today’s PCs.
In the future the memristor could spawn a whole new type of workstation, thanks to its capability to remember a range of electrical states rather than the one-dimensional “on” and “off” states that today’s digital processors be acquainted with. By operational with a dynamic range of data states in an analog mode, memristor-based computers could be proficient of far more difficult tasks than just shuttling ones and zeroes around.
Researchers say that no real barricade prevents implementing the memristor in circuitry straight away. But it’s up to the business side to push products through to business reality. Memristors made to replace flash memory (at a lower cost and lower power utilization) will likely appear first; HP’s goal is to offer them by 2012. Beyond that, memristors will likely swap both DRAM and hard disks in the 2014-to-2016 time outline. As for memristor-based analog computer, that step may acquire 20-plus years.

As this going to affect the every part of system, it will affect the database as well.

Database Support,DBAWorkDatabase support, Database services, Oracle ADF

DB2PD – Diagnosing a lockwait

Posted in DB2 with tags on September 1, 2011 by DBAWork

In RDBMS database, to validate data integrity, it has concept called as lockwait. Lockwait goes like wait on lock to be released by another application. The time which is need to get hold of perticular resource by holding lock is measured in time.

DB2 has tool which provides a way to diagnose lockwait condition. Following is example of this.

If you run db2pd -db databasename-locks -transactions -applications -dynamic, the results are similar to the following ones:

Address            TranHdl Lockname                   Type Mode Sts Owner Dur HldCnt Att    ReleaseFlg
0x07800000202E5238 3       00020002000000040000000052 Row  ..X  G   3     1   0      0x0000 0x40000000
0x07800000202E4668 2       00020002000000040000000052 Row  ..X  W*  2     1   0      0x0000 0x40000000

For the database that you specified using the -db database name option, the first results show the locks for that database. The results show that TranHdl 2 is waiting on a lock held by TranHdl 3.

Address            AppHandl [nod-index] TranHdl Locks State Tflag      Tflag2     Firstlsn       Lastlsn        LogSpace SpaceReserved TID            AxRegCnt GXID
0x0780000020251B80 11       [000-00011] 2       4     READ  0x00000000 0x00000000 0x000000000000 0x000000000000 0        0             0x0000000000B7 1        0
0x0780000020252900 12       [000-00012] 3       4     WRITE 0x00000000 0x00000000 0x000000FA000C 0x000000FA000C 113      154           0x0000000000B8 1        0

We can see that TranHdl 2 is associated with AppHandl 11 and TranHdl 3 is associated with AppHandl 12.

Address            AppHandl [nod-index] NumAgents CoorPid Status        C-AnchID C-StmtUID L-AnchID L-StmtUID Appid

0x07800000006879E0 12       [000-00012] 1         1073336 UOW-Waiting   0        0         17       1         *LOCAL.burford.060303225602
0x0780000000685E80 11       [000-00011] 1         1040570 UOW-Executing 17       1         94       1         *LOCAL.burford.060303225601

We can see that AppHandl 12 last ran dynamic statement 17, 1. ApplHandl 11 is currently running dynamic statement 17, 1 and last ran statement 94, 1.

Dynamic SQL Statements:
Address            AnchID StmtUID NumEnv NumVar NumRef NumExe Text
0x07800000209FD800 17     1       1      1      2      2      update pdtest set c1 = 5
0x07800000209FCCC0 94     1       1      1      2      2      set lock mode to wait 1

We can see that the text column shows the SQL statements that are associated with the lock timeout.

Database DB2 Support, DBAWorkDatabase support, Database services, Oracle ADF

Quick Reference for DB2 installation

Posted in DB2 with tags on September 1, 2011 by DBAWork

Please follow this process to install DB2 V9.1.


Login as root to this system. As we need to create certain user group and users. Following commands will allow you to create user with needed path for home directory. We will need to create user and set its password as well.
* Create groups:
o groupadd -g 999 db2iadm1
o groupadd -g 998 db2fadm1
o groupadd -g 997 dasadm1

* Create users for each group:
o useradd -u 1004 -g db2iadm1 -m -d /home/db2inst1 db2inst1
o useradd -u 1003 -g db2fadm1 -m -d /home/db2fenc1 db2fenc1
o useradd -u 1002 -g dasadm1 -m -d /home/dasusr1 dasusr1

* Set password for each users created:
o passwd db2inst1
o passwd db2fenc1
o passwd dasusr1

* cd to installation file directory:
o Example: /tmp/db2/exp/disk1

* Run installation script:
o ./db2_install.sh

Post Install

* Login as root.
* Install license (example):
o /opt/ibm/db2/V9.1/adm/db2licm –a /tmp/db2/exp/disk1/db2/license/db2exp_uw.lic

Create the DB2 Administration Server (DAS)

* Login as root.
* Create DAS with dasusr1
o /opt/ibm/db2/V9.1/instance/dascrt -u dasusr1

* Login as dasuser1
o Start the DAS: db2admin start

* Optional: to enable autostarting of the DAS upon reboot
o /opt/ibm/db2/V9.1/instance/dascrt/dasauto –on

Create DB2 instance

* Login as root.
* Create instance with users db2fenc1 and db2inst1:
o /opt/ibm/db2/V9.1/instance/db2icrt -a server -u db2fenc1 db2inst1
* Optional: enable autostarting of the db2inst1 instance
o /opt/ibm/db2/V9.1/instance/db2iauto –on db2inst1

Update environment variables

* Example:
* Login as db2inst1
* edit .bash_profile
o vi /home/db2inst1/.bash_profile
o insert the following line at the end of the file – “. /home/db2inst1/sqllib/db2profile”

* Do the same for dasusr1, using its corresponding directory.

Database service

* Login as root:
* Add new service entry:
o vi etc/services
o insert this line “DB2_TMINST 50000/tcp” at the end of the file


* Login as db2inst1
* List installed DB2 products and features: db2ls
* Display the default instance: db2 get instance
o Result: The current database manager instance is: db2inst1
* Start the database instance: db2start
o Result: SQL1063N DB2START processing was successful.
* Stop the database instance: db2stop
o Result: SQL1064N DB2STOP processing was successful.

Remote Database Support,DBAWorkDatabase support, Database services, Oracle ADF