SQL 7 Tuning

[Brian]

i need to know how to tune a SQL7 database from profiler and Query analyzer.

EG: point Query Analyzer at the profiler output to find the best solution
to tune.

I think this is what i should be doing.

Any other solutions Welcome

Cheers

[Michael Levy]

There is all kind of materials to help you. You can start with the
following:

Inside SQL Server 7.0 (Delaney)

SQL Server 7.0 Performance Tuning Technical Reference (DeLuca)

http://www.microsoft.com/sql/techinfo/perftuning.htm

http://www.sql-server-performance.com/

-Mike
--
Michael Levy MCDBA, MCSD, MCT
michaell@gasullivan.com