Extremely slow response in Sybase central 9.0
thomas....@tinker.af.mil
the order of several minutes when I click the "Table" folder before it
will expand to show the table list, and sometimes a minute to display
table layouts when I click on the table name. I have looked at
everything I can think of, and checked for other processes hoggin the
CPU, antivirus, etc. with no obvious cuplrits. Can anyone suggest
something I have missed? (Note: the machine I am using was inherited
from someone else, but I have not found anything that would cause this
type of problem).
Breck Carter [Team iAnywhere]
occurring. See if scview is consuming the CPU or dbeng9.
It may be that scview is not getting enough memory... it's a Java app
and while I wouldn't call if *fat*, let's just say it hasn't seen a
byte it didn't want to eat :)
Your experience is *not* the expected. Tell us more about the
versions, OS, RAM etc.
Breck
--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
breck....@risingroad.com
thomas....@tinker.af.mil
1GB RAM
45GB Free space on HD
Sybase ASA 9 database, 749MB is size
Watching process memory usage, scjview is using between 0 and 5% of CPU
time, dbeng9 not even that. Memory usage for scjview is working
between 29 and 35 MB. Totla memory committed is around 700MB. I DO
see scjview making IO Writes during the process of expanding the table
folder, but no corresponding writes in the dbeng9 process. Could I be
hitting the windows page file more that I should?
David Kerber
In article <1168545936.3...@77g2000hsv.googlegroups.com>,
thomas....@tinker.af.mil says...
--
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).
thomas....@tinker.af.mil
the test database is on my machine. Watching the antivirus process in
Taskmanager, it IS making some IO activity, but nothing compared to
scjview or dbeng9. I tried using different databasees, all woth the
same result.
Breck Carter [Team iAnywhere]
Manager say about memory usage? Is RAM full of stuff? Has all the RAM
been allocated to, say, the dbeng9 cache?
Check the Task Manager settings to make sure you are seeing all the
processes, plus all the columns of interest.
Is the hard drive light on solid?
Breck
Breck Carter [Team iAnywhere]
On 11 Jan 2007 12:05:39 -0800, thomas....@tinker.af.mil wrote:
Breck Carter [Team iAnywhere]
posting...
"Sir, you'll have to come with us." <bg>
Breck
On 11 Jan 2007 12:05:39 -0800, thomas....@tinker.af.mil wrote:
thomas....@tinker.af.mil
All processes listed (50) I can identify as being valid and known.
dbeng9 shows 20MB usage, VM size of 267MB
scjview shows 30MB usage, VM size is 35MB
hard drive is not being hit hard, that I can tell - although I see IO
write activity from scjview when a table is selected for detail view.
I doubt it is spyware - this is a US Airforce machine, and it is
constatly scanned and verified every night.
I am stumped - I think I will request a new, improved machine...
David Kerber
thomas....@tinker.af.mil says...
> It should not be the firewall, I am not making any network accesses -
> the test database is on my machine. Watching the antivirus process in
> Taskmanager, it IS making some IO activity, but nothing compared to
> scjview or dbeng9. I tried using different databasees, all woth the
> same result.
One thing I would try is to exclude the .db files from the antivirus
realtime scanning. That and the memory suggestions that others have
mentioned may make a big difference.
....
Breck Carter [Team iAnywhere]
Trying a different machine is probably is probably the most
cost-effective approach.
Breck
Paul Horan[TeamSybase]
news:1168543746....@77g2000hsv.googlegroups.com...
I'm one of the System Consultants with the Federal Solutions group in
Bethesda. Our group manages all the DoD accounts - so I'm picking up the
ball on this one...
If you want to give me a call tomorrow, I might be able to assist with the
problems you're seeing.
Paul Horan[TeamSybase]
(301) 896-1080
phoran AT sybase.com
Chris Keating(iAnywhere Solutions)
help file open?
--
Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8
*****************************************************************************
Sign up today for your copy of the SQL Anywhere Studio 9 Developer
Edition =and try out the market-leading database for mobile, embedded
and small to medium sized business environments for free!
http://www.ianywhere.com/promos/deved/index.html
*****************************************************************************
iAnywhere Solutions http://www.iAnywhere.com
** Please only post to the newsgroup
** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com
*****************************************************************************
Reg Domaratzki
Sybase Cental to a crawl, which is exactly what you are seeing.
Reg
<thomas....@tinker.af.mil> wrote in message
news:1168543746....@77g2000hsv.googlegroups.com...
thomas....@tinker.af.mil
Sometimes you just have to ask "How can I be so brainless when I am so
smart??"