Tuning of IIS for optimal performance
Tuning of IIS for optimal performance of CAP/Web Disable HTTP Logging to reduce server contention. Set HTTP Keep-Alives as true to ensure cookie sessions are last longer. Set Connection Timeout as 120 second. Figure: IIS – Web site node Enable HTTP Compression to save bandwidth. Enable HTTP static content cache. Figure: IIS – […]
Finding text string in response by LoadRunner
Sometimes, when you wish to find particular text string on a screen through code (without ending up in script failure in case of not-found) here is what you can do: 1. Use Savecount in Web_Reg_find web_reg_find(“Text=my string on Web Tours”, save count = rc1, LAST); // by now you are total number of occurrences in […]
IP Spoofing in LoadRunner Controller
Sometimes, your application works based on client IP. For example a public survey will require unique IP – it will deny multiple requests from single client IP. How would you load test such an application with 1000 Virtual Users in LoadRunner? IP Spoofing caters such situations. It sends requests to application from various client IPs […]
Database Performance Tip # 9
Do not use “select *…†or “insert into dbo.Table select…†(without explicit column list). Explicit column lists reduce disk I/O (no need to read system tables to identify columns), and are more maintainable when columns are added or re-positioned If a cursor is unavoidable, use a simple WHILE loop instead, to loop through the table, […]
Select Composite key colums from same table in VIEWs
While creating views keep it mind that columns of composite key should be select from a same table otherwise views will perform very slow. Recently while doing WFS GAC optimization we found that the root cause of slow problem was a view in which a composite key columns was selected from different tables. After updating […]
Ensure fields index exist when Joining
The query should be carefully written and getting sure that on joining fields index must exist otherwise serious performance issue can raise as data volume will increase. The recent example of such case is found in MBFSJ. The dayend was executing in 3 hours and after monitoring the process below query found that was consuming […]
Optimise database deployement
Regarding NFS data storage architecture following points are important to get maximum system performance. Database server must be recommended with multiple physical hard disks or SAN/NAS with RAID or multiple logical units. NFS data files should be deployed on multiple disks as much as possible. Index and Data Files should be on separate disks. Database […]
‘Where Clause’ may kill application performance
Regarding query optimization it is observed that in where clause below mentioned cases are often happened. Due to which existing index on filter column is not used by database engine and table is full scan which kills performance. So try to avoid these cases while writing a query. During Optimization of different NFS projects it […]
HSIN KUANG Chinese Restaurant, Gulberg, Lahore
HSIN KUANG is a Chinese restaurant located behind Empire Center, Gulber, Lahore. This was started by a Chinese national who named himself Steve (for easier remembering I think) Its a good restaurant. If you never been there then you must try it. Little too rowdy and little too crowdy. This post was viewed (17) […]
Combining non-standard protocols in a single script that are not listed in Multi-Protocol selection
There is a nice thread out there. check it out: http://www.loadrunnertnt.com/how-tos/combining-non-standard-protocols-in-a-single-script-that-are-not-listed-in-multi-protocol-selection/ This post was viewed (34) times.