ASE Slowdown in Application DB

What else should we look for?



Yesterday we had an incident in one of our production databases where all
access to application tables seemed to slow to a crawl, while access to the
system tables was OK as well as access to application tables in other
databases. When I looked at monProcess they were all in a wait state of 47 -
wait for read on buffer to complete. When we tried to kill some jobs, unless
they were being blocked, they did not seem to go away. We were never able to
find the cause of the slowdown and were only able to clear it by shutting
down ASE and restarting it.



The CPU performance was around 50 - 60 % when it is usually in the 85 - 95 %
range.



We are running ASE 12.5.2 on an IBM Intel platform with 8 CPU's and 8 GB of
memory under Windows 2000. ASE is running with about 2.5 GB of memory with
1.5 GB assigned to default cache.



Thanks

Jim Sleeman


0
Jim
1/18/2006 7:11:21 PM
sybase.ase.nt 1081 articles. 0 followers. Follow

1 Replies
368 Views

Similar Articles

[PageSpeed] 1

Jim Sleeman �:
> What else should we look for?
> 
> 
> 
> Yesterday we had an incident in one of our production databases where all
> access to application tables seemed to slow to a crawl, while access to the
> system tables was OK as well as access to application tables in other
> databases. When I looked at monProcess they were all in a wait state of 47 -
> wait for read on buffer to complete. When we tried to kill some jobs, unless
> they were being blocked, they did not seem to go away. We were never able to
> find the cause of the slowdown and were only able to clear it by shutting
> down ASE and restarting it.
> 
> 
> 
> The CPU performance was around 50 - 60 % when it is usually in the 85 - 95 %
> range.
> 
> 
> 
> We are running ASE 12.5.2 on an IBM Intel platform with 8 CPU's and 8 GB of
> memory under Windows 2000. ASE is running with about 2.5 GB of memory with
> 1.5 GB assigned to default cache.
> 
> 
> 
> Thanks
> 
> Jim Sleeman
> 
> 
How about the locks? Apply 12.5.3ESD4 first.

flybean
0
FlyBean
1/28/2006 3:33:17 PM
Reply:

Similar Artilces:

ASE to ASE
Hi, Is anyone out there doing ASE to ASE replication using SQL remote? If you are have created your own version of the SSEXTRACT utility to set up a replicant database in ASE rather than ASA? Or does anyone know if SYBASE has created a version SSEXTRACT for use with ASE to ASE replication? Thanks in advance Doug Trainer Hi Douglas, I thought the SQL Remote Replication support in ASE11.5 was meant for a consolidate-database only (by design)! At least that was what Sybase said when they announced support for SQL Remote technology support in ASE11.5. I will be happy to...

ASE and ASE
Could it be possible to take scripts from ASA and load them in an ASE Any information is welcome jean-fran�ois ASA supports a fairly large sub-set of Transact-SQL, so if you write your stored procedures and triggers in ASA using T-SQL, you should be able to create scripts that will run against both ASE and ASA. If you're planning to do this though, I would suggest developing your database schema against ASA, since everything you write in T-SQL in ASA will be supported on ASE, but the reverse is not true. Check out the section in the ASA documentation entitled "Tra...

ASA To ASE - VS
What are the differents in terms of configuring SQL Remote Between ASA to ASE and ASE To ASE ? You should start with the Help file and then ask specific questions: Data Replication with SQL Remote PART 5. Appendix APPENDIX A. Enterprise and Anywhere: Differences There are many differences, so begin there. -- David Fishburn Sybase Please only post to the newsgroup BH Ong <bhong@tm.net.my> wrote in message news:01bf4b98$33183580$7ccdc8c8@virtual-branch... > What are the differents in terms of configuring SQL Remote Between ASA to > ASE and ASE To ASE ...

ASE Migration From ASE 11.5.1 (NT) to ASE 12.9 on Win2003.
Need help to find Sybase's upgrade and migration docs on above subject? Thank you. ASE 12.9? Currently, no released versions of ASE are certified on Win 2003. ASE 12.5.1 will be certified when it is released later this year. Mark Kusma <Lily Maria> wrote in message news:3f497cad.367e.846930886@sybase.com... > Need help to find Sybase's upgrade and migration docs on > above subject? > Thank you. Thanks for the info. I would like to know if there's any online documentation on migration and upgrade plan of the ASE 11.5.1 to ASE 12.5.1? Do applica...

Dump from NT ASE 11.5 to NT ASE 11.5.1
I am having trouble dumping a 11.5 ASE database to a 11.5.1 backupserver. I have the remote backupserver listed in the 11.5 remote servers list. It works going from the 11.5.1 machine to the 11.5 machine. Is there a compatibility issue? Thank you for your time. Dax daj@abmdata.com What do you mean by 'having trouble'? Are you getting error messages? If so, what error messages? Any error messages in the backupserver errorlog? Is the dump command hanging? not completing? What is the actual dump command that you're using? Does the target tape/director...

migrate ase nt to ase linux
what is the fastest way to do the data transfer ? is there any specify data folders like in mysql that i can just copy over? Dump and load the database. -bret j wrote: > what is the fastest way to do the data transfer ? is there any specify data > folders like in mysql that i can just copy over? ...

Adding ASE to existing ASE-to-ASE Installation
I am using all ASE's in my SQLRemote setup. My current installation consists of a Consolidated ASE & 2 Remote ASE's. My attempt to add another Remote ASE to the existing installation consists of these steps: - Install the sqlremote system objects in the new Remote - Install the stable queues in the new Remote - Manually extract a bcp file of the shared table from the Cons server - Configure the Cons server for another subscriber - Configure the new Remote's shared table, publications, & subscriptions. - Manually b...

Passwords migration from ASE on NT to ASE on Unix
We are migrating our ASE servers from NT to Unix and trying to keep the logins and passwords, but it seems like is not posible across platforms (from NT to Unix). I was able to copy the syslogins data from a NT ASE server to another ASE NT server, but when I tried from Nt to Unix didn't work. Does someone know if there is a way to do it? Sergio No, the encryption is different on the two platforms. -bret Sergio.Nava wrote: > We are migrating our ASE servers from NT to Unix and trying to keep the > logins and passwords, but it seems like is not posible across...

Dump/Load (from ASE 12.5.4 to ASE 15.x) - VS.
Hi All, We are in the process of planning the upgrade of our ASE 12.5.4 dataservers to ASE 15.x. What is the most recommended way to upgrade ASE dataservers from ASE 12.5.4 to ASE 15.x? Potential options: 1) Install new instances of ASE 15.x and load database dumps from our ASE 12.5.4 dataservers to the newly installed ASE 15.x dataservers. - OR - 2) Use the ASE upgrade utility (sqlupgrade) to upgrade our existing ASE 12.5.4 dataservers to ASE 15.x. What are the Pros vs. Cons for loading a 12.5.4 database into a 15.x ASE dataserver versus performing an ASE dataserv...

Converting NT 11.5 ASE to a Solaris 12.5 ASE
We are trying to migrate a server running on Windows NT to a Solaris machine. The NT box is running ASE 11.5 and the Solaris box is running 12.5. So far, the only way we have came up with to migrate the data is bcp. The problem is we estimate this to be probably about a 6-7 hour process. Our shop runs 24*7*365 and unfortunately downtime is not something we get. In the past when we have migrated servers, we have used warm-standby which has worked really nicely. But in this case we can't run dump and load to populate the database. Has anyone been able to migrate an NT box to a...

Dump & Load (DB Migration from ASE 12.5 to ASE 15)
Dear All, What are the important points we need to take care while performing Dump & Load Migrations from Windows to Linux. We need to ensure logins, users, roles, and device fragments. Pleaes let me have expert views. Does Linux supports RAW Devices ? Regards KRV K.R.V wrote: > Dear All, > > What are the important points we need to take care while performing Dump & > Load Migrations from Windows to Linux. > > We need to ensure logins, users, roles, and device fragments. Pleaes let me > have expert views. In the past, I've bcp&#...

problems loading ASE 12.5 dump into ASE 15.0 DB
I'm having problems loading a 12.5 database dump into a 15.0 database. On the 12.5 database I do the following: dump database xxxxxx to "c:\temp\xxxxxxxxx.bkp" go Then on the 15.0 database I load the database: load database xxxxxx from "c:\temp\xxxxxxxxx.bkp" go The first strange thing here is the following: ---------------------------------------------------------- Jun 09 12:31:19 2006: Backup Server: 4.188.1.1: Database xxxxxxxxx: 655484 kilobytes (58%) LOADed. Jun 09 12:31:20 2006: Backup Server: 3.42.1.1: LOAD is complete (database xxxxxxxxxxx). ...

rep solaris ase 11.5.1 to nt ase 11.5/11.51
Help! I need to replicate 11.5.1 ase on Solaris 2.6 to ase 11.5 or 11.5.1 on nt on intel. Could you answer the following: 1) To move the initial data I would like to load the dump data from the Solaris server to Windows nt server. Can this be done? 2) Do my device definitions on the Nt side need to duplicate those on the Solaris side. 3) The repserver is on Solaris as well. I only have 11.5 on nt can get ase 11.5.1 on nt. Is this an issue. Do I need repserver on nt? Any known traps? george wrote: > Help! > > I need to replicate 11.5.1 ase on Solaris 2.6 to ase...

SQL Remote ASE
hi did anybody know when SQL Remote support blob (image, text) replicacion for ASE - ASE? our company need this feature. joan caceres electro sur este s.a.a. Hello Joan, Support for image and text replication with SQL Remote went in as of ASA 6 mainline, 6.0.01.1256, and SA maintenance 5.5.04 build 1938. Regards, Bob Bauer Sybase Technical Support jmcd wrote: > hi > > did anybody know when SQL Remote support blob (image, text) replicacion for > ASE - ASE? > > our company need this feature. > > joan caceres > electro sur este ...

Web resources about - ASE Slowdown in Application DB - sybase.ase.nt

Application - Wikipedia, the free encyclopedia
Text is available under the Creative Commons Attribution-ShareAlike License ;additional terms may apply. By using this site, you agree to the ...

Pre-Christmas job application rush hits Australian public service
Speed required for pre-Christmas job window opening for public servants. Check out who is hiring.

Cloud application adoption increases 71 percent in 2015
The adoption of cloud applications is soaring, up by 71 percent in the last year according to the results of a new survey. The latest Cloud ...

NASA is accepting astronaut applications, and this quiz will tell you if you qualify
... gone before, then you might want to sign up to be a NASA astronaut. On Dec. 14, for the first time in four years, NASA began accepting applications. ...

MBA: Mortgage Applications Decrease in Latest MBA Weekly Survey, Purchase Applications up 34% YoY
From the MBA: Mortgage Applications Decrease in Latest MBA Weekly Survey Mortgage applications decreased 1.1 percent from one week earlier, ...

German-Based Spirea Promotes Decentralized PV Applications In Uruguay
... Its technical operations specialist, Laurie Lawrence, pointed out that Uruguay [&hellip German-Based Spirea Promotes Decentralized PV Applications ...

ZTE to develop smartphone application processors in house
ZTE has stepped up its efforts to internally develop smartphone chipset solutions, aiming to re-capture the title as one of the top-three smartphone ...

Pre-K Applications Begin Jan 25, a Month Earlier Than Last Year, City Says
The DOE has moved the process up to Jan. 25 on the heels of a similar schedule shift for kindergarten. MANHATTAN — The application period for ...

NASA accepting applications for the position of 'astronaut'
Wanted ads aren't usually newsworthy, unless the company is NASA and the job is "going to space." The US space agency has started recruiting ...

IBM Takes on AT&T Managed Application, Hosting Services
AT&T’s networking, security and mobility solutions coupled with IBM Cloud offers companies a fully managed IT environment.

Resources last updated: 12/22/2015 2:35:17 PM