How can we minimize logical and physical IO in ASE?
> > How can we minimize logical and physical IO in ASE?
> truncate table <tablename>
> -am ? 2003
For the time the DBMS is totally doing no logical or physical IO,
we could have the users, application designers and DBAs read the
Sybase tuning documentation so that when the powers that be interfere
with the 100% decrease in IO, they would have the basic grounding
in minimizing IO while still *using* the DBMS...
I am running SQL 7.0 sp 2 on Windows 2000 Advanced Server.
The "SQLAgent - Alert Engine" process running on msdb continually increases
its Physical_io until it eventually chokes the server.
The Inputbuffer result of this process is:
I do not have any alerts set up, barring the defaults that are set up with
the installation. I am not sure of what this process is doing, and why it
does not clear itself down occasionally.