> Our rule of thumb for Sybase w/128 megs of physical memory is to
> allocate 80 megs to Sybase. Have you fired up Performance Monitor to
> see where the paging activity is coming from (SQL server or NT) ? ALso
> does SQL server have an query profiling tools to let you know how
> effective the queries you are running are ? What is this database being
> used for (report, queries etc..) ? SOme type of breakdown would be
> helpful.
You can use Performance monitor to see the NT and SQL Server statistics.
I use it all the time and you can monitor all of the vital operations
to see whats causing the problems.
Dale E. Reed Jr. (daler@iea.com)
_________________________________________________________________
IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
Internet Solutions for Today | http://www.iea-software.com