Re: Slower MS SQL server

Dale E. Reed Jr. ( (no email) )
Mon, 8 Dec 1997 10:31:54 -0800 ()

On Mon, 8 Dec 1997 (Jeff Binkley) wrote:

> 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. (
IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
Internet Solutions for Today |