http://goo.gl/EmKxy0

Archive

Posts Tagged ‘SAP’

Performance Issue

June 24th, 2012 No comments

Few days back I have faced performance issue in one of our prod data server. I would like to share here.

User was running batch for pushing 90000 rows in a database and batch was not moved from last 1.5 hrs.

On login in the server I found response of the server was not good, it was taking more time to execute a simple query as usual. In first glance, it was looking like user job is hogging the resources, as user job spid was in syslogshold and not moved from long time.

We do some analysis and finally found the cpu usage for server was 100%. ( I used sp_monitor). I concluded that this high cpu usage is slowing down the server performance.

The next task was finding the query which was taking more cpu time. As server was on 15 version, I ran the below sql querry for mon tables for getting the high cpu usage.

select top 10  s.SPID, s.CpuTime, t.LineNumber, t.SQLText from master..monProcessStatement s, master..monProcessSQLText t where s.SPID = t.SPID order by s.CpuTime DESC

http://sybaseblog.com/sybasewiki/index.php?title=Query_-_Which_currently_executing_queries_are_consuming_the_most_CPU_%3F

We asked application team to check the reported spid and if possible, please abort the tran. There was select queries which were  taking maximum cpu . As they requested us to kill, we aborted/killed from data server.

After few seconds, data server cpu started fluctuating from 50 to 100% and finally it was below 50%.

Application batch of 10K inserts moved very quickly and finally issue resolved.

You can get full details on MDA queries @ http://sybaseblog.com/sybasewiki/index.php?title=Category:MDA_Table_Query

Thanks.

Sybase ASE Database: Cost Considerations and Advantages

June 22nd, 2012 No comments

Recently SAP contracted with IDC to conduct a study of relational database management (RDBMS) users to determine the cost factors encountered by those users in running a relational database, and the extent to which (if any) Sybase ASE could save users money in running their systems. IDC recruited 12 organizations that were willing to let us examine deeply their costs in running both Sybase ASE and other RDBMS products.

IDC asked a number of detailed questions regarding the organizations’ use of database software, their staffing costs, their hardware costs, and their software license and maintenance costs. IDC then analyzed the data using a well-established five-year model for calculating total cost of ownership (TCO), and came to some compelling conclusions.

Read More : http://blogs.sap.com/sme/2012/06/21/sybase-ase-database-cost-considerations-and-advantages/#comment-3116

Categories: ASE, News Tags: , , , ,

SAP Becomes Fastest-Growing Vendor in Relational Database Market

June 8th, 2012 No comments

WALLDORF, Germany, June 7, 2012 /PRNewswire/ — SAP AG (NYSE: SAP) today announced it is the fastest-growing among the top vendors in the relational database management systems (RDBMS) market, according to a new report(1) from IDC.

 

Source & Complete  Report @http://www.itnewsonline.com

Categories: ASE, Database, News, SAP, Start Sybase Tags: , , ,

Useful Sybase ASE Tools available for free download…

May 24th, 2012 No comments

I have started some time ago to distribute some tools I have created to assist me in my professional life as full-time production dba/sybase migration analyst/sybase database architect.

Some are years old, others are very fresh (the last developed two days ago).  There are additional tools that I will publish in the near future.  The aim of all of the tools is to make the life of a DBA/Analyst/Architect a bit easier.  Although I do by no means claim the position of the ASE tool guru – there are other tools available out there, some pretty costly.  The tools may be of some use for those having a particular need in view and lacking an alternative.

Not to repeat myself, I provide you the link to the description of each particular tool here.

There are so far 4 tools:  1st is aimed to use/learn the MDA tables better.  2nd to create pin-pointed monitoring of an ASE server a thing for novices, 3d aimed to make parsing of Sybase Sysmon reports a bit more convenient, and the last to be able to reuse all those handy queries DBAs accumulate over years with more ease.

Below are the tools, with screen-shots  & links.

1.  ASE Monitoring (MDA) Tables Assistant

2.  A Simple Graphical Monitor for Sybase ASE

3.  ASE System Report (Sysmon) Parser

4.  ASE Frequent QueryAssistant

You are welcome to use them and post comments.

ps.  I wish to thank the hosts of the present blog for the opportunity to use it to make the tools available to a greater public.

It was my pleasure to share.

Andrew T.M.

SAP will disclose its Database plans on April 10 in San Francisco !!

March 27th, 2012 1 comment

SAP aims to become major database software maker…

* Move will heat up rivalry with Oracle Corp

* May also put SAP at odds with IBM, Microsoft

* To disclose plans at April 10 press conference
German software maker SAP AG says it intends to become a major provider of database software in a move that would heat up its long-running rivalry with Oracle Corp, led by Silicon Valley billionaire Larry Ellison.

SAP said it will disclose its plans at an April 10 news conference in downtown San Francisco, not far from Oracle’s headquarters in Redwood City, California.

The German company is the world’s biggest maker of business management software, which includes programs that manage tasks such as accounting, manufacturing and payroll. While Oracle is the No. 2 player in that market, it sells more software, thanks to its leadership in the multi billion-dollar market for databases.

Source :: http://www.reuters.com/article/2012/03/15/sap-oracle-idUSL2E8EFBU520120315

http://www.zoneic.com/sap-plans-major-database-software-maker-ibm-microsoft-opponent.html

http://sp.m.timesofindia.com/PDATOI/articleshow/12290674.cms

http://misclassblog.com/database-design-and-development/sap-looking-to-take-over-database-market/

http://www.cloudbulletin.com/news/sap-plans-big-for-database-mkt-oracle-rivalry-to-go-fiercer

Oracle Reply : http://articles.timesofindia.indiatimes.com/2012-03-21/strategy/31219619_1_scott-behles-oracle-database-german-software-maker
See the Course Catalog on ASUG Annual Conference @  Orlando, Florida | May 14-16, 2012 , it is probable
SAP is planning to give complete Database Solution by SAP HANA platform, SAP Sybase Adaptive Server Enterprise, the SAP Sybase IQ server, and Sybase SQL Anywhere.

Lets wait on the clarity till Apr 10!!

Happy Reading !!