ASE 15 Performance and Tuning GuidesGreetings,
Does anyone know when the updated ASE 15 versions of
"Performance and Tuning Guides" will be released?
The guides on sybooks are for ASE12.5.1
Thanks in advance.
Alberto
> Greetings,
>
> Does anyone know when the updated ASE 15 versions of
> "Performance and Tuning Guides" will be released?
I *think* that they were supposed to be released sometime
later this year, but I don't have any clear information.
Michael
I'm not aware of when these will be released. I'm guessing some time after the
15.0.2 release.
Ho...
Performance implications of ID burning set factorI would like to reduce the identity burning set factor to reduce the size
of identity gaps following a shutdown with nowait.
Clearly this has a performance implication, but I wonder if this really is
significant. Does anyone have any experience of whether it is?
I am using identities of numeric(10,0) and propose to reduce the burning
set factor from 5000 to 1 - i.e., get 1000 IDs at once.
Insert volumes are ~ 5000 per week, with weekly (normal) server reboots.
My own feeling is that the performance overhead will be negligible,
especially when compared to the alternative, w...
ASE performanceHi,
I'm new to Sybase, so excuse me if this is a stupid
question, and I guess I might not supply enough information
to make an informed judgement ...
We've got ASE 12.0 running on a Sun Sparc server with 2 x
450Mhz processsors and 2 gig RAM + RAID. We run a script
which updates a join table - i.e. a table with two integer
columns with keys in them. The sql script inserts a total of
1.8 million rows into the table and the entire operation
takes around 18 minutes to complete.
Does this sound like reasonable performance - it feels slow
to me, but I don't have any comp...
Performance tuningHi,
We are using Jconnect 6.0.5 (latest EBF). We found that
'select db_name' was getting called before each and every
sql update/insert.
We are not sure why it is doing this. We need to prevent
this unnecessary db call. Does any one have any idea
Thanks
Lachu
Hi Lachu,
This sounds like some JDBC Call might be happening in your application -
offheand I don't
know exactly what, but something like Connection.getCatalog()
I don't think jConnect caches this sort of thing - so it might be the
application code makes the call for each command execution.
If yo...
Tuning PerformanceWe intalled a Sybase IQ 12.5 on a HP-UX, we have a IQ
database of 255 GB, some of the querys are very slow,
please, what are the main aspects that we have to look for
to get a better performance ??.
Thanks.
Jorge
main things (imho):
indexes, optimization of memory usage, iqtc 60% of memory.
The rest need to see more info about your tables, indexes, query plan, type
of querys, HW etc
<Jorge del Mar> wrote in message news:416ae5e2.6071.1681692777@sybase.com...
> We intalled a Sybase IQ 12.5 on a HP-UX, we have a IQ
> database of 255 GB, some of the querys are very ...
ASE PerformanceDear all,
I'm using ASE 11.9. Does anyone know which is the most efficient whay to
speed up the ASE server ? I have a stored procedure carries out following
things using a CURSOR:
- Read record from table_a
- Do some data manipulation to the record read
- Insert record to table_b if record is not exist in table_b
- Update record to table_b if record is exist in table_b
table_a contains around 40,000 records and table_b contains around 300,000
records.
Originally, my coding in the stored procedure is as follow:
SELECT .... FROM table_b WHERE ...
IF @@rowcount > 0
...
ASE performanceHi there, ask a rather beginner question here.
we have this ASE12.0 on Solaris 7. it's a enterprise 3000
machine, with 1G RAM, 2 CPUs both 168MHz. via /etc/system
assigned 800M to ASE. All other settings in the configure
file are mostly DEFAULT.
we donot have many concurrent users on system most of the
time, and the workload/ transaction is not very high. (most
time, just 50 to 60 users online).
however, lately users complains performance problem. esp
just only one user was running a little big large report.
and when I check sp_lock, actually very few locks, and just
some shared...
performance tuningHi, All,
I run select * statement from a view on both ASE11.5 and ASE12. The speeds
for returning the value are very different. On ASE11.5, it only takes 1min
while on ASE12, it takes 30min.
ASE12 has bigger data caches for the database and tempdb than what the
ASE11.5 has. Both of them have the same indexes. After I run sp_sysmon on
ASE12, in the report of data cache management, ASE12 has high cache hit
ratio (that is good) and high pool turnover (no good). Does that mean I
need to increase the data cache for ASE12? I also noticed that in OS, ASE12
has very tight free mem...
Performance and TuningI have a pb application running on sybase db.
It is very slow.
We used PFC for developing the application.
I would like to know what is the best to way to tune the performance of the
application.
Any ideas are greatly appreciated .
Thanks in advance..
Leo
Leo,
From my experience, performance problem mostly due to inefficient SQL
statement. Check which SQL statement caused the problem and then tune that
SQL.
Hope this can help.
Leo <Spamoff_Leo@yahoo.com> wrote in message
news:bn7hXf#LAHA.260@forums.sybase.com...
> I have a pb application running on sybase db...
Performance Tools
Dear All,
I am having difficulty that after I complete a project and run the performance tool, by looking at the report, I do not know whether it's performing well, as there is no benchmark for me to refer to.
Is there any guide that how to consider the performance is not up to the satisfactory level? Or is there any benchmark that how many bytes of allocated memory is considered unacceptable that we need to look into?
Regards,Shelyn...
Performance monitor and performance counters
I'm trying to figure out why performance counters won't work on my machine. We've got 2 windows 2003 servers, and if I try to access ANY of the performance counter related objects in the System.Diagnostic namespace I get this:
Insufficient memory to continue the execution of the program.
at System.Runtime.InteropServices.Marshal.AllocHGlobal(IntPtr cb)
at System.Diagnostics.PerformanceMonitor.GetData(String item)
Of course the call stack is actually larger than that, but the point is right here. The same code works fine on any of our XP or 2000 Pro boxes. Anyone know wha...
performance tuningHi, All,
I run select * statement from a view on both ASE11.5 and ASE12. The speeds
for returning the value are very different. On ASE11.5, it only takes 1min
while on ASE12, it takes 30min.
ASE12 has bigger data caches for the database and tempdb than what the
ASE11.5 has. Both of them have the same indexes. After I run sp_sysmon on
ASE12, in the report of data cache management, ASE12 has high cache hit
ratio (that is good) and high pool turnover (no good). Does that mean I
need to increase the data cache for ASE12? I also noticed that in OS, ASE12
has very tight free mem...
Performance TuningThis is a multi-part message in MIME format.
--------------080804050908060708060306
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
32-bit ASE 12.5
Solaris 8
1)
I am running a number of stored procedures ... and have a few problems
with the performance.
It uses a few temporary tables. The stored procedure calls other stored
procedures in a loop. By calling getdate() before and after each stored
procedure call ... there was really nothing much that the sps ... do
..... almost everything completes execution in less than second.
...
Performance tuningIs there a way to create and analyze some kind of trace files with SQL
Anywhere 5.5?
I have a program that issues "generated" SQL statements. I'd like to
quickly look for those that create full table scans in any of the used
tables to see if I can optimize data access.
TIA
Peter
Peter Hiemenz
Hilden, near Duesseldorf
Germany
I wrote something like this a couple months back. It interrogates the
trace file that PowerBuilder produces. It's rather proprietary since
it's one of the tools that I use when I do Performance & Tuning
cons...