Monday, March 10, 2014

WebPage Performance :: Monitor and optimization


Monitor Page Performance Monitor and optimization

I was developing site and think how to monitor and increase the performance. After discussing with some subject matter expert and with my QA friend (yes I am developer than also QA is my friend :- ) )
I found couple of ways to test the page performance. That I would like to share with you.

There are mainly three good tools to test this (as far as I know)

        2)      http://tools.pingdom.com/fpt/
        3)      http://gtmetrix.com/

Each one give us the great result, personally I like #1 google and #2 PingDom.

PingDom

Pingdom major the performance using  water fall mechanisam and provide the details.

Google

                Google analyze the page , do the load performance and give you result along with suggestion, It also give result for Mobile version as well.When I analyze the data for various website with google developer tool.

 I found that Java script, CSS can also increase the loading speed , also image is very crucial part if we use image cleverly than performance can be increase significantly    


Below are one snap shot of Google Developer tool for page speed.



As always your suggestions are welcome and you can write your feedback in below comment or you can email me on viralpala@gmail.com


Wednesday, February 19, 2014

Performance Tuning : SQL Server Part -1

Performance Tuning : SQL Server Part -1


I always prefer to create index many does not agree but I believe this is the step where you don’t need to build no deployment and no code change , so why should we not try ?
There are two type of Index basic index and one more hybrid

           1)      Cluster Index
           2)      Non Cluster index
               *      covering indexes (may be New but interesting)

So first look into each and every table and create Primary Key, because primary key will automatically create cluster index and “select “execution will become fast

Create non-clustered indexes on columns which are:

  • ·         Used to join other tables
  • ·         Frequently used in the search criteria
  • ·         Used in the ORDER BY clause
  • ·         Used as foreign key fields
  • ·         Of having high selectivity (column which returns a low percentage (0-5%) of rows from a total number of rows on a particular value)
  • ·         Of type XML (primary and secondary indexes need to be created; more on this in the coming articles)


Now what if you want to search employee with his name and designation + LocationFortunately, there is a way to implement this feature. This is what is called "covered index". You create "covered indexes" in table columns to specify what additional column values the index page should store along with the clustered index key values (primary keys). Following is an example of creating a covered index

CREATE INDEX NCLIX_Employer_EmpID--Index name
ON dbo.EmpMaster(EmpName)--Column on which index is to be created
INCLUDE(EmpDes, EmpLoc)--Additional column values to include

Now you created Index but what if it gives you performance in Test environment not in production ?
You will thought is it possible ? Yes it is possible because Sql engine generate different query plan based on
  • ·         Volume of Data
  • ·         Index variance
  • ·         Parameter Value in SQL SP
  • ·         Load

So is there any way to create same environment as production???
Yes…  
That’s call Database Tuning Advisor’s Help with Profiler.

1.       Use SQL Profiler to capture traces in the production server. Use the Tuning template (I know, it is advised not to use SQL Profiler in a production database, but sometimes you have to use it while diagnosing performance problems in production). If you are not familiar with this tool, or if you need to learn more about profiling and tracing using SQL Profiler, read http://msdn.microsoft.com/en-us/library/ms181091.aspx.


2.       Use the trace file generated in the previous step to create a similar load in the test database server using the Database Tuning Advisor. Ask the Tuning Advisor to give some advice (index creation advice in most cases). You are most likely to get good realistic (index creation) advice from the Tuning Advisor (because the Tuning Advisor loads the test database with the trace generated from the production database and then tried to generate the best possible indexing suggestion). Using the Tuning Advisor tool, you can also create the indexes that it suggests. If you are not familiar with the Tuning Advisor tool, or if you need to learn more about using the Tuning Advisor, read http://msdn.microsoft.com/en-us/library/ms166575.aspx.


R   Reference : One article in Tech general and by some R & D
y   
      you can write feedback on viralpala@gmail.com. 

Sunday, February 16, 2014

Save Millions of Dollars By Windows Azure to Speed up Genome Research


Hi Friends,

I just read an interesting article  and I would like to share some details with you.
Also in next few days I will share some AI (Artificial Intelligence  ) theory which I am preparing with my friend who is doing Phd in Mobile AI....

As of now below article is related to Azure....

A year ago at Virginia Tech researchers needed 2 weeks to analyze just 1 genome. Today, they can analyze 100 genomes each day. Why is this important? Scientists can learn more about our DNA and uncover more effective strategies for detecting, diagnosing, and treating diseases such as cancer. What’s helping to make this possible? An innovative solution developed by Virginia Polytechnic Institute and State University (Virginia Tech) that’s based on Windows Azure and the Windows Azure HDInsight Service.

There are currently an estimated 2,000 DNA sequencers generating around 15 petabytes of data every year.  Additionally, data volumes are doubling every 8 months, significantly ahead of Moore’s law of compute capability’s which is doubling only every 24 months.  Most institutions can’t afford to scale data centers fast enough to store and analyze all of the new information. To overcome this challenge, Virginia Tech developed a high-performance computing (HPC) solution with Windows Azure. It gives global researchers a highly scalable, on-demand IT infrastructure in the cloud that they can use to store and analyze Big Data, accelerate genome research, and increase collaboration.    

To make it easy for researchers to use the solution, Virginia Tech developed two cloud applications. One streamlines the creation of Genome Analysis Toolkit (GATK) pipelines (for DNA sequencing) using Windows Azure HDInsight. The other program simplifies the use of Hadoop MapReduce pipelines to automate data transfers and analyze information that resides on local and cloud-based systems in a hybrid scenario.

The new solution is saving Virginia Tech—and other organizations—millions of dollars because scientists pay only for the resources that they use. This includes Windows Azure Blob storage for temporary or long-term data storage and HDInsight clusters for on-demand HPC nodes. Provisioning a new resource takes just seconds.

Global scientists can also collaborate with less effort because they can now easily share insights and data sets virtually anytime, anywhere—and with any device. As a result, in the future scientists or doctors may be able to use the solution to develop custom treatments for individual patients faster, by engaging in genome analysis directly at hospitals.

Reference : SQL Server weekly ....

Monday, February 3, 2014

AngularJS (Part 1)

Are you curious about ng-JS (AngularJS)?
 AngularJS has custom elements and attributes
It uses dependency injection
AngularJS is a framework that helps you build front-ends(UI) for web-based applications.

“AngularJS is a prescriptive client-side JavaScript framework used to
make single-page web apps”



Core Features Of ng-JS (AngularJS)
Two Way Data Binding
Model View Whatever
HTML Templates
Deep Linking
Dependency Injection
Directives 
 

Two Way Data Binding.

      document.getElementById('yourName')[0].text = 'bob';

{{yourName}} -----DOM
    var yourName = 'bob';--------one place information
    ”$Scope enables two way data binding”
It makes it easy to change a value and effortlessly have it update the DOM.
No Repetition of code
No need to worry when to update DOM


MVVM Design
MVC Design Patterns
MVVM – Model View ViewModel



MVVM-How AngularJS is constructed?

 
 In the Part 2 we will explore more in details.
 If you have any comments than you can email me on viralpala@gmail.com

Tuesday, January 28, 2014

How to Pass PMP in First Try (Part 1)

On  January,2014, I have completed PMP exam. I would like to say thank you to each and every one who helped me in getting this certificate.

Now I thought to write blog on how to Pass PMP in First try…

     1)      What is PMP ?

PMP stands for Project Management Professional (PMP) is a credential offered by the Project Management Institute (PMI).

     2)      What you need before you apply for PMP ?
·        
       Bachelor Degree  + 4500 Hours of non over lapping Project Management Experience.  
·         35 PDU (professional development units (PDUs)) from registered REP.

    3)      How much time it will take ?

Depend upon your study time and experience , it took me 4 month. In this four month I read 2 hours during week days (Total 10 Hours) and 6 hours (total 12 hours ) during week end.

    4)      What is expenditure ?

·         PMI Fee : 129 $ + 10 $ (Application Fee) = 139 $
·         Training Fee : 100 $ - 300 $ depend upon from which REP you are taking training
·         Exam Fee : 405 $
·         Total Fee : 634 $ - 834 $

5) Is it mandatory to take Membership of PMI ?

No. It's not but I strongly suggest to take membership before you start.
reason is 

       1) If you are not member you need to pay 555 $ exam fee so it will be less if you become member and pay less fee, because you will get Member ship and exam fee in  545 $ but if you are not member you have to pay 555 $

     2)  you will get free copy of PMBOK 5 which is must need book.

     3)  you will get chance to be part of such a nice group.


   5)      First Step...

First step is you need to read PMBOK 5, once you get PMI membership you will get free copy of PMBOK which is specially licensed for only one , So I can not share this book with any one.
But once you get PMI membership you will get it free…

In My next article I will try to explain which other material you need to read and also which are the important and hard topic that you need to focus.


If you like this article than please make comment , if you don’t like please leave comment or email me on viralpala@gmail.com also let me know if I can help you in getting PMP certification .