Archive

Archive for June, 2012

dbcc checkdb vs dbcc checkstorage

June 25th, 2012 No comments

Checkstorage will detect allocation errors, it is a reasonable substitute for dbcc checkalloc (checkstorage will report a fair number of issues that checkalloc will not, many of them trivial things, and checkalloc may be able to detect a few odd conditions
checkstorage does not.

What checkstorage won’t catch are issues with index tree (keys out of order, index entries that point to missing rows, rows
that are not indexed).  So checkstorage is not a good substitute for checkdb.

Source :www & sybooks.

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: , , , ,

Dynamically change the path of the ASE error log : sp_errorlog

June 19th, 2012 No comments

 It was really painful to change the error log file for a running production ASE server, you might require the reboot of ASE with business approved downtime. ( In one case when $SYBASE is getting full and you need to purge your log file)

Now you can take relief using sp_error for changing the errorlog dynamically without any down time. Its available from version V15.02 ESD4

sp_errorlog : Dynamically changes the path of the error log.

Syntax

sp_errorlog “change log”, “new_path”[,{“jslog true”| “jslog false”}]
sp_errorlog “help”, “change log”

Parameters
new_path – new path of the error log. Maximum length of new_path is 255 characters.

jslog true – the default option. If the Job Scheduler is running, change log attempts to change the Job Scheduler Agent log to the directory where the new Adaptive Server error log will reside. Both logs will indicate error messages, if any.

jslog false – do not change the location of the Job Scheduler Agent log.

Source : http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc00803.1502/html/NF1502ESD4/CHDBJEBC.htm

Categories: ASE 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: , , ,

Changing ASE Sort Order using sqllocres

June 6th, 2012 No comments
Task : Sort Order change of PROD_ASE_DS2 
Current Sort Order :50 Binary Sort Order (Server Default Sort Order)
New Sort Order : 51 Dictionary Based Sort Order
 
Before running any command , please import Sybase Enviorment in your current Shell, you can get the same by executing SYBASE.sh which resides in $SYBASE ( Sybase Installation Directory).
 
1. Started the Dataserver PROD_ASE_DS2 :
[sybase@localhost install]$ ./startserver -f RUN_PROD_ASE_DS2 ……………….. …………………… 00:00:00000:00001:2012/06/06 00:26:06.61 server ASE’s default unicode sort order is ‘binary’. 00:00:00000:00001:2012/06/06 00:26:06.61 server ASE’s default sort order is: 00:00:00000:00001:2012/06/06 00:26:06.61 server ‘bin_iso_1’ (ID = 50) 00:00:00000:00001:2012/06/06 00:26:06.61 server on top of default character set: 00:00:00000:00001:2012/06/06 00:26:06.61 server ‘iso_1’ (ID = 1). 00:00:00000:00001:2012/06/06 00:26:06.61 server Master device size: 30 megabytes, or 15360 virtual pages. (A virtual page is 2048 bytes.)

2. Checking the Current Sort Order of Server

[sybase@localhost install]$ isql -Usa -SPROD_ASE_DS2 -w999
Password:
1> select @@servername,getdate()
2>
3> go
———————————————————— ————————–
PROD_ASE_DS2 Jun 6 2012 12:26AM
(1 row affected)
1> sp_helpsort
2> go
Sort Order Description
————————————————————————————————————————————
Character Set = 1, iso_1
ISO 8859-1 (Latin-1) – Western European 8-bit character set.
Sort Order = 50, bin_iso_1
Binary ordering, for the ISO 8859/1 or Latin-1 character set (
iso_1).
Characters, in Order
————————————————————————————————————————————
! ” # $ % & ‘ ( ) * + , – . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?
@ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ ] ^ _
` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~ Â
¡ ¢ £ ¤ Â¥ ¦ § ¨ © ª « ¬ ­ ® ¯ ° ± ² ³ ´ µ ¶ · ¸ ¹ º » ¼ ½ ¾ ¿ Ã
à à à Ã
à à à à à à à à à à à à à à à Ã
à à à à à à à à á â ã ä å æ ç è é ê ë ì í î ï ð ñ ò ó ô õ ö ÷ ø ù ú û ü ý þ ÿ
(return status = 0)
1> exit

3. Moving in Sample Resource file Directory Read more…