You are not logged in or registered. Please login or register to use the full functionality of this Website SybaseTeam.Com...
Hello There, Guest! (LoginRegister) Remember Me? Current time: 09-01-2014, 05:58 PM
   Home  |  About Us  |  Sybase Training  |  Synergy  |  Consulting  |  Job Openings  |  Tech Videos  |  Rules and Disclaimer  |  Search
Post Reply 
Forum Tools
Loading of Database in Sybase ASE 15 is taking longer time on weekends.
02-19-2012, 01:33 PM
Post: #1
Quote this message in a reply
Loading of Database in Sybase ASE 15 is taking longer time on weekends.


Hi,

We used to perform DB refresh on a daily basis. Load usually takes 3 hrs to complete on weekdays. But on Sunday load is taking almost 12 hours to complete. recently we migrated from ASE 12.5 to ASE 15.0. Please let me know what are the steps that need to be followed for investigating this issue.Moreover there is no maintenance on this server.


Find all posts by this user
02-21-2012, 08:53 AM
Post: #2
Quote this message in a reply
RE: Loading of Database in Sybase ASE 15 is taking longer time on weekends.


1. Please check if there was any change in the loading script (change in no of stripes etc)
2. Please check backup server log to see what else was going on?
3. Please check vmstat/prstat data at OS level to see if you were running out of resources?


Find all posts by this user
02-21-2012, 09:07 AM
Post: #3
Quote this message in a reply
RE: Loading of Database in Sybase ASE 15 is taking longer time on weekends.


Is this problem arised after migration from 12.5 to 15. add "set comapatibilty_mode on" on your script and check if you get some benefit. setting this mode on will use optimizer options of 12.5.


Find all posts by this user
02-21-2012, 09:13 AM
Post: #4
Quote this message in a reply
RE: Loading of Database in Sybase ASE 15 is taking longer time on weekends.


Gopal,

Are you talking about the optimizer - compatibility mode in Sybase 15? I don't think it is applicable here.
Loading is carried out by backup server, not dataserver.


Find all posts by this user
02-21-2012, 01:07 PM
Post: #5
Quote this message in a reply
RE: Loading of Database in Sybase ASE 15 is taking longer time on weekends.


Hi John,

I am new to Sybase. Could you please let me know how to check for no of stripes, backup server log?


Find all posts by this user
02-21-2012, 08:43 PM
Post: #6
Quote this message in a reply
RE: Loading of Database in Sybase ASE 15 is taking longer time on weekends.


(02-21-2012 01:07 PM)raograjiv Wrote:  Hi John,

I am new to Sybase. Could you please let me know how to check for no of stripes, backup server log?

edit your script and check if there
dump database databasename to "location\dmp.dmp"
stripe on "location\dmp1.dmp"
stripe on "location\dmp2.dmp"
stripe on "location\dmp3.dmp"


Find all posts by this user
Post Reply 


Possibly Related Threads...
Thread: Author Replies: Views: Last Post
  Database Maintenance - A Perfect Overview mvsramarao 0 1,534 02-11-2013 01:46 PM
Last Post: mvsramarao
  Starting a Database server vinayp83 1 1,783 10-01-2012 08:05 AM
Last Post: DerekAsirvadem
  SQL script to calculate sybase database size ,data free,data used,log free,log used sybaseteam 8 38,740 08-10-2012 03:33 AM
Last Post: amby_1986
  Load of database taking long time raograjiv 2 2,465 08-06-2012 07:33 AM
Last Post: sarosh
  Getting Dump and Load Time of Databases jomyluke@rediffmail.com 2 2,093 07-11-2012 05:55 AM
Last Post: taker2001
  Feasible seperation of two database moonsong2008 3 1,691 04-15-2012 04:07 PM
Last Post: DerekAsirvadem
  Database device on NFS disk ranjitsybaseteam 2 2,371 11-28-2011 03:21 AM
Last Post: DerekAsirvadem
  Need sql for reading through each database rbulley 2 2,043 11-28-2011 02:16 AM
Last Post: DerekAsirvadem
  Minimum Master device and Master database size Joshi 2 3,575 10-05-2011 08:19 PM
Last Post: DerekAsirvadem
  How to Create new Database in ASE 15 jadeite100 2 3,653 10-04-2011 09:21 PM
Last Post: DerekAsirvadem

Options:
Forum Jump:


Contact Us | SybaseTeam | Disclaimer & Rules | Return to Top | Return to Content | Lite (Archive) Mode | RSS Syndication